Principal Business Intelligence Analyst

Ledcor Construction, Inc.; Edmonton; On-site; CAD 120,000 - 180,000; Full time

Job summary

Ledcor Construction, Inc. is seeking a Principal Business Intelligence Analyst to partner with stakeholders, guide analytics strategy, and grow analytics capabilities across Ledcor.

You will translate business needs into roadmaps, deliver high-value insights, and promote data governance and quality. In this role, you will lead cross-functional discovery sessions, develop scalable BI solutions using Power BI, Databricks, and related tools, and mentor teams in Agile delivery practices to drive

Qualifications

• Bachelor’s degree in a related field.
• 8+ years of experience designing and delivering BI, analytics, reporting, or data visualization solutions.
• Experience translating business requirements into scalable technical deliverables.
• Experience turning large datasets into actionable insights for decision-making.
• Proficient with cloud analytics and platforms such as Microsoft Fabric, Databricks, Azure.

Responsibilities

• Design, develop, and deliver BI solutions that support operational and strategic decisions.
• Lead requirements sessions and translate business needs into scalable data and reporting solutions.
• Develop and maintain Power BI dashboards, semantic models, and data visualizations.
• Utilize Jira, Confluence, GitHub, and related tools to manage development in Agile environments.
• Deliver recurring insights and performance reporting to leadership to improve outcomes.
• Review and optimize analytics assets across Power BI, Databricks, and Sigma.
• Maintain ETL processes and data quality standards for accuracy and usability.
• Lead discovery sessions and create delivery roadmaps with stakeholders.

Skills

Power BI

SQL

Data Modeling

Data Governance

Agile/Scrum

Stakeholder Management

Azure Databricks

Data Visualization

Leadership

Presentation

Education

Bachelor's degree in Business Administration, Computer Science, Engineering, Information Systems, or related field

Tools

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.

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.