Senior Data Engineer - Cloud Pipelines & AI-Driven Data

Liberty Mutual Insurance; Portsmouth (NH); Hybrid; USD 110,000 - 170,000; Full time

Job summary

Liberty Mutual Insurance is seeking a Senior Data Engineer to join the Data and Analytics Engineering team in the PL Product/Finance and Vendor Extract space. The role combines data engineering with business analysis, delivering scalable data pipelines and models.

You will collaborate with product owners, stakeholders, and cross-functional teams to translate requirements into technical data solutions, ensuring data quality and governance.

Qualifications

• 5-6 years of experience in data engineering, data analytics, or a related technical role.
• Strong proficiency in SQL, including writing complex queries, data modeling, and working with relational and analytical databases.
• Familiarity with cloud-based data platforms and tools such as Snowflake, AWS or similar technologies.
• Curious and open to exploring some mainframe technologies.
• Strong analytical and problem-solving skills with ability to interpret data-driven insights.
• Demonstrated ability to work in an agile, squad-based environment with cross-functional teams.
• Proactive, self-motivated, and a logical thinker with attention to detail.
• Excellent written and verbal communication skills for non-technical stakeholders.
• Experience with data integration and ETL/ELT tools such as IDMC.
• Familiarity with CI/CD pipelines, version control (Git), and software development best practices.

Responsibilities

• Design, develop, and maintain scalable data pipelines, data models, and integration processes using modern cloud-based technologies (AWS, Snowflake, etc.)
• Analyze complex data sets and technical problems to design effective, flexible, and innovative solutions that meet business needs
• Collaborate closely with Product Owners, business stakeholders, and cross-functional teams to translate business requirements into technical data solutions
• Build and support ETL/ELT pipelines for structured and unstructured data from internal and external sources, including APIs, flat files, and enterprise applications
• Implement data quality checks, validation rules, reconciliations, exception handling, and monitoring to ensure data integrity
• Develop automated tests across multiple scopes (Unit, System, Integration, Regression) to ensure reliability and accuracy of data solutions
• Perform data profiling, root cause analysis, and troubleshooting of data issues across production and non-production environments
• Document data flows, data dictionaries, and technical specifications to support data governance and knowledge sharing
• Identify and recommend continuous improvement opportunities across data engineering processes and tooling
• Collaborate with engineers and architects, and actively contribute to code reviews and engineering best practices
• Leverage AI-assisted development tools like GitHub Copilot
• Actively uses AI tools to improve the speed, quality, and scale of work; can point to concrete workflows where AI adds value; evaluates AI output critically and protects confidential data.

Skills

SQL proficiency

Cloud data platforms

Snowflake

AWS

Data modeling

Data analytics

Agile mindset

Git

Education

Bachelor's degree

Tools

IDMC

Git

Job description

Liberty Mutual Insurance is seeking a Senior Data Engineer to join the Data and Analytics Engineering team in the PL Product/Finance and Vendor Extract space. The role combines data engineering with business analysis, delivering scalable data pipelines and models.

You will collaborate with product owners, stakeholders, and cross-functional teams to translate requirements into technical data solutions, ensuring data quality and governance.