Data Modeller

Cynet Systems; Toronto; On-site; CAD 75,000 - 90,000; Part time

Job summary

A technology consulting firm is seeking an experienced Data Modeller in Toronto, ON. The role demands deep expertise in data profiling, mapping, and governance, along with hands-on experience in data modeling. Candidates should have at least 6 years in data and analytics, demonstrate proficiency with SQL and Informatica, and possess familiarity with AWS. Strong communication skills and the ability to work with business stakeholders are essential. The position involves defining data projects and ensuring best practices are followed.

Qualifications

• 6+ years of experience in data and analytics.
• Proven experience developing complex data and analytic solutions.
• Strong SQL skills are a must.

Responsibilities

• Perform data profiling, mapping, and data modeling.
• Query data repositories for data quality and transformation rules.
• Create and update conceptual and logical data models.

Skills

Data profiling

Data mapping

Data modeling

Data governance

Informatica

SQL

AWS

Python

Tools

Informatica Data Quality

IBM Data Architect

Erwin

Job description

We are looking for Data Modeller for our client in Toronto, ON

Job Title: Data Modeller

Job Location: Toronto, ON

Job Type: Contract

Job Description:

Required:

• 6+ years of progressive experience in the data and analytics, including large customer data bases and work with product, geographic, demographic, customer, prospect, producer, social, machine and unstructured data to identify trends and opportunities), business consulting, or data governance field and/or manipulation of complex high-volume data from a variety of sources.
• Experience successfully developing and implementing complex data and analytic solutions that meet business needs within tight time frames.
• Experience in AWS.
• Programming in Python a plus.

Responsibilities:

• Candidate must have strong skills in data profiling, mapping , data modeling and data governance.
• Includes ability to query data repositories to determine Source to target mappings, data quality, completeness and transformation rules necessary for merging into target repositories
• Strong skills in Informatica, Informatica Data Quality, Information Analyzer, and IBM data architect, Erwin is big plus. Strong SQL skills are a must.
• Hands-on experience in creating/updating conceptual, logical, and physical data models most appropriately needed to satisfy the business requirements.
• Should be able to understand and explain complex data integration and extraction/transformation/load processes (ETL).
• Should be able to work with the business to define scope of Data-centric or supportive projects.
• Should be competent in reviewing the Project Initiation Document, Reference/Domain value mapping.
• Should be able to work with Business and Architects to identify Pain points impacting data capabilities.
• Should be able to establish a program/project-specific Data Analysis approach.
• Should be competent at Source-Target Data mapping, S/T Record building/ Join conditions, writing transformations building data lineage.
• Should be able to conduct Peer Reviews.
• Should be able to support ETL/Test questions, output file validation, and defect analysis.
• Should ensure data analysts (and other data leads, as necessary) are following standard work and best practices.