Data Modeler

Job summary

Develop and review data mapping specifications, analyze production data, create complex SQL queries and pseudocode, and support solution design for KYC and sanction-screening scenarios. Collaborate with business, architecture, development, and quality engineering teams to validate requirements, investigate production defects, and coordinate technical changes.

Job details

Data Modeler – KYC & Data Analysis Location: Toronto, Canada Duration: Long-Term Contract Job Description We are seeking an experienced Data Modeler with strong SQL, data analysis, data modeling, and KYC domain knowledge. The ideal candidate will support data mapping, sanction screening, solution design, production issue analysis, and collaboration with business, development, and quality engineering teams. Key Responsibilities Apply strong knowledge of KYC (Know Your Customer) processes, sanction screening, and data security classification. Identify primary and alternate business scenarios and document requirements using established templates. Prepare detailed Data Mapping Specifications and coordinate stakeholder reviews and approvals. Understand current/interim and target-state architecture designs and facilitate solution design discussions. Perform hands-on data analysis and data mining using production data to validate business scenarios and identify data issues. Understand data models and relationships, develop complex SQL queries, and provide pseudocode to development and quality engineering teams. Review QE test cases and provide feedback to ensure adequate business scenario coverage and data validation. Investigate production defects and respond to business queries with detailed root cause analysis and timely resolutions. Prepare technical change requests and coordinate approvals with leadership and relevant stakeholders. Work closely with business analysts, architects, developers, and QA teams to ensure accurate data mapping and implementation. Required Skills Strong SQL skills and hands-on data analysis experience. Solid understanding of data modeling concepts, data structures, and data relationships. Good knowledge of KYC processes and sanction screening. Experience with data mapping, source-to-target mapping, and data validation. Understanding of data security classification and sensitive data handling. Knowledge of solution architecture, interim and target-state designs, and technical change management. Experience analyzing production data, troubleshooting defects, and performing root cause analysis. Strong communication, documentation, stakeholder management, and problem-solving skills.

What you’ll do

Develop and review data mapping specifications, analyze production data, create complex SQL queries and pseudocode, and support solution design for KYC and sanction-screening scenarios. Collaborate with business, architecture, development, and quality engineering teams to validate requirements, investigate production defects, and coordinate technical changes.

Requirements

Requires strong SQL and hands-on data analysis experience, solid knowledge of data modeling and data relationships, and familiarity with KYC, sanction screening, data mapping, and sensitive data handling. Candidates should also have experience with solution architecture, production troubleshooting, root cause analysis, technical change management, and stakeholder communication.

Listed skills

• SQL · Preferred
• Problem solving · Preferred
• Data Validation · Preferred
• Data analysis · Preferred
• Documentation · Preferred
• Root Cause Analysis · Preferred
• Stakeholder Management · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Data Analysis
• Data Modeling
• KYC Processes
• Sanction Screening
• Data Mapping
• Source-To-Target Mapping
• Data Validation
• Data Security Classification
• Production Data Analysis
• Root Cause Analysis
• Solution Architecture
• Technical Change Management
• Stakeholder Management
• Documentation
• Problem-Solving

Job areas

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

More jobs from Confiar Services