Business Intelligence Analyst

Posted 8 Days Ago
Be an Early Applicant
2 Locations
In-Office
Mid level
Real Estate • Transportation • Energy • Industrial
The Role
Develop, maintain, and enhance Power BI semantic models, ETL (M), DAX calculations, and reports. Collaborate with Agile delivery and business stakeholders to gather requirements, build analytics solutions (Power BI, Power Apps, Power Automate, Databricks, Sigma), perform testing, documentation, and troubleshooting, and support data governance and reporting initiatives to drive operational and strategic decision-making.
Summary Generated by Built In
Reporting to the Manager, Business Analytics, the Business Intelligence Analyst is responsible for transforming business data into actionable insights through data analysis, semantic model development, and other analytics solutions.
This role partners closely with our Agile Delivery team to understand requirements, communicate findings, and develop trusted analytics products that support operational and strategic decision-making.
The Business Intelligence Analyst plays a key role in building, enhancing, and maintaining enterprise data and reporting assets while partnering closely with our Agile Delivery team to understand requirements and deliver trusted analytics products that support operational and strategic decision-making.
Apply today to join our True Blue Team in Edmonton or Calgary AB today!

Essential Responsibilities:

  • Maintain and enhance existing Power BI models, ETL scripts (M), calculations (DAX), and design (UI/UX) in conjunction with GitHub and Jira, following best practice lifecycle development
  • Work with business users to assess new build requests, refine requirements using Confluence and Jira, and develop reporting content in Power BI or other reporting tools that aligns with established development best practices
  • Enhance the organization's catalogue of Power Apps and Power Automate solutions
  • Build foundational knowledge across the analytics stack, including Power BI, Power Apps, Power Automate, Paginated Reports, Databricks, and Sigma
  • Support routine maintenance, testing, documentation, and troubleshooting of analytics assets and low-code solutions
  • Collaborate regularly with internal stakeholders, including the Construction Services Sustainment Team, business leaders, operational teams, finance teams, project teams, Information Services, Data Engineering, and Data Governance teams to gather requirements, support reporting and analytics initiatives, and drive effective business outcomes
  • Communicate progress, blockers, risks, and questions clearly with team members and business partners
  • Demonstrate curiosity, initiative, and a continuous learning mindset by asking thoughtful questions, seeking feedback, and building both technical and business knowledge
  • Perform other duties as assigned

Qualifications:

  • Minimum of a College, trade, or technical diploma or a Bachelor's degree in Business Administration, Computer Science, Engineering, or a related field is required
  • Minimum 3-5 years of experience developing business intelligence, analytics, reporting, or data visualization solutions
  • Experience gathering business requirements, translating them into technical solutions, and delivering reporting and analytics outcomes
  • Strong experience with Microsoft Power BI, including Power Query, DAX, semantic modelling, report design, and SQL
  • Experience working with large and complex datasets to generate actionable business insights and support decision-making
  • Foundational knowledge of cloud-based analytics platforms and modern data ecosystems, including Databricks, Microsoft Fabric, Azure, or similar technologies
  • Understanding of data management principles, including data movement, modelling, quality, governance, and security
  • Experience working in Agile delivery environments using tools such as Jira, Azure DevOps, and sprint-based delivery methodologies
  • Strong analytical, problem-solving, organizational, and communication skills, with the ability to effectively collaborate with both technical and non-technical stakeholders while managing multiple priorities
  • Proficiency with Microsoft 365 applications, including Excel, Teams, SharePoint, PowerPoint, and Outlook; experience supporting analytics initiatives within construction, engineering, telecommunications, infrastructure, or related industries is considered an 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.

Skills Required

  • College, trade, technical diploma or Bachelor's degree in Business Administration, Computer Science, Engineering, or related field
  • 3-5 years developing business intelligence, analytics, reporting, or data visualization solutions
  • Experience gathering business requirements and translating them into technical reporting/analytics solutions
  • Strong experience with Microsoft Power BI including Power Query, DAX, semantic modelling, and report design
  • Proficiency with SQL for data querying and manipulation
  • Experience working with large and complex datasets to generate actionable insights
  • Foundational knowledge of cloud analytics and modern data ecosystems (Databricks, Microsoft Fabric, Azure or similar)
  • Experience with ETL scripts (M language) and maintaining analytics assets (testing, documentation, troubleshooting)
  • Experience with Power Apps and Power Automate (low-code solutions) and Paginated Reports, Sigma
  • Familiarity with GitHub, Jira, Confluence, and/or Azure DevOps and Agile delivery methodologies
  • Understanding of data management principles: movement, modelling, quality, governance, and security
  • Strong analytical, problem-solving, organizational, and communication skills
  • Proficiency with Microsoft 365 applications (Excel, Teams, SharePoint, PowerPoint, Outlook)
  • Experience supporting analytics initiatives within construction, engineering, telecommunications, infrastructure, or related industries
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
9,000 Employees
Year Founded: 1947

What We Do

The Ledcor Group of Companies is one of North America's most diversified construction companies, serving sectors such as building, heavy industrial, civil and infrastructure, mining, pipeline, power, and communications. Additionally, the company operates in aviation, marine transportation services, property investment, and wastewater treatment. Ledcor is dedicated to delivering safe, efficient, and innovative projects through a diverse group of operating companies.

Similar Jobs

Pursuit Logo Pursuit

Business Intelligence Analyst

Retail • Transportation • Travel • Hospitality
In-Office
Banff, AB, CAN
4000 Employees

Block Logo Block

Systems Engineer

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
8 Locations
12000 Employees
120K-213K Annually

Block Logo Block

Senior Data Engineer

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
8 Locations
12000 Employees
168K-297K Annually

Toast Logo Toast

Account Executive

Cloud • Fintech • Food • Information Technology • Software • Hospitality
In-Office
Calgary, AB, CAN
5000 Employees
140K-190K Annually

Similar Companies Hiring

Agora RE Thumbnail
Fintech • Real Estate • PropTech
Tel Aviv, IL
200 Employees
Toro TMS Thumbnail
Cloud • Enterprise Web • Sales • Software • Transportation
Chicago, IL
80 Employees
Amalgamated Sugar Thumbnail
Food • Greentech • Agriculture • Industrial • Manufacturing
Boise, Idaho
768 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account