Senior Power BI Developer

Senior Power Bi DeveloperColas 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 ResponsibilitiesDesign, 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.ExperienceBachelor'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 SkillsEnterprise 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 SkillsCommunication 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.DisclaimerThe 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.Colas Inc. and its subsidiaries are an Equal Opportunity Employer. For details on the specifics of this commitment, please view the EEO document. If you are an individual with a disability and require a reasonable accommodation to meet the requirements of the role in which you are applying, complete any part of the application process, or access or use the online application process and need an alternative method for applying, please contact Colas Inc. at View phone number on click.appcast.io or send an email to View email address on click.appcast.io.