Data Modeler

Toronto, ON
On-site
Posted Oct 15, 2026
1 position

Opens LinkedIn

Employment type: Contract
Experience level: Senior · 5+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Direct apply is available

Job summary

Analyze banking and KYC-related requirements, create data mapping specifications, develop SQL logic, and perform production data investigations to support business scenarios and resolve defects. Collaborate with business, architecture, development, and QE teams on solution design, testing, data governance, and technical change requests.

Job details

Job Description –Data Modeler Domain: Banking / Financial Services Location: Toronto Canada Role Overview We are seeking an experienced Data Modeler with strong SQL, data analysis, data modeling, and banking domain knowledge. The ideal candidate should have hands-on experience in KYC, sanctions screening, data mapping, production data analysis, and solution design, with the ability to work closely with Business, Architecture, Development, and QE teams. Key Responsibilities Demonstrate strong knowledge of the KYC domain, including primary and alternate business scenarios. Analyze business requirements and prepare Data Mapping Specifications using TD templates, coordinating stakeholder reviews. Review QE test cases and provide data-related feedback and recommendations. Understand interim vs. target-state architecture and participate in solution design discussions. Drive technical discussions with stakeholders and help reach appropriate solution conclusions. Perform hands-on production data analysis, data mining, and data extrapolation based on business scenarios. Understand enterprise data models and develop complex SQL queries for data validation and investigation. Prepare SQL logic and pseudo-code and hand it over to Development and QE teams. Investigate production defects and provide quick, detailed data-driven analysis for business queries. Support data security classification, data modeling, and data governance requirements. Demonstrate knowledge of sanctions screening / AML / KYC processes and related data requirements. Author Technical Change Requests (TCRs) and coordinate required leadership approvals. Collaborate effectively with Business Analysts, Data Architects, Developers, QE teams, and business stakeholders. Required Skills Strong KYC / AML / Sanctions Screening domain knowledge. Excellent SQL and hands-on data analysis skills. Strong understanding of data modeling and data mapping. Experience working with production data and data mining. Ability to analyze business scenarios and translate them into technical/data requirements. Experience with solution design and architecture discussions. Strong understanding of data security classification and data governance. Experience preparing technical documentation, mapping specifications, and change requests. Strong stakeholder communication and problem-solving skills. Banking / financial services experience preferred. Preferred Profile KYC + SQL + Data Analysis + Data Modeling + Data Mapping + Sanctions/AML + Production Data Analysis + Solution Design + Technical Change Requests + Banking Domain.

What you’ll do

Requirements

The role requires strong KYC, AML, and sanctions screening knowledge, along with excellent SQL, data analysis, data modeling, and data mapping skills. Candidates should have experience with production data, solution design, technical documentation, data governance, and stakeholder collaboration; banking experience is preferred.