What are the responsibilities and job description for the Power BI / Data Engineer position at InfiCare?
Job Title: Power BI / Data Engineer
Location: Salt Lake City, UT
Job Type: Contract
Experience: X years
Job Overview
Our client is seeking an experienced Power BI Engineer with strong Data Engineering skills to design, develop, and maintain scalable business intelligence and data solutions. This role partners with business stakeholders, analysts, and technology teams to transform complex data into reliable, governed, and actionable insights.
Key Responsibilities
- Design, develop, and maintain enterprise-grade Power BI dashboards, reports, and semantic models
- Build advanced calculations and business logic using DAX; transform and cleanse data using Power Query / M
- Design star and snowflake schemas, dimensional models, and reusable semantic layers
- Implement Row-Level Security and configure DirectQuery, composite models, and incremental refresh
- Build and maintain scalable ETL/ELT data pipelines integrating structured and semi-structured data
- Develop complex, performance-optimized SQL queries, stored procedures, and transformation logic
- Build and maintain data warehouse, data lake, and lakehouse solutions
- Implement CI/CD and version-control practices for BI and data solutions
- Support data governance, metadata management, lineage, and data-quality initiatives
Required Skills
- Microsoft Power BI (advanced)
- DAX, Power Query / M, SQL
- Dimensional modeling, star/snowflake schemas
- ETL/ELT pipeline design and development
- Data warehousing, data lake, and lakehouse architectures
- Python, PySpark
- Microsoft Azure (preferred cloud platform)
- Git / version control, CI/CD concepts
Preferred Skills
- Experience with large-scale dataset optimization
- Knowledge of data governance and metadata management frameworks
Location & Work Model
Phoenix, AZ or Salt Lake City, UT
Engagement Details
Contract engagement. Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field (or equivalent experience) required.