D365 Data Reporting and Analytics Analyst

Associated Engineering; Calgary; Hybrid; CAD 85,000 - 115,000; Full time

Benefits offered by this job

Shareholder opportunities

Pension program

Health/dental/vision

Fitness allowance

Employee assistance program

Mental health supports

Paid vacation

December office closure

Sick time

Maternity/paternity leave top up

Professional development hours

Mentoring programs

Engineering in Training

Company events

Job summary

Associated Engineering seeks an experienced Reporting and Analytics Analyst to deliver, govern, and continually improve enterprise data, reporting, and BI capabilities across Dynamics 365 and related platforms.

The role covers data governance, semantic modeling, data pipelines, and operational dashboards, with post-implementation sustainment and collaboration with business stakeholders. A hybrid work arrangement is available.

Qualifications

• Diploma or degree in Information Systems, Computer Science, Data Analytics, Business Administration, Commerce, Finance, Accounting, Engineering, or related discipline.
• Equivalent combination of education, business experience, reporting experience, data platform experience, and ERP sustainment experience will be considered.
• Microsoft Power BI Data Analyst, Microsoft Fabric, Azure Data, Dynamics 365, or related Microsoft certification is preferred.
• Training or practical exposure in data governance, dimensional modeling, SQL, Power BI administration, Fabric administration, business analysis, financial reporting, project reporting, or KPI frameworks is an asset.
• Typically requires 5 to 8+ years of experience in enterprise data, reporting, analytics, business intelligence, or ERP reporting roles.
• Typically requires 3 to 5+ years of Power BI development experience, including semantic models, DAX, Power Query, report design, dashboard development, RLS, workspace management, and performance optimization.
• Hands-on experience with Microsoft Fabric, including Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, OneLake, semantic models, deployment practices, and governed analytics assets.
• Experience supporting reporting and analytics for Dynamics 365 Finance and Operations, Dynamics 365 Project Operations, Customer Engagement, or comparable ERP and CRM platforms.
• Experience with project accounting, financial reporting, operational reporting, engineering project performance reporting, executive dashboards, and KPI development is preferred.
• Experience with SQL, dimensional data modeling, ETL/ELT approaches, data reconciliation, master data, data quality management, and enterprise reporting governance.
• Experience in a post-implementation sustainment environment supporting business-as-usual operations, report enhancements, release validation, issue resolution, and continuous improvement.
• Experience working with business stakeholders, technical teams, application support teams, data engineers, vendors, and managed service partners to deliver reporting outcomes.

Responsibilities

• Designs, builds, and sustains Power BI reports, dashboards, scorecards, KPIs, paginated reports and operational outputs.
• Translates business requirements into reporting specs, metrics definitions, semantic layer needs, visuals, and data models.
• Develops and supports Microsoft Fabric solutions including Lakehouses, Warehouses, Data Pipelines, Dataflows Gen2, and governed semantic models.
• Maintains data ingestion, transformation, reconciliation, and publishing processes for trusted enterprise reporting.
• Supports post-implementation sustainment for Dynamics 365 reporting and analytics, including issue resolution and release validation.
• Partners with stakeholders and cross-functional teams to ensure reporting meets business needs.

Skills

Reporting analytics

Stakeholder collaboration

Data governance

SQL

Dimensional modeling

Education

Diploma or degree in Information Systems / Computer Science / Data Analytics / Engineering

Tools

Power BI

Microsoft Fabric

Azure Data

Dynamics 365

Job description

The opportunity:

Associated Engineering, a proudly Canadian, employee-owned company, is seeking an experienced Reporting and Analytics Analyst to join our team. The successful candidate Analyst will be responsible for the delivery, governance, quality, and continuous improvement of enterprise data, reporting, analytics, and business intelligence capabilities across Dynamics 365 and associated business platforms. The role supports trusted reporting and decision-making through Microsoft Fabric, Power BI, semantic models, data pipelines, governed datasets, and operational dashboards. The position provides post-implementation sustainment support, develops reporting solutions, maintains analytics standards, and works with business stakeholders to translate data needs into practical reporting and insight capabilities.

The successful candidate can be located in any of the following locations, Edmonton, Calgary, Vancouver, Saskatoon, Markham

What we offer:

• Flexible/hybrid working arrangements, depending on position
• Market competitive salaries, with annual reviews
• Opportunity to become a shareholder and invest in the company’s long term growth & success
• Matching company pension program, increasing over time
• Comprehensive benefits including:
  • Health/dental/vision coverage
  • Fitness allowance
  • Employee and family assistance programs
  • Mental health supports
• Paid time off so that you can recharge including:
  • Generous paid vacation
  • Paid office closure over December holiday break
  • Industry leading paid sick time
  • Maternity/paternity leave top up program
• Ongoing support for your professional development and growth
  • Active Young Professional group
  • Formal mentoring programs
  • Paid professional development hours
  • Capacity building seminars
  • Engineer In Training programs
• Opportunities to participate in social club activities and events
  • Company-wide social events
  • Regular lunch-and-learns
  • Community volunteer opportunities

What you’ll do:

Data, Reporting and Analytics Solution Delivery:

• Designs, develops, enhances, and supports Power BI reports, dashboards, scorecards, key performance indicators, paginated reports, and operational reporting solutions.
• Translates business requirements into reporting specifications, metrics definitions, semantic layer requirements, visualizations, and data models.

Microsoft Fabric and Data Platform Enablement:

• Develops and supports Microsoft Fabric solutions including Lakehouses, Warehouses, Data Pipelines, Dataflows Gen2, OneLake-enabled assets, and governed semantic models.
• Builds and maintains data ingestion, transformation, reconciliation, and publishing processes to support trusted enterprise reporting and analytics.

Data Governance, Quality and Security

• Supports data governance, master data management, data quality, data lineage, data reconciliation, and reporting standards across the reporting portfolio.
• Defines and maintains common metrics, business definitions, calculation logic, and semantic model standards to promote consistent interpretation of enterprise data.

D365 Sustainment and Continuous Improvement

• Supports post-implementation sustainment for Dynamics 365 reporting and analytics, including issue resolution, enhancement intake, release testing, report validation, and business-as-usual support.
• Investigates and resolves reporting and analytics issues escalated through support channels, including data discrepancies, refresh failures, model issues, calculation errors, access concerns, and report performance issues.

Stakeholder Interface and Knowledge Management

• Acts as a bridge between business stakeholders, Digital Services, application support, data engineering, and reporting consumers.
• Facilitates requirements discussions, report reviews, metric definition sessions, and data interpretation conversations with business users.

Does this sound like you?

• Diploma or degree in Information Systems, Computer Science, Data Analytics, Business Administration, Commerce, Finance, Accounting, Engineering, or related discipline.
• Equivalent combination of education, business experience, reporting experience, data platform experience, and ERP sustainment experience will be considered.
• Microsoft Power BI Data Analyst, Microsoft Fabric, Azure Data, Dynamics 365, or related Microsoft certification is preferred.
• Training or practical exposure in data governance, dimensional modeling, SQL, Power BI administration, Fabric administration, business analysis, financial reporting, project reporting, or KPI frameworks is an asset.
• Typically requires 5 to 8+ years of experience in enterprise data, reporting, analytics, business intelligence, or ERP reporting roles.
• Typically requires 3 to 5+ years of Power BI development experience, including semantic models, Data Analysis Expressions (DAX), Power Query, report design, dashboard development, row-level security, workspace management, and performance optimization.
• Hands-on experience with Microsoft Fabric, including Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, OneLake, semantic models, deployment practices, and governed analytics assets.
• Experience supporting reporting and analytics for Dynamics 365 Finance and Operations, Dynamics 365 Project Operations, Customer Engagement, or comparable ERP and CRM platforms.
• Experience with project accounting, financial reporting, operational reporting, engineering project performance reporting, executive dashboards, and KPI development is preferred.
• Experience with SQL, dimensional data modeling, ETL/ELT approaches, data reconciliation, master data, data quality management, and enterprise reporting governance.
• Experience in a post-implementation sustainment environment supporting business-as-usual operations, report enhancements, release validation, issue resolution, and continuous improvement.
• Experience working with business stakeholders, technical teams, application support teams, data engineers, vendors, and managed service partners to deliver reporting outcomes.

About Us:

At Associated Engineering, were passionate about not only the work we do but the communities we live and work in. Which is why sustainability is at the heart of everything we do. As a carbon neutral company since 2009, we help shape resilient and sustainable communities across Canada.

As a Platinum Member of Canada’s Best Managed Companies since 2008, we take pride in nurturing a workplace where people thrive. We are an employer of choice providing our people with a supportive, collaborative, engaging and dynamic place to build a career, while bringing inspiration and innovation to our work.

Our company culture is shaped by:

• Growth and development of our employees – chart your career course, whatever stage you are at!
• A broad variety of meaningful work that supports local communities – we are a medium-sized company working on significant projects, helping to shape communities!
• We care, we commit, we create – our promise to both clients and each other!

Want more information?

• Check out what a day at Associated Engineering looks like viaLinkedIn
• Our Environmental, Social and Governance Report

This posting is for an existing vacancy.

AE is an Equal Opportunity Employer and encourages women, Indigenous peoples, persons with disabilities, members of visible minorities, and members of the LGBTQ+ community to apply. For applicants with disabilities, accommodations are available upon request for candidates taking part in all aspects of the selection process. We are also committed to protecting the privacy of your personal information and as such, it will be used for recruitment and employment purposes only.