What are the responsibilities and job description for the Power BI Analytics Engineer position at Apex Systems?
Job#: 3031847
Job Description:
Power BI Analytics Engineer
Location: Ankeny, Iowa
Employment Type: Contract to Perm
Role Overview
An opportunity is available for an Analytics Engineer to design, build, and operate enterprise-grade semantic models and Power BI solutions. This role is positioned at the intersection of data engineering, analytics, and BI platform development. The Analytics Engineer will be responsible for building scalable, high-performance Power BI semantic models, optimizing performance, and enabling self-service analytics at scale.
Key Responsibilities
Experience: BI Enterprise experience is required.
Technical Skills: Candidates must have experience with semantic models, the semantic layer, and transcribing new data into models. Proficiency with SQL joins is necessary.
Compensation & Benefits
A pay range of $55.00 to $75.00 per hour is offered for the contract portion of this role. The salary range for the permanent position is between $112,000.00 and $120,000.00 annually.
We are an equal opportunity employer and welcome applications from all qualified candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
Apex uses a virtual recruiter as part of the application process. Click for more details.
If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at or .
Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Everforth Apex uses a virtual recruiter as part of the application process. Click for more details.
Everforth Apex Benefits Overview: Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6 months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Everforth Apex team member can provide.
Job Description:
Power BI Analytics Engineer
Location: Ankeny, Iowa
Employment Type: Contract to Perm
Role Overview
An opportunity is available for an Analytics Engineer to design, build, and operate enterprise-grade semantic models and Power BI solutions. This role is positioned at the intersection of data engineering, analytics, and BI platform development. The Analytics Engineer will be responsible for building scalable, high-performance Power BI semantic models, optimizing performance, and enabling self-service analytics at scale.
Key Responsibilities
- Design, build, and maintain enterprise-grade Power BI semantic models.
- Contribute to data modeling strategy for analytics use cases, including dimensional modeling and star schemas.
- Develop and optimize DAX measures, calculation groups, and model relationships with a focus on performance and maintainability.
- Implement and tune incremental refresh, partitions, and aggregations to support large-scale datasets.
- Partner with Data Engineering to ensure upstream data models are optimized for analytical consumption.
- Establish and enforce Power BI best practices across modeling, security (RLS), and dataset lifecycle management.
- Support self-service analytics by delivering well-documented, governed semantic models.
- Provide oversight and consulting to Power BI-enabled Analysts within business unit analytics functions.
Experience: BI Enterprise experience is required.
Technical Skills: Candidates must have experience with semantic models, the semantic layer, and transcribing new data into models. Proficiency with SQL joins is necessary.
Compensation & Benefits
A pay range of $55.00 to $75.00 per hour is offered for the contract portion of this role. The salary range for the permanent position is between $112,000.00 and $120,000.00 annually.
We are an equal opportunity employer and welcome applications from all qualified candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.
Apex uses a virtual recruiter as part of the application process. Click for more details.
If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Benefits Department at or .
Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico. Everforth Apex uses a virtual recruiter as part of the application process. Click for more details.
Everforth Apex Benefits Overview: Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6 months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Everforth Apex team member can provide.
Salary : $55 - $75