Senior Lakehouse Engineer

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.

Education

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

Experience

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