PrecisionERP / PrecisionIT is seeking a qualified Data Systems Analyst to work with our client's D365 program. We’re seeking a hands-on consultant who blends data engineering, analytics, and applied data science to accelerate enterprise reporting and planning automation.
You will be the technical backbone across D365 F&O, Synapse Link, BPA/BPP, Azure Synapse, and Fabric —designing robust pipelines, models, and reports that advance our maturity from diagnostic to predictive/prescriptive analytics.
D365 program is moving reporting from on-premises to Fabric plus D365 F&O data platform. With D365 Microsoft Business Performance Planning (BPP) and Business Performance Analytics (BPA) on top and Synapse Link plus Microsoft Fabric as the core.
Contract duration: 6 months with potential for extension
Federal clearance eligibility will be required
Tasks:
D365 & Synapse Link
- Configure and optimize D365 F&O → Azure Synapse Link (tables, change feeds, performance, known limitations).
- Ensure reliable replication to Data Lake / Fabric Lakehouse ; validate schemas, keys, and deltas.
Fabric & Azure Synapse Engineering
- Build ELT pipelines in Fabric (Dataflows Gen2, Pipelines), Lakehouse/Warehouse, Spark/SQL and/or Azure Synapse .
- Model conformed/serving layers for Finance, Operations, and Commerce domains.
- Implement Direct Lake and Import/Composite models as appropriate.
BPA/BPP Reporting & Planning
- Partner with Finance to deliver BPA reports and BPP cubes/workflows (budgeting/forecasting, departmental roll-ups).
- Develop high-complexity financial reports (P&L by dimensions, contribution margin, variance/driver analysis).
Analytics & Data Quality
- Prepare/transform data for analysis; create Power BI datasets, measures (DAX), and visuals for decision-making.
- Apply statistical/ML methods (forecasting, A/B testing) where they add clear value.
- Document data flows, definitions, lineage, and metadata in the data catalog ; contribute to governance and continuous improvement.
DevOps & Ways of Working
- Use Azure DevOps for user stories, CI/CD (Power BI/Fabric), testing, and release management across DEV/TEST/PROD .
- Support UAT, cutover readiness, and knowledge transfer to internal teams.
Requirements:
- 5+ years in data engineering/BI with D365 F&O exposure and at least one production Synapse Link for D365 implementation.
- Strong SQL (T-SQL/Spark SQL), data modeling (star/schema for finance), and ELT on Fabric and/or Azure Synapse .
- Hands-on Power BI (Power Query, DAX, model security), including performance tuning and enterprise deployment patterns.
- Practical experience with BPA/BPP (or equivalent EPM tools) supporting budgeting/forecasting workflows and financial reporting.
- 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.
Nice to have (Assets)
- Experience with Direct Lake semantic models and Fabric Warehouse vs. Lakehouse design choices.
- Python/PySpark for transformations; performance tuning of large fact tables/slowly changing dimensions.
- Data governance tools (e.g., Purview ) and KPI/metrics standardization.
- Forecasting methods (classical time series or ML) applied to finance, commence, and operations datasets.
- Public-sector or Crown corporation experience.
