Senior Lakehouse Engineer

4 weeks ago

New Haven, United States iTech Solutions Full time

Sr. Lakehouse Engineer


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.
For more information please contact Vijay Karney at or

Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.

Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.

Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position. Senior Lakehouse Engineer

  • Senior Lakehouse Engineer

    3 weeks ago

    New Haven, United States Aquinas Consulting Full time

    Job Description Job Description Senior Lakehouse Engineer Aquinas Consulting is looking to fill a Senior Lakehouse Engineer Job in New Haven County, CT. In this position, you will be tasked with designing, developing, testing, and deploying data vault models, Snowflake SQL, Snowflake data views. You must have strong skills in SQL and cloud technologies. This...

  • Senior Lakehouse Engineer

    2 weeks ago

    New Haven, United States Aquinas Consulting Full time

    Job Description Job Description Senior Lakehouse Engineer Aquinas Consulting is looking to fill a Senior Lakehouse Engineer Job in New Haven County, CT. In this position, you will be tasked with designing, developing, testing, and deploying data vault models, Snowflake SQL, Snowflake data views. You must have strong skills in SQL and cloud technologies. This...

  • Senior Lakehouse Engineer

    3 weeks ago

    New Haven, United States Aquinas Consulting Full time

    Job DescriptionJob DescriptionSenior Lakehouse EngineerAquinas Consulting is looking to fill a Senior Lakehouse Engineer Job in New Haven County, CT. In this position, you will be tasked with designing, developing, testing, and deploying data vault models, Snowflake SQL, Snowflake data views. You must have strong skills in SQL and cloud technologies. This...

  • Senior Lakehouse Engineer

    2 weeks ago

    New Haven, United States Aquinas Consulting Full time

    Job DescriptionJob DescriptionAquinas Consulting is looking to fill a Senior Lakehouse Engineer Job in New Haven County, CT. In this position, you will be tasked with designing, developing, testing, and deploying data vault models, Snowflake SQL, Snowflake data views. You must have strong skills in SQL and cloud technologies. This job also requires you to...

  • Senior Lakehouse Engineer

    2 weeks ago

    New Haven, United States Aquinas Consulting Full time

    Job DescriptionJob DescriptionAquinas Consulting is looking to fill a Senior Lakehouse Engineer Job in New Haven County, CT. In this position, you will be tasked with designing, developing, testing, and deploying data vault models, Snowflake SQL, Snowflake data views. You must have strong skills in SQL and cloud technologies. This job also requires you to...

  • Senior Lakehouse Engineer

    3 weeks ago

    New Haven, United States NR Consulting Full time

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

  • Senior Lakehouse Engineer

    3 weeks ago

    New Haven, United States NR Consulting Full time

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

  • Senior Lakehouse Engineer

    4 weeks ago

    New Haven, United States NR Consulting LLC Full time

    Job Title : Senior Lakehouse EngineerJob 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...

  • Senior Lakehouse Engineer

    2 weeks ago

    New Haven, United States NESCO Inc Full time

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

  • Senior Lakehouse Engineer

    3 weeks ago

    New Haven, United States NESCO Inc Full time

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

  • Senior Lakehouse Engineer

    2 weeks ago

    New Haven, United States NESCO Inc Full time

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

  • Senior Lakehouse Engineer

    3 weeks ago

    New Haven, United States NESCO Inc Full time

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

  • Director of Health and Wellness

    3 weeks ago

    New Holstein, United States LakeHouse New Holstein Full time

    Job DescriptionJob DescriptionAbout LakeHouse Senior LivingLakeHouse Senior Living proudly manages 39, care- and lifestyle-focused Active Independent Living, Assisted Living, Memory Care, and available, short-term Respite Care communities located throughout the Midwest. Our company, which was built on our “Pillars of Excellence”, employs over 1,100 team...

  • Senior Data Engineer

    2 days ago

    New York, United States Grid Dynamics Full time

    Description Position at Grid Dynamics Our customer is one of the world's largest technology companies based in Silicon Valley with operations all over the world. On this project, we are working with bleeding-edge big data technologies to develop a high-performance data analytics platform, which handles petabytes of data. We are looking for an enthusiastic...

  • Senior System Engineer

    3 weeks ago

    New Haven, United States Vaco Full time

    Job Title: Senior System EngineerLocation: New Haven, CT Position Overview: We are seeking a talented Senior System to join our cilent's team in New Haven, CT. This role is ideal for someone who possesses a blend of L3 Support expertise and Traditional IT Infrastructure Engineering skills, particularly in the End User Support/Desktop Admin domain. Key...

  • Senior System Engineer

    3 weeks ago

    New Haven, United States Vaco Full time

    Job Title: Senior System Engineer Location: New Haven, CT Position Overview: We are seeking a talented Senior System to join our cilent's team in New Haven, CT. This role is ideal for someone who possesses a blend of L3 Support expertise and Traditional IT Infrastructure Engineering skills, particularly in the End User Support/Desktop Admin domain. Key...

  • Senior System Engineer

    3 weeks ago

    New Haven, United States Vaco Full time

    Job Title: Senior System EngineerLocation: New Haven, CT Position Overview: We are seeking a talented Senior System to join our cilent's team in New Haven, CT. This role is ideal for someone who possesses a blend of L3 Support expertise and Traditional IT Infrastructure Engineering skills, particularly in the End User Support/Desktop Admin domain. Key...

  • Senior System Engineer

    1 week ago

    New Haven, United States Vaco Full time

    Job Title: Senior System EngineerLocation: New Haven, CT Position Overview: We are seeking a talented Senior System to join our cilent's team in New Haven, CT. This role is ideal for someone who possesses a blend of L3 Support expertise and Traditional IT Infrastructure Engineering skills, particularly in the End User Support/Desktop Admin domain. Key...

  • Senior System Engineer

    3 weeks ago

    New Haven, United States Vaco Full time

    Job Title: Senior System EngineerLocation: New Haven, CT Position Overview: We are seeking a talented Senior System to join our cilent's team in New Haven, CT. This role is ideal for someone who possesses a blend of L3 Support expertise and Traditional IT Infrastructure Engineering skills, particularly in the End User Support/Desktop Admin domain. Key...

  • Senior System Engineer

    1 week ago

    New Haven, United States Vaco Full time

    Job Title: Senior System Engineer Location: New Haven, CT Position Overview: We are seeking a talented Senior System to join our cilent's team in New Haven, CT. This role is ideal for someone who possesses a blend of L3 Support expertise and Traditional IT Infrastructure Engineering skills, particularly in the End User Support/Desktop Admin domain. Key...