Data Systems Analyst: D365, Synapse, Fabric | 6M Contract

PrecisionERP / PrecisionIT; Ottawa; On-site; CAD 80,000 - 100,000; Full time

Job summary

A technology consulting firm in Canada is seeking a qualified Data Systems Analyst to work on D365 programs and enhance enterprise reporting and planning automation. The role demands over 5 years of expertise in data engineering, specifically with D365 F&O and Azure Synapse. Responsibilities include designing robust data pipelines, developing high-complexity financial reports, and collaborating with finance stakeholders. A contract duration of 6 months is offered with potential extensions.

Qualifications

• 5+ years in data engineering / BI with D365 F&O exposure.
• Strong SQL and data modeling skills.
• Hands-on Power BI experience.

Responsibilities

• Configure and optimize D365 F&O to Azure Synapse Link.
• Build ELT pipelines in Fabric and Azure Synapse.
• Partner with Finance for BPA reports and BPP cubes.

Skills

Data engineering

Business Intelligence (BI)

SQL (T-SQL / Spark SQL)

Power BI

Data modeling

Azure DevOps

Communication skills

Tools

Azure Synapse

D365 F&O

Power Query

Python / PySpark

Job description

A technology consulting firm in Canada is seeking a qualified Data Systems Analyst to work on D365 programs and enhance enterprise reporting and planning automation. The role demands over 5 years of expertise in data engineering, specifically with D365 F&O and Azure Synapse. Responsibilities include designing robust data pipelines, developing high-complexity financial reports, and collaborating with finance stakeholders. A contract duration of 6 months is offered with potential extensions.