Data System Analyst

Our client is seeking a hands-on consultant who blends data engineering, analytics, and applied data science to accelerate enterprise reporting and planning automation for a contract role. Contract DetailsClient: Crown Corp. Role: Data Systems AnalystContract Duration: 6 months with options to extendLocation of Work: Remote (EST Timezone-based)Language: EnglishSecurity Clearance: Reliability Level (Must either be in hand or be eligible for)Rate: Open – to be mutually agreed uponProject BackgroundThe client's D365 program is migrating enterprise reporting from on-premises systems to Microsoft Fabric alongside the D365 F&O data platform. The solution stack includes D365 Microsoft Business Performance Planning (BPP) and Business Performance Analytics (BPA) as the application layer, with Synapse Link and Microsoft Fabric as the core data and analytics backbone.Role OverviewWe’re seeking a hands-on consultant who blends data engineering, analytics, and applied data science to accelerate enterprise reporting and planning automation. You will operate as the technical backbone across D365 F&O, Synapse Link, BPA/BPP, Azure Synapse, and Fabric—designing robust pipelines, semantic models, and reports that mature analytics capabilities from diagnostic to predictive and prescriptive insights.What You'll DoD365 & Synapse LinkConfigure and optimize D365 F&O → Azure Synapse Link, including table selection, change feeds, performance considerations, and known limitations.Ensure reliable replication to Data Lake and/or Fabric Lakehouse; validate schemas, keys, and delta change capture.Fabric & Azure Synapse EngineeringBuild ELT pipelines in Fabric (Dataflows Gen2, Pipelines), Lakehouse/Warehouse, using Spark/SQL and/or Azure Synapse.Model conformed and serving layers for Finance, Operations, and Commerce domains.Implement Direct Lake and Import/Composite models aligned to performance and governance requirements.BPA/BPP Reporting and PlanningPartner with Finance to deliver BPA reports and BPP cubes/workflows for budgeting, forecasting, and departmental roll-ups.Develop high-complexity financial reports including P&L by dimensions, contribution margin, and variance/driver analysis.Analytics and Data QualityPartner with Finance to deliver BPA reports and BPP cubes/workflows for budgeting, forecasting, and departmental roll-ups.Develop high-complexity financial reports including P&L by dimensions, contribution margin, and variance/driver analysis.DevOps & Ways of WorkingUse Azure DevOps for user stories, CI/CD (Power BI/Fabric), automated testing, and release management across DEV/TEST/PROD.Support UAT, cutover readiness, and knowledge transfer to internal teams for sustainable operations.What you Bring to the Role5+ years in data engineering/BI with D365 F&O exposure and at least one production Synapse Link for D365 implementation.Strong SQL skills (T-SQL/Spark SQL), data modeling expertise (star schema for finance), and ELT development on Fabric and/or Azure Synapse.Hands-on Power BI experience (Power Query, DAX, model security), including performance tuning and enterprise deployment patterns.Practical experience with BPA/BPP (or equivalent EPM tools) to support budgeting/forecasting workflows and financial reporting.Proficiency with version control and CI/CD (Azure DevOps), environment promotion, and testing practices.Excellent communication with Finance, Operations, Commerce stakeholders, and IT—able to explain trade-offs and document clearly.Additional (Nice to Have) RequirementsExperience with Direct Lake semantic models and decision-making between Fabric Warehouse vs. Lakehouse architectures.Python/PySpark for transformations and performance tuning of large fact tables and slowly changing dimensions.Familiarity with data governance tools (e.g., Purview) and KPI/metrics standardization frameworks.Applied forecasting methods (classical time series or ML) on finance, commerce, and operations datasets.Public-sector or Crown corporation experience.If interested, please apply to this job posting with a copy of your resume. Only selected candidates will be contacted.