Data Designer, Markham

Note: Candidate needs to be onsite Mon/Tue/Wed (this is mandatory)

First round will be Virtual and 2nd customer round will be in-person.

Job Title: Data Designer

Location: Markham, ON

Model: Hybrid (3 Days Onsite (Mon/ Tues/ Wed))

Job Type: Full time

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.