Senior Data Designer

• 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
• 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
• 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

• A bachelor's degree in Management Information Systems, Computer Science, Computer Information Systems, or a related Information Technology area
• Minimum 8 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
• 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

Insurance knowledge an asset

• medical, vision, dental, life, disability insurance
• paid time off (including holidays, parental leave, and sick leave, as required by law)