Senior Data Engineer
Job Description
Liberty Mutual is seeking a Senior Data Engineer to join the Data and Analytics Engineering team (Frontier and PL Distribution). This hybrid role requires two in office days per week, with options in Boston, Portsmouth (NH), or Indianapolis, and offers a salary range of USD 106,000 to 197,000 per year.
Responsibilities
- Design, implement, and maintain scalable data pipelines, data models, and integration workflows using cloud-native technologies such as AWS and Snowflake
- Analyze complex data sets and technical challenges to craft robust, flexible solutions aligned with business needs
- Partner with Product Owners, stakeholders, and cross-functional teams to translate business requirements into technical data solutions
- Build and support ETL and ELT processes 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 unit, system, integration, and regression scopes to ensure reliability and accuracy
- Profile data, perform root cause analysis, and troubleshoot data issues in production and non-production environments
- Document data flows, data dictionaries, and technical specifications to support data governance and knowledge sharing
- Identify opportunities for continuous improvement across data engineering processes and tooling
- Collaborate with engineers and architects, contribute to code reviews, and promote engineering best practices
- Leverage AI assisted development tools like GitHub Copilot
Requirements
- Bachelor’s degree in computer science, engineering, information systems, or a related technical or business discipline (or equivalent experience)
- 5 to 6 years of experience in data engineering, data analytics, or a related technical role
- Strong SQL skills, including writing complex queries, data modeling, and working with relational and analytical databases
- Familiarity with cloud based data platforms and tools such as Snowflake and AWS or similar technologies
- Strong analytical and problem solving abilities with the capacity to translate data into actionable insights
- Proven ability to operate in an agile, squad based environment with cross functional teams
- Proactive, self motivated, and detail oriented with solid critical thinking
- Excellent written and verbal communication skills, able to convey technical concepts to 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
Technologies
- AWS
- Snowflake
- IDMC
- Git
- GitHub Copilot
- CI/CD pipelines
Preferred
- Understanding of Cloud and hybrid data architecture concepts
- Exposure to data governance, data quality frameworks, or master data management concepts
- Experience in the insurance or financial services industry
- Guidewire experience a plus