Principal Business Intelligence Analyst

Ledcor; Calgary; On-site; CAD 100,000 - 150,000; Full time

Job summary

Ledcor is seeking an experienced BI & Analytics Lead to design, develop and govern enterprise analytics solutions. You will deliver Power BI reporting, scalable semantic models, and governance practices across the organization, partnering with BI Analysts, Business Analysts, and Data Engineers. The role can be based in Edmonton or Calgary, AB.

You will mentor analysts, define standards, and drive adoption of analytics platform enhancements, working with modern data platforms and CI/CD workflows.

Qualifications

• 5+ years of experience in BI/analytics or data-focused roles.
• Advanced experience with Power BI and analytics reporting tools.
• Advanced expertise in semantic data modeling, DAX, and Power Query (M).
• Strong SQL skills and experience with relational data structures.
• Experience with Databricks, Azure Synapse, or similar lakehouse/warehouse solutions.
• Proficiency with GitHub, version control, and CI/CD workflows for analytics deployment.
• Strong BI governance, deployment standards, and analytics best practices.
• Excellent communication skills for non-technical audiences.
• Proven ability to work independently and manage complex deliverables.
• Collaborative mindset with a focus on continuous improvement.

Responsibilities

• Lead the design, development, and delivery of Power BI and analytics solutions, including dashboards and enhancements.
• Develop robust semantic data models and advanced DAX for self-service analytics.
• Collaborate with stakeholders to translate requirements into analytics solutions with measurable value.
• Define BI development standards, governance, naming conventions, and report lifecycle processes.
• Own version control and deployment practices using GitHub, CI/CD, and deployment pipelines.
• Partner with Data Platform teams to ensure analytics-ready data pipelines and aligned architecture.
• Provide Tier 2/3 support to users and drive analytics adoption.
• Mentor BI Analysts and Business Analysts, sharing best practices.

Skills

Power BI

DAX

Power Query

SQL

Databricks

Azure Synapse

GitHub

CI/CD

BI governance

Communication

Independent work

Cross-functional collaboration

Tools

Databricks

Azure Synapse

GitHub

Job description

Description

You will be responsible for designing, developing, and governing enterprise analytics solutions that enable data-driven decision-making. You will lead the delivery of high-quality Power BI reporting, scalable semantic data models, and governed analytics practices across the organization. Partnering closely with business stakeholders, BI Analysts, Business Analysts, and Data Engineers, you will translate complex business needs into trusted, actionable insights while helping shape the evolution of the analytics platform. This position can be based in Edmonton or Calgary, AB. Join our growing Business Analytics team today!

Essential Responsibilities

• Lead the design, development, and delivery of Power BI and analytics solutions, including new dashboard builds, enhancements, and defect resolution
• Develop and maintain robust, scalable semantic data models and advanced DAX measures to support consistent, self-service analytics across business units
• Collaborate with business stakeholders to gather requirements, provide consultation, and translate business objectives into analytics solutions that deliver measurable value
• Define, document, and enforce BI development standards, governance practices, naming conventions, and report lifecycle management processes
• Own version control and deployment practices for Power BI solutions, leveraging GitHub, CI/CD workflows, and deployment pipelines
• Partner with Data Platform teams to ensure analytics-ready data pipelines and alignment with platform architecture and roadmaps
• Provide Tier 2/3 support to end users and internal teams, resolving issues and enhancing analytics adoption
• Mentor BI Analysts and Business Analysts, sharing best practices and supporting skill development across the team
• Explore new tools, technologies, and platform enhancements, contributing to continuous improvement initiatives and analytics platform evolution

Qualifications

• 5+ years of experience in business intelligence, analytics, or data-focused roles
• Advanced experience with Power BI or similar data visualization and reporting tools
• Advanced expertise in semantic data modeling, DAX, and Power Query (M).
• Strong SQL skills and experience working with relational data structures
• Experience with modern data platforms such as Databricks, Azure Synapse, or similar lakehouse/warehouse solutions
• Proficiency with GitHub, version control, and CI/CD workflows for analytics deployment
• Strong understanding of BI governance, deployment standards, and analytics best practices
• Excellent communication skills with the ability to present technical concepts to non-technical audiences
• Proven ability to work independently, prioritize competing demands, and manage complex deliverables
• A collaborative mindset with a focus on continuous improvement and knowledge sharing

Additional Information

The Ledcor Group of Companies is one of North America’s most diversified construction companies. Ledcor is a company built on a rich history of long-standing project successes. Our workplace culture has been recognized as one of Canada’s Best Diversity Employers, Canada’s Most Admired Corporate Cultures, and a Top 100 Inspiring Workplace in North America. Our competitive total rewards package provides compensation and benefits that support your physical, mental and financial wellbeing. We offer exciting, challenging work with opportunities to develop your skills and knowledge.

Employment Equity

At Ledcor we believe diversity, equity, and inclusion should be part of everything we do. We are proud to be an equal-opportunity employer. All qualified individuals, regardless of race, color, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity, Veteran status or any other identifying characteristic are encouraged to apply. Our True Blue team consists of individuals from all backgrounds who contribute diverse perspectives and experiences to Ledcor. We are committed to continuing to build on our culture of empowerment, inclusion and belonging. Adjustments will be provided in all parts of our hiring process. Applicants need to make their needs known in advance by submitting a request via email. For more information about Ledcor’s Inclusion and Diversity initiatives, please visit our I&D page.

1100 - 1st Street SE, Calgary, AB