Senior Power BI Developer
COLASAbout the role
Colas IS Support is the information technology arm of the North America business for Colas and is based in Denver, Colorado. Colas ISS strives to make Colas an industry leader through developing custom mobile applications and business intelligence tools, supporting core applications, maintaining our infrastructure, and much more. Through a partnership with the Colas Companies in the USA & Canada Colas IS Support helps empower our employees for success while also providing direct contact with users and other innovators across the organization. To learn more about Colas IS Support visit www.colasiss.com/.
The Colas USA Family of Companies provides competitive pay, outstanding benefits, career advancement opportunities, professional education, and extensive training for every employee. We pride ourselves on upholding the highest standards of safety, environmental conservation, and ethical conduct as we strive to grow our infrastructure products and services through empowering and developing our people, fostering innovation, utilizing new technology, and maximizing vertical integration at all levels of the company’s value chain. To learn more about the Colas USA Family of Companies, please visit www.colasusa.com.
Compensation & Benefits
Compensation*: $133,560.00 – $163,240.00 USD
*Estimated target starting compensation; final compensation will be determined based on an assessment of an individual’s qualifications, education, and experience relevant to the role.
Benefits: Full-time salaried exempt employees are eligible for Colas Group benefits, as outlined in the plan documents. Available benefits include medical, dental, and vision insurance, term life insurance, supplemental life insurance, 401(K) with company match, short- and long-term disability. Other benefits include paid holidays, paid sick leave, accrued vacation time off, and paid parental leave.
Other Compensation: This position may be considered for annual bonus compensation.
Mission
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
Apply for this role
Generate a tailored application kit with a matched cover letter, interview prep, and CV highlights — in under 60 seconds.
Apply Now →Generate Application KitFree account required — sign up in 30s