Data Systems Analyst

4 weeks ago

Québec QC, 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: 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.

  • Data and Reporting Analyst

    5 days ago

    Québec, Canada Maples Group Full time

    **Position**:Data and Reporting Analyst - Middle Office - Fund of Funds Trade Processing **Location**:Montreal **About Us** The Maples Group is a global leader in financial services, trusted by many of the world’s largest hedge fund managers, private equity firms, and international corporations. Our side-by-side financial and legal teams consistently...

  • Information System Security Specialist(Cissp, Sscp

    1 week ago

    Montréal, QC, Canada NTT DATA Full time

    We are currently seeking a **Information System Security Specialist(CISSP, SSCP, and CISM) - Onsite Hybrid** to join our team in Montreal, Quebec (CA-QC), Canada (CA). **Job Responsibilities Include**: - Conducting remote/in-person interviews with system owners/vendors to get all the required information for assessment and to identify any gaps. - Reviewing...

  • Data analyst

    1 week ago

    Québec City, Canada EXFO Full time

    Job SummaryWe are seeking a proactive and technically skilled Data Analyst to drive operational efficiency through data-driven insights and automation. This role focuses on streamlining logistics and operational workflows using advanced analytics and automation tools such as Power BI and Power Automate. Key Responsibilities Analyze operational data to...

  • Data Analyst

    2 weeks ago

    Québec, Canada Cloudvital Technologies Full time

    **Job Title**:Data Analyst **Job Location**: Montreal **Job Type**: Hybrid - **This is a Hybrid role with 3 days in office and 2 days remote**_ **Key Responsibilities** - Develop and maintain reports and dashboards to track critical metrics and project stats, such as firm-wide encryption status and data-in-transit encryption metrics. - Design and...

  • Business Systems Analyst

    2 weeks ago

    Quebec (QC), Canada Qorali Full time

    As the D365 Business Systems Analyst, you will act as the bridge between business stakeholders and technical teams, ensuring that Microsoft Dynamics 365 (D365) applications are optimized to meet organizational needs. You will analyze business processes, design system enhancements, and provide ongoing support to maximize the value of our ERP ecosystem. Key...

  • Data Engineer

    3 weeks ago

    Québec, QC, Canada Future Electronics Full time

    About the role Data engineers design, build, and optimize systems for data collection, storage, access, and analytics at scale. They create data pipelines that convert raw data into formats usable by data scientists, data-centric applications, and other data consumers. Their primary responsibility is to make data available, accessible, and secure to...

  • Data Engineer

    1 week ago

    Québec, QC, Canada Future Electronics Full time

    About the role Data engineers design, build, and optimize systems for data collection, storage, access, and analytics at scale. They create data pipelines that convert raw data into formats usable by data scientists, data-centric applications, and other data consumers. Their primary responsibility is to make data available, accessible, and secure to...

  • Business Systems Analyst

    2 weeks ago

    Montréal, QC, Canada Qorali Full time

    As the D365 Business Systems Analyst, you will act as the bridge between business stakeholders and technical teams, ensuring that Microsoft Dynamics 365 (D365) applications are optimized to meet organizational needs. You will analyze business processes, design system enhancements, and provide ongoing support to maximize the value of our ERP ecosystem. 🎯...

  • Business Systems Analyst

    2 weeks ago

    Montréal, QC, Canada Qorali Full time

    As the D365 Business Systems Analyst, you will act as the bridge between business stakeholders and technical teams, ensuring that Microsoft Dynamics 365 (D365) applications are optimized to meet organizational needs. You will analyze business processes, design system enhancements, and provide ongoing support to maximize the value of our ERP ecosystem. Key...

  • Business Systems Analyst

    2 weeks ago

    Montréal, QC, Canada Qorali Full time

    As the D365 Business Systems Analyst, you will act as the bridge between business stakeholders and technical teams, ensuring that Microsoft Dynamics 365 (D365) applications are optimized to meet organizational needs. You will analyze business processes, design system enhancements, and provide ongoing support to maximize the value of our ERP ecosystem. 🎯...