> Markdown version of [/jobs/ext/1701185-senior-power-bi-developer](https://www.wearedevelopers.com/jobs/ext/1701185-senior-power-bi-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Power BI Developer - **Company:** Colas - **Location:** Denver, CO, United States - **Experience:** Expert - **Salary:** $133,560.0 - $163,240.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Microsoft Azure, Information Systems, Continuous Integration, Crystal Reports (Reporting Software), Data as a Services, Data Validation, Information Engineering, Data Files, Extract Transform Load (ETL), Data Transformation, Data Visualization, Data Warehousing, Dimensional Modeling, Github, IBM Cognos Business Intelligence, Performance Tuning, Query Optimization, Power BI, Standard Sql, Responsive Web Design, SQL Databases, SQL Server Reporting Services, SQL Server Analysis Services, Tableau (Software), Transact-SQL, Web Content Accessibility Guidelines, Enterprise Data Management, Delivery Pipeline, Sap Business Objects, Git, Powerquery, Microsoft Fabric, Information Technology, Data Lineage, Data Analytics, Tools for Reporting, Azure Synapse Analytics, Software Version Control, Custom Reports, Databricks - **Published:** July 3, 2026 - **Apply:** https://diversityjobs.com/main/sendform/8/8/28176/1/17477301?backUrl=%2Fcareer%2F17477301%2FSenior-Power-Bi-Developer-Colorado-Denver ## About the Role * 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, backed by 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. * Preferred certifications: Microsoft PL-300 (Power BI Data Analyst Associate) and / or DP-600 (Fabric Analytics Engineer Associate); Azure DP-900 a plus. Professional Skills * Enterprise Data Modeling: Expert in dimensional / star-schema design and building scalable, reusable enterprise semantic models in Power BI (must-have). * DAX & Advanced DAX: Deep proficiency in DAX-advanced patterns, time intelligence, calculation groups, variables, and performance tuning (must-have). * Power BI Platform: Expert with Power BI Desktop and the Power BI Service (workspaces, datasets, refresh management). * Microsoft Fabric: Working knowledge of Microsoft Fabric-OneLake, Lakehouse, Direct Lake-and building semantic models over Fabric / Databricks sources., * Communication Skills: Ability to convey complex technical concepts to technical and non-technical stakeholders. * Collaboration: Working effectively with cross-functional teams including developers, project managers, and business analysts. * Problem-Solving: Analyzing issues and developing effective solutions while considering constraints and trade-offs. * Leadership: Mentoring team members and influencing technical decision-making. * Adaptability: Openness to change and emerging technologies. * Critical Thinking: Evaluating options and making informed decisions. * Time Management: Prioritizing tasks effectively across multiple initiatives. * Empathy: Understanding team and stakeholder perspectives to foster collaboration. ## Description Colas is one of North America's largest road and infrastructure groups, and Colas ISS provides the technology and data services that keep the business running. We are looking for a Senior Power BI Developer to design and own our enterprise semantic layer and deliver high-impact reporting for the Enterprise Reporting & Data Warehouse (ERDW) platform. This hands-on senior role sets the standard for data modeling, DAX, and report performance across the team-turning complex data from Databricks and other sources into accurate, trusted, and intuitive insights that drive business decisions. Main Responsibilities * Design, build, and own enterprise-grade semantic data models (dimensional / star-schema) that serve as long-lived, reusable IP for the organization. * Develop and optimize advanced DAX measures and calculation logic-including time intelligence and calculation groups-for correctness and performance. * Design, develop, and deploy interactive Power BI reports and dashboards that communicate insights clearly to business stakeholders. * Apply data-visualization and UX best practices-including accessibility (WCAG) and mobile / responsive design-so reports are intuitive, consistent, and performant. * Build paginated, print-ready reports using Power BI Report Builder and Power BI Report Server (PBIRS)-leveraging Power BI semantic models through XMLA endpoints, DAX, and shared dataset-based reporting for operational and financial reporting. * Manage Power BI development using the Power BI Project (PBIP) format under source control, and build and maintain CI/CD for Power BI-Git-integrated workspaces, deployment pipelines, and automated validation-to promote content reliably from development to test to production. * Optimize model and report performance (VertiPaq analysis, query folding, aggregations, incremental refresh, composite models, and DAX tuning). * Implement row-level and object-level security (RLS / OLS), sensitivity labels, and endorsements (certified / promoted datasets) to protect data and build trust in reports. * Partner with data engineering to source and shape data from Databricks, Microsoft Fabric, and other sources (Power Query / M) and validate data quality. * Manage and govern the Power BI Service-workspaces, datasets, deployment pipelines, scheduled refreshes, capacity / Premium, and usage monitoring. * Contribute to the BI / analytics roadmap and define enterprise semantic-model and reporting standards, reusable patterns, and best practices. * Mentor developers and coach citizen developers; collaborate with product owners, business analysts, and stakeholders to translate requirements and KPIs into effective BI solutions. * Document semantic models, data lineage, and report design; provide user training and support. * Leverage AI-assisted tools to accelerate model and report development, documentation, and testing while validating outcomes., * Paginated & Dataset-Based Reporting: Power BI Report Builder and PBIRS; building paginated (RDL) reports on Power BI semantic models via XMLA endpoints, DAX, and shared datasets. * PBIP & CI/CD: Power BI Project (PBIP) format for source-controlled development; Git integration, deployment pipelines, and CI/CD automation for Power BI workspaces (Azure DevOps / GitHub). * External Tools: Tabular Editor, DAX Studio, ALM Toolkit, and Best Practice Analyzer. * Power Query (M): Skilled in data transformation, cleansing, and query folding. * SQL: Strong SQL / T-SQL for querying, data validation, and troubleshooting across sources. * Performance Optimization: VertiPaq analysis, aggregations, incremental refresh, composite models, and DAX / query optimization. * Governance & Administration: Row-level and object-level security (RLS / OLS), sensitivity labels, endorsements, workspace governance, capacity / Premium management, and usage monitoring. * Data Sources: Proficient querying relational and analytic sources (SQL, Azure Synapse, Databricks, Microsoft Fabric / OneLake). * Data Warehousing: Solid understanding of data warehousing concepts, dimensional modeling, and ETL / ELT processes. * Broad BI Background: Hands-on experience across legacy and modern BI/reporting tools (SSRS, SSAS, Crystal Reports, Cognos, Tableau, Business Objects) is highly valued. * Business Domain: Familiarity with finance reporting (and construction, equipment, or safety domains) a plus. ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Python Data Visualization @ Deepnote (w/ PyViz overview)](https://www.wearedevelopers.com/videos/113-python-data-visualization-deepnote-w-pyviz-overview) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)