Senior Power BI Developer
$133,560–$163,240 year
On-siteDenver, Colorado, United States
Job Summary
Design, build, and own enterprise-grade semantic data models using dimensional and star-schema patterns to serve the Enterprise Reporting & Data Warehouse platform. Develop advanced DAX measures, optimize report performance through VertiPaq analysis and query folding, and deploy interactive dashboards adhering to WCAG accessibility standards. Manage CI/CD pipelines with Git integration, implement row-level and object-level security, and partner with data engineering to source data from Databricks and Microsoft Fabric. Mentor developers, define reporting standards, and document data lineage while leveraging AI-assisted tools to accelerate development and testing.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field; or equivalent practical experience
- At least 5 years of hands-on experience building solutions specifically in Power BI
- 10 years of overall business intelligence and reporting experience across tools such as SSRS, SSAS, Crystal Reports, Cognos, Tableau, and SAP Business Objects
- Proven track record of owning enterprise semantic models and delivering reporting at scale
- Expert in dimensional / star-schema design and building scalable, reusable enterprise semantic models in Power BI
- Deep proficiency in DAX—advanced patterns, time intelligence, calculation groups, variables, and performance tuning
- Expert with Power BI Desktop and the Power BI Service (workspaces, datasets, refresh management)
- Working knowledge of Microsoft Fabric—OneLake, Lakehouse, Direct Lake—and building semantic models over Fabric / Databricks sources
- Power BI Report Builder and PBIRS; building paginated (RDL) reports on Power BI semantic models via XMLA endpoints, DAX, and shared datasets
- Power BI Project (PBIP) format for source-controlled development; Git integration, deployment pipelines, and CI/CD automation for Power BI workspaces (Azure DevOps / GitHub)
- Skilled in data transformation, cleansing, and query folding
- Strong SQL / T-SQL for querying, data validation, and troubleshooting across sources
- VertiPaq analysis, aggregations, incremental refresh, composite models, and DAX / query optimization
- Row-level and object-level security (RLS / OLS), sensitivity labels, endorsements, workspace governance, capacity / Premium management, and usage monitoring
- Proficient querying relational and analytic sources (SQL, Azure Synapse, Databricks, Microsoft Fabric / OneLake)
- Solid understanding of data warehousing concepts, dimensional modeling, and ETL / ELT processes
- Hands-on experience across legacy and modern BI/reporting tools (SSRS, SSAS, Crystal Reports, Cognos, Tableau, Business Objects)
- Familiarity with finance reporting (and construction, equipment, or safety domains)
- Ability to convey complex technical concepts to technical and non-technical stakeholders
- Working effectively with cross-functional teams including developers, project managers, and business analysts
- Analyzing issues and developing effective solutions while considering constraints and trade-offs
- Mentoring team members and influencing technical decision-making
- Openness to change and emerging technologies
- Evaluating options and making informed decisions
- Prioritizing tasks effectively across multiple initiatives
- Understanding team and stakeholder perspectives to foster collaboration
Desired Qualifications
- Microsoft PL-300 (Power BI Data Analyst Associate)
- DP-600 (Fabric Analytics Engineer Associate)
- Azure DP-900
- Business Domain: Familiarity with finance reporting (and construction, equipment, or safety domains) a plus
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.