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 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.

Experience

• 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.
• 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. 

Soft Skills

• 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.

Disclaimer

The information contained herein is not intended to be an all-inclusive list of the duties and responsibilities of the job, nor are they intended to be an all-inclusive list of the skills and abilities required to do the job. Management may, at its discretion, assign or reassign duties and responsibilities to this job at any time.