Blue Margin, Inc. helps companies improve their business performance using Microsoft’s Business Intelligence stack (including Power BI and SQL Server) and Cloud Computing software and services (Azure and Office 365). We believe in working hard, volunteering in our community, and enjoying life along the way.

WHY ARE WE LOOKING?

We are expanding our Microsoft Power BI team, and are looking for clever, creative, data-savvy people who are flexible and capable of putting themselves in the shoes of the client. Our growth means we are looking for people with great attitudes, who are fun to work with. It also means we provide an excellent opportunity for someone who is serious about learning and advancing their career.

The ETL Engineer's role is to develop and maintain reporting databases using the Microsoft stack, primarily in Azure, ensuring high levels of data availability. They will also evaluate and advise on database technology components, such as software, hardware, and networking. Finally, the engineer will assist in implementing and maintaining reporting dashboards across the organization.

We are seeking a candidate to work as a full-time employee in our local office in Fort Collins.  

Blue Margin has, and will continue, to take a conservative approach to keep our employees safe during the COVID-19 pandemic. Currently our workforce is remote, and any transition back to our office will be handled with caution and in accordance with local and federal guidance. 

Please note that we are interested in every qualified candidate who is eligible to work in the United States. HOWEVER, WE ARE NOT ABLE TO SPONSOR VISAS.  

RESPONSIBILITIES:

• Maintain data warehouses.
• Design and deploy data table structures, reports, and queries.
• Diagnose and resolve database access and performance issues.
• Assure security of data from external parties and for management of row-level-security within the organization.
• Plan and coordinate backup and disaster recovery setup.
• Develop, implement, and maintain change control and testing processes for modifications to databases.
• Develop and maintain database stored procedures, views, and functions that support reporting data models.
• Develop and maintain ETL processes.
• Produce ad-hoc queries that develop reports to support business needs.
• Create reports and data models using Power BI that meet business requirements.
• Provide data management support to users.
• Create and maintain technical documentation.

CANDIDATES MUST POSSESS THE FOLLOWING QUALIFICATIONS:

• At least one year or more of experience in development within the Microsoft/SQL stack.
• T-SQL experience
• Excellent verbal and written communication skills
• Ability to coordinate and work cohesively with a development team (no ‘code-loners’)
• Experience creating charts, graphs, dashboards in one or more of the following programs - Excel, SSRS, Power BI, Tableau, Qlik and/or similar programs
• Familiarity with cloud services (AWS, Azure (preferred), Google Cloud)
• Experience creating databases from the ground up
• In-depth understanding of data management (e.g. permissions, recovery, security, and monitoring)
• Comprehensive grasp of data visualization methods and data modeling for effective report creation
• Ability to construct and maintain data warehouses
• Familiar with SSMS and SSIS
• Experience with SSAS, Tabular-based reporting, and Tabular Data Models
• A broad understanding of data visualization methods and techniques
• Power Query ("M" language), and DAX language experience
• Professional presentation skills and the ability to present to audiences of 10-15 people
• Broad business experience with proficient ability to talk to executives in business terms
• Willingness to creatively engage with customers to come up with custom solutions
• Familiarity with Kimball methodologies of data warehousing
• Understanding of the difference between application database design and reporting database design

IDEAL CANDIDATES WOULD POSSESS THESE ADDITIONAL QUALIFICATIONS:

• Experience with SSAS, Tabular-based reporting, and Tabular Data Models
• A broad understanding of data visualization methods and techniques
• Power Query ("M" language), and DAX language experience
• Professional presentation skills and the ability to present to audiences of 10-15 people
• Broad business experience with proficient ability to talk to executives in business terms
• Willingness to creatively engage with customers to come up with custom solutions
• Familiarity with Kimball methodologies of data warehousing
• Understanding of the difference between application database design and reporting database design

OUR CULTURE:

• Company Core Values: Commit to Quality, Embrace Transparency, Choose to Be Positive, Be Efficient/Systematize, Pursue Learning, Be Generous  
• Weekly personal and professional development programs for all  
• Teamwork—we maintain company-wide interaction and communication  
• Entrepreneurism – we want everyone on our team to be eager to adapt and evolve with our advancing business. We are looking for someone who is comfortable wearing more than one hat.

WORK ENVIRONMENT AND PHYSICAL REQUIREMENTS: 

• This job may require moderate physical effort including lifting materials and equipment of less than 50 pounds and involves viewing a CRT or VDT screen more than 80 percent of the time. The job will take place in a normal office environment with controlled temperature and lighting conditions. The position may require some travel and occasional participation in off-site functions. This position requires standing or sitting for long durations.  
• This position may require occasional weekends and evenings and some occasional travel.

SALARY AND BENEFITS:  

-

The starting salary for this position is between $50,000-$65,000 and is commensurate with experience and qualifications. This position comes with a comprehensive benefits package consisting of medical and dental coverage, paid sick leave, vacation, and a retirement plan.