Principal Business Intelligence Analyst

Ledcor Construction, Inc.; Edmonton; On-site; CAD 90,000 - 130,000; Full time

Job summary

Ledcor Group of Companies seeks a Principal BI Analyst to partner with stakeholders, translate requirements into analytics roadmaps, and promote data quality and governance across the enterprise. You will lead the design of BI solutions and guide cross‑functional teams to deliver high‑value insights.

You will maintain Power BI dashboards, ETL processes, and semantic models while ensuring Agile delivery with Jira, Confluence, and GitHub, and drive data‑driven decisions for leadership.

Qualifications

• 8+ years designing and delivering BI, analytics, or data visualization solutions in a complex enterprise.
• Experience translating business requirements into scalable analytics deliverables.
• Strong Power BI proficiency, data modeling, and data governance knowledge.
• Experience with cloud analytics platforms such as Databricks or Azure.

Responsibilities

• Design, develop, and deliver BI, analytics, and reporting solutions for decision making.
• Partner with stakeholders to refine requirements and translate into roadmaps and epics.
• Develop and maintain Power BI dashboards, semantic models, and visualizations.
• Use Jira, Confluence, GitHub to manage development and Agile lifecycle.
• Deliver insights, performance reporting, and recommendations to drive outcomes.
• Maintain analytics assets across Power BI, Databricks, Sigma and related tools.
• Manage ETL, Power Query, DAX, and reporting standards for data accuracy and performance.
• Lead discovery sessions, define solution designs, and build delivery roadmaps.
• Provide strategic guidance on data governance, self-service analytics, and data products.
• Communicate complex concepts to executives and stakeholders through storytelling and workshops.

Skills

Stakeholder management

Power BI

Data storytelling

Analytical thinking

Communication

Education

Bachelor's degree in related field

Tools

Databricks

Sigma

Jira

Confluence

GitHub

Azure DevOps

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.

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.