Senior Data Functional Analyst

CoFoMo Inc.; Montreal (administrative region); Hybrid; CAD 85,000 - 125,000; Full time

Job summary

COFOMO in Montreal is seeking a Senior Data Functional Analyst to drive functional analysis across data platforms, regulatory reporting, and data governance. You will translate business needs into clear specifications and work with operations, compliance, data engineering and product teams to ensure data models meet regulatory requirements.

You will collaborate closely with data engineers and analysts to validate data flows, perform impact analyses and support agile delivery.

Qualifications

• 7+ years in functional/data analysis in banking or financial services.
• Fluent in French and English for daily tasks.
• Proficient SQL Server and T-SQL with strong data analysis skills.
• Experience with Snowflake, AWS, ETL/ELT concepts.

Responsibilities

• Collect, analyze and document data and business needs for regulatory reporting.
• Translate operations and compliance needs into functional requirements and user stories.
• Define data rules, mappings, and data quality controls; validate data models.
• Collaborate with stakeholders and cross-functional teams; support validation and workshops.

Skills

SQL Server

T-SQL

Snowflake

Power BI

Tableau

Git

Jira

Confluence

Bitbucket

GitHub Actions

Data Vault

Dimensional Modeling

Data Governance

Metadata Management

Data Quality

APIs

Data Exchanges

Agile

Scrum

Kanban

SAFe

French language

English language

AWS

ETL/ELT

Education

CBAP certification

PMI-PBA certification

SAFe certification

Tools

Snowflake

AWS

Power BI

Tableau

Git

Jira

Confluence

Job description

# Senior Data Functional AnalystMontrealHybridAgility and Product ManagementApplyWith over 30 years of recognized expertise, COFOMO is now a leading Canadian consulting firm specializing in digital and artificial intelligence. Supported by more than 3,000 experts, 10 Centers of Excellence, and 4 offices across the country, we are uniquely positioned to successfully guide our clients through their transformations. Both strategic and tactical, we help organizations across a wide range of industries thrive in today’s rapidly evolving world.## Our promiseHelp our clients succeed and maximize the impact of their transformation initiatives, turning them into powerful drivers of growth and innovation.## Job description**Here's a brief overview of the tasks and responsibilities you'll have :** • Collect, analyze and document business and data needs related to the suspicious transaction reporting process; • Understand current processes, manual activities, operational irritants, and automation opportunities; • Translate the needs of operations and compliance teams into functional requirements, user stories, and acceptance criteria; • Identify the data required for alert analysis, file processing, and regulatory filings; • Perform mapping of business concepts, source data and target data structures; • Define rules for business, transformation, enrichment, standardization and validation of data; • Assess the availability, accessibility, quality and relevance of data sources as needed; • Collaborate in the integration of new data related to transactions, accounts, customers, counterparties, sessions and records; • Establish controls to ensure completeness, consistency, validity and traceability of data; • Participate in the design of data models and validate their alignment with operational and regulatory needs; • Maintain an end-to-end view of data flows, from source systems to analysis and reporting solutions; • Perform impact analyses associated with changes in data, business rules, processes or systems; • Contribute to product backlog prioritization, user story refinement and delivery planning; • Prepare and facilitate analysis, mapping and validation workshops with stakeholders; • Collaborate with business specialists, product owners, developers, data engineering consultants, designers, architecture consultants, and source systems teams; • Support functional validation activities, acceptance testing and anomaly resolution; • Produce and maintain clear, complete, and usable functional documentation; • Act as a functional reference for data and promote knowledge transfer within the team. **The profile you are looking for is as follows:** • Have a minimum of seven (7) years of experience in functional analysis, business analysis or data analysis; • Have significant experience in the banking or financial services sector; • Demonstrate excellent communication, workshop facilitation and consulting skills; • Develop the capacity to influence and engage stakeholders from multiple sectors; • Demonstrate a high level of autonomy, initiative and leadership in a context of transformation; • Possess excellent analytical, problem-solving and synthesis skills; • Proficiency in Microsoft SQL Server, including T-SQL, stored procedures, views, query optimization, and data analysis; • Run complex SQL queries and analyze large volumes of data; • Familiarity with Snowflake, AWS cloud data architectures, ETL and ELT concepts; • Use Power BI, Tableau, or other data visualization and analysis tools; • Master Git, Bitbucket, GitHub Actions, Jira, and Confluence; • Understand Data Vault approaches, dimensional modeling, and data governance principles; • Be familiar with the concepts of data quality, metadata management, and traceability; • Evolve in Agile environments such as Scrum, Kanban, or SAFe; • Understand modern data architectures, APIs, and data exchanges between systems; • Interpret conceptual, logical and physical data models; • Knowledge of the financial crime field, including anti-money laundering, regulatory requirements, sanctions or screening (an asset); • Experience in automating regulatory or operational processes (an asset); • Have completed data transformation or analytics platform modernization initiatives (an asset); • Hold a certification in business analytics, data governance, or agility, such as CBAP, PMI-PBA, Scrum, or SAFe (an asset); • This position requires fluency in French and English for daily tasks, understanding documentation, and professional communication with customers, suppliers, and colleagues across Canada. French and English language skills are essential, both oral and written.