Etl Data Engineer

 

Description:

ETL Data Engineer

Location : Markham, ON

What you’ll do

  • Work with the ETL data engineering team & business intelligence team to understand requirements for the database design and model the data as per the needs of business.
  • Work with the ML engineering team and understand the needs for ML models and appropriately build the data models for their feature stores.
  • Be in charge of developing conceptual, logical, and physical data models and implementing RDBMS, operational data stores (ODS), data marts, JSON/XML schemas and data lakes schemas on target platforms (SQL/NoSQL).
  • Manage the extension of existing data architecture and optimize data query performance through best practices. The applicant must be capable of working both alone and cooperatively.
  • Collaborate with the development team to design and build the database model.
  • Work in collaboration with data engineering teams in documenting the source to target mappings.
  • Experience working with relational, dimensional and data vault data modeling techniques.
  • Understand the company’s data migration needs.
  • Work with the development team to implement the migration rules related to data.
  • Work with data scientists to understand feature engineering needs and design the required logical & physical data models in the underlying ecosystem
  • Help determine data security needs and work with security or infra teams to implement security solutions.

 

What you’ll bring

  • A bachelor’s degree in management information systems, Computer Science, Computer Information Systems, or a related Information Technology area
  • Minimum 10 years of experience successfully leading Data modeling & design with expertise in building large-scale enterprise data models.
  • Solid grasp/experience with data technologies & tools (Snowflake, Hadoop, PostgreSQL, Informatica, DBT cloud, Airflow, AWS Glue etc.,)
  • Proficient in industry-standard data modelling methodologies
  • Excellent teamwork and communication abilities
  • Excellent consultative, facilitative, and consensus-building abilities
  • Proven expertise in developing relational databases in a corporate context.
  • Demonstrated expertise in developing models for Business Intelligence solutions
  • Excellent analytical, data profiling, and problem-solving abilities
  • Excellent oral and written communication abilities
  • Advanced SQL knowledge
  • Thorough understanding of modelling methodology and procedures
  • Thorough understanding of facilitation and dispute resolution methods
  • Knowledge of Business Intelligence products
  • Outstanding knowledge and experience in ETL with any of the ETL tool product suite.
  • Experience establishing documentation standards frameworks for data quality, data governance, stewardship and metadata management.
  • Ability to foundationally understand complex business process driving technical systems.
  • Excellent verbal and written communication skills.
  • Insurance knowledge an asset.
  • Knowledge of ER modeling, big data, enterprise data, and physical data models
  • Familiarity with data modeling software such as SAP PowerDesigner, Microsoft Visio, or ERWIN Data Modeler
  • Strong attention to detail.
  • Ability to work in a fast-paced environment.
  • Ability to work both independently and as part of a team.

Organization Galent
Industry IT / Telecom / Software Jobs
Occupational Category ETL Data Engineer
Job Location Markham,Canada
Shift Type Morning
Job Type Full Time
Gender No Preference
Career Level Experienced Professional
Experience 10 Years
Posted at 2026-05-19 4:03 pm
Expires on 2026-07-03