Data Analytics Consultant I-III

Blue Margin, Inc. is on a mission to build great places to work. We help companies improve company culture and consequently, performance. We believe remarkable things are possible when the whole team knows the score and is rowing in the same direction. Using Power BI as the primary catalyst, we partner with our clients to align employees, improve meetings, and increase employee satisfaction.

Why are we looking?  

We are expanding our Microsoft Power BI team and are looking for people who are flexible and capable of putting themselves in the client's shoes. We are looking for a clever, creative, data-savvy person to implement data models and produce reports while working alongside a fantastic team of data engineers and sales executives.  Our growth means we are looking for people who will help us, and our clients, build great places to work. It also means we provide an excellent opportunity for someone serious about learning and advancing their career.  

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.    

We are interested in considering candidates for all three of our developer tiers. The sample report you create will help distinguish your skill level: 

• Data Analytics Consultant I 
• Data Analytics Consultant II 
• Data Analytics Consultant III 

Responsibilities:   

• Develop accurate reports in Power BI that are not only visually engaging, but also make customers’ data accessible and actionable.  
• Regularly interact with clients and internal teams for project updates and inquiries  
• Create, enhance, and troubleshoot data models in SSMS, Power BI and Visual Studio  
• Author documentation of customer reporting requirements and finished reports  
• Craft and use T-SQL queries for data validation     

Candidates MUST possess the following qualifications:  

• Working knowledge of Power BI Desktop and Power BI Service
• Ability to create DAX calculations
• Ability to create data models 
• Ability to query SQL databases   
• Proficient ability to talk to executives clearly and concisely in English
• Professional demeanor
• Desire to be a team player and do meaningful work

Ideal candidates would possess these additional qualifications:

• 1-3 years of experience in Power BI Desktop creating tables, graphs, drill downs, drill throughs, bookmarks, and KPIs
• Working knowledge of Power BI Service and administration 
• Ability to create intermediate to advanced DAX calculations using functions such as Calculate, Summarize and Filter 
• Experience creating T-SQL queries in SSMS  
• Comprehensive grasp of data visualization methods  
• Experience using Azure, DAX Studio, Tabular Editor, ALM Toolkit 
• Familiarity with tabular/ relational data models
• Experience with integration of multiple data sources with different structures and schemas into business-friendly formats
• Experience manipulating data in Power Query Editor
• Comfortable with supporting multiple clients, projects at one time 

Our Culture:  

• Company Core Values: Commit to Quality, Embrace Transparency, Choose to Be Positive, Be Efficient/Systematize, Pursue Learning, Be Generous  
• We believe that in-person interaction is vital to solid work relationships and our great place to work
• Hybrid work option - most employees have the option to work from home on Wednesdays and Thursdays
• 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 position may require minimal physical effort including lifting materials and equipment of less than 10 pounds. This position requires 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 may require some travel and occasional participation in off-site functions. 

Salary and Benefits: 

• The starting salary for a Level I position is between $65-85K and is commensurate with experience and qualifications.  
• The starting salary for a Level II position is between $75-95K and is commensurate with experience and qualifications.
• The starting salary for a Level III position is between $85-105K and is commensurate with experience and qualifications. 

All positions come with a comprehensive benefits package consisting of medical and dental coverage, paid sick leave, vacation, disability/life insurance, and a retirement plan.