Operations Data analyst

Job title: Operational Data Analyst Location: Toronto, ON (4 days onsite) Duration: 18 Month Contract Description: Data Analysis & Reporting: • Analyze operational, onboarding, and regulatory datasets to identify trends, exceptions, risks, control gaps, and process improvement opportunities. • Perform data reconciliations, root cause analysis, and exception reporting. • Build and maintain dashboards, scorecards, and management reporting using Power BI, Excel, and SharePoint, with appropriate data validation and documentation. • Support data governance and data quality initiatives through validation and monitoring activities. Regulatory & Remediation Support • Support regulatory initiatives and remediation programs through data analysis, impact assessments, documentation, and status tracking. • Support data mapping and help identify affected populations, account classifications, and regulatory reporting requirements under the guidance of subject-matter experts. • Produce analysis and documentation supporting regulatory readiness and audit requests. Business Analysis & Requirements Management • Support the gathering, documentation, and validation of business requirements for operational and technology initiatives. • Assist with process mapping, workflow documentation, current-state assessments, and future-state design. • Support stakeholder workshops and requirements discussions across business and technology teams. • Maintain requirements traceability and support testing activities for solution implementation. Process Improvement & Automation • Design and implement process improvement initiatives using Lean / OpEx methodologies. • Develop and maintain appropriately governed low-code/no-code solutions, such as Power Automate workflows, Power Apps, forms, and SharePoint-based tools, to reduce manual effort, errors, and operational risk. • Collaborate with Technology and business stakeholders to identify, assess, test, document, and support implementation of automation opportunities. • Assist with the implementation of technology to help streamline the front-to-back process. • Produce management reporting as required. Project & Governance Support • Maintain project trackers, risk logs, action-item inventories, and management reporting. • Coordinate stakeholder follow-ups, meeting materials, and project documentation including status updates. • Monitor project milestones, deliverables, and issue resolution activities. Knowledge: ▪ An undergraduate degree in a STEM or Finance related discipline. ▪ Interest in financial services and willingness to learn Capital Markets onboarding, AML/KYC, data governance, and the regulatory environment. Prior industry knowledge is not required. ▪ Working knowledge of trading products across Global Markets as well as Investment & Corporate Banking products. (nice to have) ▪ Working knowledge of the competitive marketplace, trends and regulations in the industry (nice to have) ▪ Working knowledge of relevant regulations including CIRO, FINRA, FATCA/CRS, Dodd-Frank, SEC Security-Based Swaps, Canadian Trade Reporting and NI 93-101 (nice to have) Technical Skills ▪ Strong Excel skills, including formulas, PivotTables, charts, and data cleaning; exposure to Power Query is preferred. VBA is an asset, not a requirement. ▪ Experience gained through coursework, internships, co-ops, capstone projects, or employment using Power BI or another data visualization tool. ▪ Foundational SQL and data analysis skills; exposure to Python or another analytics language is an asset. ▪ Exposure to MS 365 tools such as SharePoint, Power Automate, Power Apps, Forms, or comparable low-code/no-code platforms. ▪ Exposure to process mapping tools such as Visio, Lucidchart, or equivalent. ▪ Ability to document analysis, logic, controls, and user instructions, and to present findings clearly. Dexian stands at the forefront of Talent + Technology solutions with a presence spanning more than 70 locations worldwide and a team exceeding 10,000 professionals. As one of the largest technology and professional staffing companies and one of the largest minority-owned staffing companies in the United States, Dexian combines over 30 years of industry expertise with cutting-edge technologies to deliver comprehensive global services and support. Dexian connects the right talent and the right technology with the right organizations to deliver trajectory-changing results that help everyone achieve their ambitions and goals. To learn more, please visit https://dexian.com/. Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.

The role involves analyzing operational and regulatory datasets to identify risks and process improvements while building dashboards in Power BI and Excel. Additionally, the analyst will support regulatory remediation programs and implement low-code automation solutions to reduce manual effort.

Candidates must have an undergraduate degree in a STEM or Finance-related field and proficiency in Excel, Power BI, and SQL. Experience with MS 365 low-code tools and process mapping software is highly desired.

• Power BISouhaitée
• SQLSouhaitée
• Analyse de donnéesSouhaitée
• Microsoft ExcelSouhaitée
• SharePointSouhaitée
• Root Cause AnalysisSouhaitée
• Process MappingSouhaitée
• Analyse d’affairesSouhaitée
• PythonSouhaitée

Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.

• Data Analysis
• Power BI
• Excel
• SQL
• Power Automate
• Power Apps
• SharePoint
• Process Mapping
• Root Cause Analysis
• Lean Methodology
• Business Analysis
• Data Governance
• Regulatory Reporting
• Python
• Visio
• Requirements Management

• Data & Analytics
• Finance & Accounting
• Technology
• Consulting
• Administrative

Formation minimale

Baccalauréat

Expérience minimale

0+ ans

Postuler avant le

10 oct. 2026

Langue de l’offre

anglais

Heures de travail

40 heures par semaine

Présence au bureau

4 jours par semaine

Niveau d’expérience

Entry level

Mode de candidature

La candidature directe est offerte