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.