D365 Data Reporting and Analytics Analyst

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

• 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

• 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.

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

• 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.

• 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.

• 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.

• 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,…