IT Systems Analyst

3 weeks ago

Ottawa ON, Canada PrecisionERP PrecisionIT Full time

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: Federal clearance eligibility will be required

Configure and optimize D365 F&O → Azure Synapse Link (tables, change feeds, performance, known limitations).
Ensure reliable replication to Data Lake / Fabric Lakehouse ; 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.

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.

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.
~ 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)
Python/PySpark for transformations; performance tuning of large fact tables/slowly changing dimensions.
Data governance tools (e.g., Forecasting methods (classical time series or ML) applied to finance, commence, and operations datasets.
Public-sector or Crown corporation experience.

  • Business System Analyst

    2 weeks ago

    Toronto, On, Canada Kumaran Systems Full time

    We are seeking a analytical and proactive Business System Analyst to specialize in the management and reporting of our IT asset lifecycle. In this role, you will be the key link between data, technology, and business stakeholders, focusing on mitigating risk by identifying assets approaching End-of-Life (EOL) and End-of-Service (EOS). You will transform raw...

  • Business System Analyst

    2 weeks ago

    Toronto, ON, Canada Kumaran Systems Full time

    We are seeking a analytical and proactive Business System Analyst to specialize in the management and reporting of our IT asset lifecycle. In this role, you will be the key link between data, technology, and business stakeholders, focusing on mitigating risk by identifying assets approaching End-of-Life (EOL) and End-of-Service (EOS). You will transform raw...

  • Business System Analyst

    2 weeks ago

    Toronto, ON, Canada Kumaran Systems Full time

    We are seeking a analytical and proactive Business System Analyst to specialize in the management and reporting of our IT asset lifecycle. In this role, you will be the key link between data, technology, and business stakeholders, focusing on mitigating risk by identifying assets approaching End-of-Life (EOL) and End-of-Service (EOS). You will transform raw...

  • Business System Analyst

    2 weeks ago

    Toronto, ON, Canada Kumaran Systems Full time

    We are seeking a analytical and proactive Business System Analyst to specialize in the management and reporting of our IT asset lifecycle. In this role, you will be the key link between data, technology, and business stakeholders, focusing on mitigating risk by identifying assets approaching End-of-Life (EOL) and End-of-Service (EOS). You will transform raw...

  • Business System Analyst

    2 weeks ago

    Toronto, On, Canada Kumaran Systems Full time

    We are seeking a analytical and proactive Business System Analyst to specialize in the management and reporting of our IT asset lifecycle. In this role, you will be the key link between data, technology, and business stakeholders, focusing on mitigating risk by identifying assets approaching End-of-Life (EOL) and End-of-Service (EOS). You will transform raw...

  • Systems Analyst – NetSuite

    11 hours ago

    Ottawa, Ontario, Canada PureLogic IT Solutions Full time $80,000 - $120,000 per year

    About PureLogic ITPureLogic IT provides innovative IT solutions for the Federal Government and private sector organizations. We enable outcomes as a secure and trusted technology service provider across current and emerging technologies. With expertise across all areas of IT including cloud technology, software solutions, and infrastructure, as well as...

  • Business System Analyst

    2 weeks ago

    Toronto, On, Canada Kumaran Systems Full time

    We are seeking a highly motivated and technical Business Systems Analyst (BSA) for a short-term contract engagement. The ideal candidate will have a strong background in data management and business intelligence, with hands-on experience in Oracle databases and Cognos reporting. This role is critical for supporting and enhancing our data-driven initiatives...

  • Business System Analyst

    2 weeks ago

    Toronto, On, Canada Kumaran Systems Full time

    We are seeking a highly motivated and technical Business Systems Analyst (BSA) for a short-term contract engagement. The ideal candidate will have a strong background in data management and business intelligence, with hands-on experience in Oracle databases and Cognos reporting. This role is critical for supporting and enhancing our data-driven initiatives...

  • Business System Analyst

    4 weeks ago

    Toronto, ON, Canada Kumaran Systems Full time

    We are seeking a highly motivated and technical Business Systems Analyst (BSA) for a short-term contract engagement. The ideal candidate will have a strong background in data management and business intelligence, with hands-on experience in Oracle databases and Cognos reporting. This role is critical for supporting and enhancing our data-driven initiatives...

  • Technical System Analyst

    2 days ago

    Toronto, ON, Canada Atlantis IT Group Full time

    Skills · Over 8+ years of Systems Analyst experience in Applications Development, migration, prod-uct implementation, Integration and Transformation · Experience in analyzing wealth management products, dealership platform, database, API and database queries · Wealth and Asset management domain knowledge · Experience in gathering Integration, business...