Senior Lakehouse Engineer


On Site
Full Time
No Travel Required


Data Vault modelling
Dimensional Modelling
Data Modelling

Job Details

Job Title : Senior Lakehouse Engineer

Job Location : New Haven, CT

Job Type : Full Time(Direct Hire)

Job Description:

  • The Sr. Lakehouse Engineer will be responsible for designing, developing, testing, and deploying data vault models, Snowflake SQL, Snowflake data views.
  • The role also includes documenting and updating the Data Warehouse vault monitoring strategies, audit and controls and production release processes.
  • The primary objective of this role is to ensure that the Data Lake House and related solutions are running effectively and meeting the business s needs around data.

Core Responsibilities

  • Lead Lakehouse projects related to Snowflake and Data Vault modelling.
  • Should have a strong grasp of SQL, as the Snowflake database uses this language for database queries and data views.
  • They should be able to write complex queries and optimize them for performance.
  • The Snowflake database is a cloud-native platform, familiarity with cloud services, particularly Azure is required.
  • Snowflake-specific knowledge: They should be well-versed in Snowflake's unique features, like its handling of data (i.e., semi-structured) and its approach to data sharing and security.
  • Designs, develop and test data models, including domain data models, MDM, data lakes, data vaults and modelling supporting various operational requirements.
  • Supports the design of current and future Lakehouse solutions, including overall design, technology stacks, data vault modelling methodology, data movement, and testing.
  • Contributes to the organization's overall information/data management strategy, ensuring that it is an integrated part of the overall business strategy.
  • Provide subject matter expertise in the areas of Snowflake, Data Vault Architecture, Data Movement, and Data Vault Modelling.
  • Contribute to the development and maintenance of data applications including the data, software, and infrastructure architectures.
  • Provide subject matter expertise and mentor team members.

Skills Qualifications

  • Demonstrates a strong aptitude in SQL, data architecture, data vault methodologies, and industry trends.
  • Experience in developing and delivery initiatives including the internal development of EB&IM tools.
  • Excellent written, verbal, interpersonal and cross functional collaboration skills.
  • Past data strategy and quality experience within the insurance industry.
  • Expert knowledge of the enterprise uses of data and end-to-end data flows within the enterprise.

Systems/Technical Knowledge

  • Understanding of cloud Lakehouse technologies: Snowflake and Data Vault modelling experience.
  • Database and application development experience in relational databases i.e., Snowflake and cloud technologies.
  • Data Vault Modelling, Data Warehousing, Dimensional Modelling, Data Modelling for Data Vault & Metadata Management.
  • Working knowledge of data security frameworks, data quality frameworks, metadata management and data catalogues, and data governance frameworks.


  • BA or BS in Computer Science, Information Systems, or related field.


  • 10-15 years related work experience in the design and development of database management systems or equivalent combination of training and experience.