Overview
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 modeling.
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 modeling supporting various operational requirements.
Supports the design of current and future Lakehouse solutions, including overall design, technology stacks, data vault modeling 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 Modeling.
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 modeling experience
Database and application development experience in relational databases i.e. Snowflake and cloud technologies
Data Vault Modeling, Data Warehousing, Dimensional Modeling, Data Modeling for Data Vault & Metadata Management
Working knowledge of data security frameworks, data quality frameworks, metadata management and data catalogs, 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.
Nesco Resource provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
