pointing-at-computer

Now accepting applications for

ETL Developer

(post date: 6/13/2022)

Overview

Blue Margin, Inc. is dedicated to helping clients, employees, and our community thrive.  We’re experts at helping midmarket companies become “data-driven.”  Becoming data-driven creates transparency, where each person in an organization can see the most important performance metrics for the success of the company and the individual.  The result is more efficient and productive operations, a healthier culture, and stronger job-ownership by employees.  We call it The Dashboard Effect (see our book on Amazon here), where micro-management, politics, and negative pressure are replaced by openness, trust, and accountability.    

We specialize in Microsoft’s Business Intelligence stack (i.e., Power BI, SQL, Azure, etc.) and are Gold Partners (Microsoft’s highest certification) in Data Analytics, Data Platform, Cloud Platform, and Application Development. 

We believe in working hard, volunteering in our community, and enjoying life to the fullest. 

 

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 exists 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.   

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.
  • Design and build cloud-based BI infrastructure.
  • 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:

  • Up to 2 years 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, and dashboards in one or more of the following programs: Excel, SSRA, Power BI, Tableau, Qlik and/or similar programs

 

Our Ideal Candidate Would Also Possess:

  • 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 
  • Familiarity with cloud services (AWS, Azure (preferred), Google Cloud)  
  • 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 design, construct, and maintain data warehouses  
  • Basic to intermediate experience with SSMS and SSIS

 

Our Culture:

  • Company Core Values: Embrace Transparency, Choose to Be Positive, Commit to Quality, Be Efficient/Systematize, Pursue Learning, Be Generous.   
  • Personal and professional development programs  
  • Teamwork – we maintain company-wide interactions and communication   
  • Fun - we volunteer together, shoot each other with Nerf guns, go to happy hour, eat lunch together as a team every Friday, and hang out at monthly employee-appreciation events (laser tag, bowling, brewery tours, barbecues, etc).

 

Work Environment and Physical Requirements:

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

 

Salary and Benefits:

  • This is a full-time position with a starting salary range of $75-$85K and is commensurate with experience and qualifications.  
  • Benefits include health, dental and vision insurance, short-and long-term disability, 401K matching, health club stipend, paid vacation, sick leave, and a bonus structure.
 

Is this job for you?

Click to Apply

Please, NO CALLS