Senior Data Engineer

Senior Data Engineer at Liberty Mutual in Portsmouth, NH (hybrid), with a requirement to work 2 days per week in the office in Boston, Portsmouth, or Indianapolis, offering a salary range of USD 106,000 to 197,000 per year to design, build, and maintain scalable data pipelines and cloud-based data solutions.

Responsibilities

• Build and maintain scalable data pipelines, data models, and integration workflows using modern cloud platforms such as AWS and Snowflake
• Examine complex data sets and technical challenges to craft robust, flexible data solutions aligned with business needs
• Collaborate with Product Owners, business stakeholders, and cross-functional teams to translate requirements into technical data capabilities
• Develop and support ETL and 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
• Create automated tests across unit, system, integration, and regression scopes to ensure reliability and accuracy
• Conduct data profiling, root-cause analysis, and troubleshooting of 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, actively participating in code reviews and engineering best practices
• Leverage AI-assisted development tools such as 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 proficiency in SQL, including crafting 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
• Strong analytical and problem-solving skills with the ability to interpret and communicate data-driven insights
• Experience working in an agile, squad-based environment with cross-functional teams
• Proactive, self-motivated, and a logical thinker with strong attention to detail
• Excellent written and verbal communication skills, with the ability to explain 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

Technologies

• AWS
• Snowflake
• IDMC
• Git
• GitHub Copilot
• CI/CD pipelines

Preferred

• 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 is a plus
• Guidewire experience is a plus