Senior Data Engineer

Liberty Mutual’s Data and Analytics Engineering team is hiring a Senior Data Engineer to design and deliver data solutions in the Frontier and PL Distribution space. This is a U.S.-based hybrid role based in Boston, MA, with an expected 2 days in the office per week in Boston, Portsmouth, or Indianapolis. You’ll work within an agile, squad-based environment to support a broader IT transformation by translating business needs into reliable, governed data products.

What you’ll do

• Design, develop, and maintain scalable data pipelines, data models, and integration processes using modern cloud technologies such as AWS and Snowflake.
• Analyze complex datasets and technical problems to create solutions that are flexible, innovative, and aligned with business priorities.
• Collaborate with Product Owners, business stakeholders, and cross-functional partners to turn requirements into technical data solutions.
• Build and support ETL/ELT pipelines for both structured and unstructured data from sources including APIs, flat files, and enterprise applications.
• Implement data quality checks such as validation rules, reconciliations, exception handling, and monitoring to help ensure data integrity.
• Create automated tests across multiple scopes, including Unit, System, Integration, and Regression, to support reliability and accuracy.
• Perform data profiling, root cause analysis, and troubleshooting for 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.
• Contribute to code reviews and engineering best practices while partnering with engineers and architects.
• Use AI-assisted development tools such as GitHub Copilot to support development workflows.

Qualifications

• Bachelor’s degree in computer science, Engineering, Information Systems, or a related technical or business discipline (or equivalent experience).
• 5-6 years of experience in data engineering, data analytics, or a related technical role.
• Strong proficiency in SQL, including writing complex queries and performing data modeling with relational and analytical databases.
• Familiarity with cloud-based data platforms and tools such as Snowflake, AWS, or similar technologies.
• Strong analytical and problem-solving skills, including the ability to interpret and communicate data-driven insights.
• Experience working in an agile, squad-based environment with cross-functional teams.
• Proactive, self-motivated approach with strong logical thinking and attention to detail.
• Excellent written and verbal communication skills for clearly conveying technical concepts to non-technical stakeholders.
• Experience with data integration and ETL/ELT tools such as IDMC.
• Familiarity with CI/CD pipelines, Git, and software development best practices.

Tools and technologies

• AWS
• Snowflake
• SQL
• GitHub Copilot
• IDMC
• Git

Preferred qualifications

• Understanding of cloud or 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.

Salary: USD 106,000 to 197,000 per year. This role operates as an agile team within a Fortune 100 company, partnering with business stakeholders, data scientists, and engineering peers to design and deliver high-quality data solutions.