B

Bank of Montreal

Runs Canadian and US banks for people and firms

Senior Data Analyst - Financial Data

Data ManagementConfirmed live in the last 24 hours
Full-timeToronto, ON, Canada$70k - $150kIn-person

About the Job

Requirements

  • A bachelor's degree in Business, Finance, Accounting, Computer Science, Information Systems, or a related field.
  • At least 5 years of experience as a Data Analyst, Business Analyst, Business Systems Analyst, or Finance Data Analyst.
  • Experience working in banking, financial services, regulatory reporting, or finance technology.
  • Strong understanding of financial data structures, accounting and finance concepts, General Ledger processes, financial reporting, and data flows within financial institutions.
  • Experience supporting regulatory and operational reporting initiatives.
  • Advanced SQL skills.
  • Experience with data profiling, reconciliation, data mapping and source-to-target mapping, data lineage analysis, and data quality assessment and issue management.
  • Advanced Excel skills, including formulas, pivot tables, and macros.
  • Knowledge of Power BI, Jira, and Confluence.
  • Experience with requirements gathering and documentation, process mapping and workflow analysis, gap analysis, root cause analysis, stakeholder management, and facilitation.
  • Strong presentation skills and problem-solving abilities, and ability to work independently in ambiguous environments.

Responsibilities

  • Lead requirements-gathering sessions with Finance, Regulatory, Risk, and Technology stakeholders.
  • Document business requirements, functional specifications, process flows, and data requirements.
  • Perform current-state and future-state analysis.
  • Facilitate workshops and stakeholder discussions.
  • Translate business requirements into actionable technical specifications.
  • Analyze complex finance datasets across source systems, data warehouses, and reporting platforms.
  • Investigate data quality issues and identify root causes.
  • Perform data profiling, reconciliation, and validation activities.
  • Support month-end, quarter-end, and regulatory reporting processes.
  • Develop data quality controls and monitoring processes.
  • Define source-to-target mappings for finance and General Ledger data.
  • Support data conversion and transformation initiatives.
  • Analyze lineage from upstream operational systems to Finance and Regulatory reporting.
  • Work with development teams to clarify mapping and transformation requirements.
  • Develop data-driven insights and reporting solutions.
  • Create dashboards using Power BI and other analytics platforms.
  • Deliver executive summaries and recommendations to stakeholders.
  • Support key performance indicator definition and performance measurement initiatives.
  • Create test scenarios and validation criteria.
  • Support user acceptance testing, system integration testing, and production validation activities.
  • Collaborate with quality assurance and project teams to ensure successful delivery.
  • Ensure business requirements are fully traceable through implementation.

Desired Qualifications

  • Banking finance technology experience.
  • Understanding of data governance and data management principles.
  • Experience with data catalog and lineage tools such as Alation and Manta.
  • Experience with enterprise data platforms such as Netezza, Redshift, or AWS Data Platform.
  • SAP S/4 knowledge.

About the Company

Bank of Montreal

Runs Canadian and US banks for people and firms

Bank of Montreal, known as BMO, runs a Canadian bank and a large American bank, serving households and businesses on both sides of the border. Until the Bank of Canada opened in 1935, it acted as the Canadian government's banker. People use its branches and apps for accounts, mortgages, credit cards, and investments, while companies borrow from it and turn to its BMO Capital Markets arm to raise money and trade securities. BMO makes money on the gap between the interest it charges on loans and pays on deposits, plus fees from managing wealth and advising on deals. Bank of Montreal was founded in 1817 as Canada's first bank, and it keeps its legal head office in Montreal and its executive offices in Toronto, Canada.

Company size
10,001+
Company stage
IPO
Headquarters
Toronto, Canada
Founded
1817

Recently Posted Jobs

Explore more opportunities at Bank of Montreal

See more jobs