Data Systems Analyst
3 weeks ago
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.
-
Systems Analyst
7 days ago
Ottawa, Canada NTT DATA Full timeWe are currently seeking a Systems Analyst to join our team in Canada. Location: Remote Language: Bilingual (English/French) Security: Reliability **How You'll Help Us**: We are looking for a Systems Analyst with 5 years experience. You will work collaboratively with stakeholders to identify improvements and design systems to implement those and...
-
Finance System
1 week ago
Ottawa, Canada The Royal Full timeJoin to apply for the Finance System & Data Analyst role at The Royal. Ottawa, Ontario, Canada Base pay range CA$48.62/hr - CA$56.36/hr Our current hybrid model requires employees to work on-site three days per week. This schedule supports collaboration while offering flexibility. Please note that on-site requirements may change at any time based on...
-
Business Systems Analyst– CRM
2 weeks ago
hybrid Toronto/Ottawa/Calgary, Ontario, Canada . full-time . November , Qu Data Centres Full time $80,000 - $120,000 per yearBold ideas need dependable infrastructure and people who can build and maintain it. At Qu, we run sovereign, in-country infrastructure, data centres, cloud, and managed services, so Canada's builders and innovators can move fast without trading away control. Your work will help keep data close to home, accelerate teams, and scale growth for the builders and...
-
Ottawa, Canada NTT DATA North America Full timeA leading data services provider in Ottawa seeks a Vision AI Data Analyst to ensure data accuracy and compliance from monitoring systems in manufacturing. The ideal candidate will analyze operational data, facilitating significant cost savings through process improvements. Responsibilities include data management, analytics and reporting, root cause...
-
Vision AI Data Analyst
4 days ago
Ottawa, Canada NTT DATA North America Full timeNTT DATA North America provided pay range This range is provided by NTT DATA North America. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range $50.00/hr - $60.00/hr Job Overview NTT DATA's Client is seeking a Vision AI Data Analyst to play a critical role in ensuring data accuracy,...
-
Intelligence Mission Data Systems Analyst
4 days ago
Ottawa, Canada ADGA Group Consultants Inc Full timeJob DescriptionADGA is hiring an Intelligence Mission Data Systems Analyst to support the Options Analysis and Definition phase activities for our defence client on their Intelligence Mission Data (IMD) project. The Senior Systems Analyst will work collaboratively with stakeholders providing analytical and technical assistance to identify, assess, and...
-
Strategic Finance Systems
1 week ago
Ottawa, Canada The Royal Mental Health Centre Full timeA leading mental health organization in Ottawa seeks a Finance Systems & Data Analyst to deliver accurate financial services and analysis. The role includes building stakeholder relationships, analyzing financial data, and developing reporting models. Candidates should have a relevant degree, strong analytical skills, and proficiency in financial tools like...
-
Remote Data Governance
4 days ago
Ottawa, Canada S.i. Systems Full timeA leading data management firm is looking for a Data Governance Reporting Analyst to support enterprise data governance metrics and compliance activities. The role involves developing reports and dashboards while ensuring adherence to regulatory standards set by OSFI. Ideal candidates will have 3-5 years of experience in data governance within financial...
-
Remote Data Governance
4 days ago
Ottawa, Canada S.i. Systems Full timeA leading data management firm is looking for a Data Governance Reporting Analyst to support enterprise data governance metrics and compliance activities. The role involves developing reports and dashboards while ensuring adherence to regulatory standards set by OSFI. Ideal candidates will have 3-5 years of experience in data governance within financial...
-
Intelligence Mission Data Systems Analyst
5 days ago
Ottawa, Ontario, Canada ADGA Group Consultants Inc Full time US$100,000 - US$150,000 per yearJob Description ADGA is hiring an Intelligence Mission Data Systems Analyst to support the Options Analysis and Definition phase activities for our defence client on their Intelligence Mission Data (IMD) project. The Senior Systems Analyst will work collaboratively with stakeholders providing analytical and technical assistance to identify, assess, and...
