Data Solutions Engineer - Snowflake

Indianapolis, Indiana
Oct 05, 2021
Dec 04, 2021
Actuary, IT
Job Type
Not Specified
Career Level
Not Specified

At Liberty Mutual, our purpose is to help people embrace today and confidently pursue tomorrow. That's why we provide an environment focused on openness, inclusion, trust and respect. Here, you'll discover our expansive range of roles, and a workplace where we aim to help turn your passion into a rewarding profession. We value your hard work, integrity and commitment to make things better, and we put people first by offering you benefits that support your life and well-being. To learn more, please visit


Liberty Mutual has proudly been recognized as a Great Place to Work by Great Place to Work® US for the past several years. We were also selected as one of the 100 Best Places to Work in IT on IDG's Insider Pro and Computerworld's 2020 list. We have been named by Forbes as one of America's Best Employers for Women and one of America's Best Employers for New Graduatesas well as one of America's Best Employers for Diversity. To learn more about our commitment to diversity and inclusion please visit:


Liberty Mutual is an equal opportunity employer. We will not tolerate discrimination on the basis of race, color, national origin, sex, sexual orientation, gender identity, religion, age, disability, veteran's status, pregnancy, genetic information or on any basis prohibited by federal, state or local law

Data Solutions Engineer - Snowflake 


The Data and Analytics Engineering (DAE) organization of Liberty Mutual US Global Retail Marketing is expanding its data strategy/innovation team. DAE Data Solutions Engineers design solution architectures and evaluate technologies for applicability that translate complex business requirements into usable computer systems. Data Solutions Engineers work with data architects and data modelers to evaluate data products and design data integrations that meet organizational needs using conceptual and logical architecture models. This position is focused on the design and deployment of Snowflake features and optimization as the core platform for the DAE datalake. This position will work closely with data modelers building the enterprise data vault model within the datalake.


An ideal Data Solutions Engineer is an analytical and creative thinker who is not intimidated by roadblocks and challenges. They understand how to successfully evaluate problems and develop appropriate solutions. Data Solutions Engineers perform well under pressure, possessing great focus while completing projects efficiently. They should be able to work well as part of a team, but also carry responsibility for their own work. Data Solutions Engineers also need to be able to work on multiple projects at a time, with the ability to quickly understand and incorporate new technologies.


What you will do:

  • Work with the Data Office, DAE, Architecture and Application Development teams to translate business needs into data lake solutions
  • Collaborate with development teams, peer solution engineers, and architects to ensure solution alignment with technical architecture, business plans, and long-term strategy
  • Collaborate with data modelers in applying Physical data vault models within Snowflake
  • Lead proof of concepts to compare data analytics and data lake products and evaluate new technologies
  • Manage the product standard lifecycle for cloud-based data lake and feature store products
  • Architect and design ingestion, processing and consumption patterns and best practices for use across multiple business domains to enable seamless integration of data movement from applications to datalake
  • Create and publish logical technical architecture diagrams documenting the reusable solutions for data lake ingestion, processing and consumption.
  • Lead modernization of legacy systems to drive supportability, integration with newer technologies, and improve developer productivity
  • Support Agile development squads with adoption of new integration technical solutions
  • Participate in Data Governance procedures and policy management
  • Mentor and contribute to Data Management and Data Architecture standards and best

  • Bachelor's degree in Computer Science or similar
  • 5+ years experience with experience with cloud-based Data Warehouse and Data Lake environments
  • 3+ years experience in converting relational data to/from semi-structured data (XML, JSON, Parquet)
  • 3+ years experience with Snowflake administration, security, optimization, and feature exploitation
  • 2+ years experience with Snowflake capacity planning and cost monitoring
  • Prior experience with relevant AWS services (S3, Glacier, EC2)
  • Prior experience with CDC, ETL, event messaging, API, streaming or other ingestion mechanisms
  • 5+ years experience in Software Development using SQL and/or Python
  • Prior experience with data vault modeling
  • Must be able to work independently and collaboratively on large scale data projects
  • Strong leadership, communication, collaboration skills with a track record of taking solution ownership
  • Familiarity with Data Warehouse modeling techniques like Data Vault 2.0 and Dimensional

Experience in these areas is a Plus:

  • Experience working with insurance industry standard canonical models (ACORD)
  • Experience with data modeling tools such as Erwin or ER/Studio
  • Experience with legacy migrations to Snowflake
  • Experience with MDM solutions
  • Demonstrated experience delivering data solutions via agile methodologies
  • Exposure to Business Intelligence tools (PowerBI, MicroStrategy)
  • Experience with insurance industry processes

Similar jobs

Similar jobs