Principal Business Intelligence Analyst

Ledcor Construction, Inc.; Calgary; On-site; CAD 130,000 - 170,000; Full time

Benefits offered by this job

Competitive compensation

Professional development

Inclusive culture

Job summary

Ledcor Construction, Inc. seeks a Principal BI Analyst to partner with senior leaders, translate strategic needs into analytics roadmaps, and promote data quality and governance across the enterprise.

You will lead cross-functional discovery sessions and deliver high-value analytics using Power BI, Databricks, and related tools. You will collaborate with business units to provide actionable insights, maintain data models, and support data-driven decisions across operations and projects in an

Qualifications

• Bachelor's degree in a related field.
• 8+ years designing and delivering BI, analytics, or data visualization solutions in a complex enterprise.
• Experience with cloud analytics platforms such as Microsoft Fabric, Databricks, Azure or equivalent.
• Advanced proficiency in Power BI including Power Query and DAX.
• Strong data architecture, governance, modelling and lifecycle management knowledge.
• Proficiency in SQL and relational databases with strong analytical skills.
• Experience with Agile delivery using Jira or Azure DevOps.

Responsibilities

• Design, develop, and deliver BI analytics and reporting solutions across the organization.
• Partner with stakeholders to translate requirements into scalable data and reporting solutions.
• Develop, maintain, and enhance Power BI dashboards, reports, and data models.
• Manage development activities using Jira, Confluence, GitHub, and related tools within an Agile lifecycle.
• Lead discovery sessions and workshops to prioritize initiatives and develop delivery roadmaps.
• Promote data quality, governance standards, and data product development across teams.

Skills

Power BI

SQL

Data governance

Azure

Databricks

Jira

Agile

Stakeholder Mgmt

Leadership

Data modeling

DAX

Education

Bachelor's degree

Tools

Jira

Confluence

GitHub

Power BI

Azure DevOps

Databricks

Sigma

Job description

Description

Reporting to the Manager, Business Analytics, the Principal Business Intelligence Analyst is responsible for strategic business partnership and growing analytics competencies within the BI team and across the enterprise.

You will partner closely with business stakeholders to understand requirements, lead complex, cross-functional requirements discovery sessions and translate strategic business needs into executable analytics roadmaps, solution concepts, development epics, and prioritized workstreams.

Additionally, this role will be responsible for promoting data quality, governance standards, and delivering high-value analytics to the enterprise, while ensuring Agile delivery practices are being adopted and followed by the BI team, data team, and other key stakeholder groups in Ledcor.

Essential Responsibilities

• Design, develop, and deliver business intelligence, analytics, and reporting solutions that support operational and strategic decision-making across the organization
• Collaborate with business stakeholders to assess new reporting and analytics requests, facilitate requirements gathering sessions, refine user stories, and translate business needs into scalable data and reporting solutions
• Develop, maintain, and enhance Power BI dashboards, reports, semantic models, and data visualizations that provide actionable insights and support data-driven decision-making
• Utilize Jira, Confluence, GitHub, and related tools to manage development activities and ensure adherence to Agile and best-practice software development lifecycle methodologies
• Work closely with business units and leadership teams to deliver recurring insights, performance reporting, and recommendations that drive business outcomes and continuous improvement
• Review, optimize, and maintain analytics assets across platforms such as Power BI, Databricks, Sigma, and related technologies, including data models, transformation logic, calculations, and reporting components
• Maintain and enhance ETL processes, Power Query transformations, DAX calculations, and report design standards to ensure data accuracy, performance, usability, and scalability
• Lead discovery sessions, requirements workshops, and stakeholder engagements to prioritize initiatives, define solution designs, manage expectations, and develop delivery roadmaps
• Provide strategic guidance on data and analytics initiatives, including reporting architecture, self-service analytics, data governance, metric standardization, data quality, platform adoption, and data product development
• Identify opportunities to improve data availability, reporting consistency, business processes, and analytical maturity, while effectively communicating complex technical and analytical concepts to executives, business stakeholders, and technical teams through presentations, workshops, data storytelling, coaching, and change management activities

Qualifications

• Bachelor's degree in Business Administration, Computer Science, Engineering, Information Systems, or a related field
• Minimum 8+ years of experience designing and delivering business intelligence, analytics, reporting, or data visualization solutions in a complex enterprise environment
• Proven experience gathering, analyzing, and translating business requirements into scalable technical, analytical, and reporting deliverables
• Extensive experience working with large, complex datasets and transforming data into actionable insights that support business decision-making
• Strong experience with cloud-based analytics and data platforms such as Microsoft Fabric, Databricks, Azure, or equivalent technologies
• Advanced proficiency in Microsoft Power BI, including Power Query, DAX, semantic modeling, data visualization, dashboard development, and report design
• Strong understanding of data architecture principles, including data integration, data management, modeling, governance, quality, security, and lifecycle management
• Proficiency in SQL and relational database technologies, combined with strong analytical and problem-solving skills to address complex business challenges
• Experience working in Agile delivery environments using tools such as Jira, Azure DevOps, or similar platforms, with the ability to manage work through user stories and sprint-based methodologies
• Excellent communication, organizational, and stakeholder management skills, with the ability to effectively present technical concepts to both technical and non-technical audiences. Experience supporting analytics initiatives in construction, engineering, telecommunications, infrastructure, or related industries is considered a strong asset

#LI-DW1

#LI-Onsite

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.

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.