Power BI Architect & Analytics Lead

Steneral Consulting; Denver (CO); On-site; USD 90,000 - 125,000; Full time

Job summary

Steneral Consulting seeks an experienced Power BI Developer to design and optimize BI solutions. You will build semantic data models, implement row- and column-level security, and craft advanced DAX measures.

The role involves connecting to diverse data sources, delivering interactive dashboards, and collaborating with data analysts to translate business needs into scalable analytics. Responsibilities include performance tuning, preparing reports for executives, and ensuring robust data

Qualifications

• Strong Power BI development experience with data modeling
• Proficient in writing DAX, measures and calculated columns
• Experience connecting Power BI to diverse data sources and APIs
• Ability to translate business needs into analytic solutions

Responsibilities

• Collaborate with stakeholders and analysts to gather requirements
• Identify data sources and attributes for reporting
• Reverse engineer and optimize existing analyses
• Design data models with row/column security in Power BI
• Develop reusable semantic models and best-practice DAX
• Establish relationships between tables and data structures
• Connect to data sources (APIs, SQL, BigQuery, etc.) and support ETL
• Write advanced DAX, calculated columns, measures
• Create interactive Power BI reports and dashboards with advanced visuals
• Optimize performance using DAX Studio and Power BI features
• Publish and manage reports in Power BI Service with access controls
• Leverage AI tools to enhance analysis workflows
• Adhere to version control practices using Azure DevOps
• Communicate insights clearly to non-technical stakeholders
• Collaborate with cross-functional teams and adapt to changing requirements
• Experience with state clients is required

Skills

Power BI

DAX

Data Modeling

SQL

ETL

Tools

DAX Studio

Power Query

Job description

Steneral Consulting seeks an experienced Power BI Developer to design and optimize BI solutions. You will build semantic data models, implement row- and column-level security, and craft advanced DAX measures.

The role involves connecting to diverse data sources, delivering interactive dashboards, and collaborating with data analysts to translate business needs into scalable analytics. Responsibilities include performance tuning, preparing reports for executives, and ensuring robust data