Senior Data Engineer

Liberty Mutual; Indianapolis (IN); Hybrid; USD 130,000 - 180,000; Full time

Benefits offered by this job

Comprehensive benefits package

Flexible work arrangements

Professional development opportunities

Access to Employee Resource Groups

Job summary

Liberty Mutual, based in Indianapolis, is seeking a Senior Data Engineer to design and build scalable data pipelines in a cloud environment. The role requires 5–6 years of data engineering experience and strong SQL, data modeling, and AWS/Snowflake skills.

The position is hybrid, with 2 days in the office per week in Boston, Portsmouth, or Indianapolis, and includes opportunities to work with ETL/ELT, IDMC, and GitHub Copilot in a collaborative squad setting.

Qualifications

• Bachelor's degree or equivalent experience in a technical or business discipline.
• 5–6 years of experience in data engineering, analytics, or related technical role.
• Strong SQL skills with complex queries and data modeling.
• Experience with cloud-based data platforms and tools (e.g., Snowflake, AWS).
• Analytical, problem-solving skills and ability to communicate insights.
• Experience in agile, squad-based environments with cross-functional teams.
• Proactive, detail-oriented, and able to convey technical concepts to non-technical stakeholders.
• Experience with data integration/ETL/ELT tools such as IDMC; familiarity with CI/CD and Git.

Responsibilities

• Design, develop, and maintain scalable data pipelines, data models, and integration layers using cloud technologies (AWS, Snowflake).
• Analyze complex data sets and craft robust, adaptable solutions aligned with business needs.
• Collaborate with Product Owners and stakeholders to translate requirements into data capabilities.
• Build and support ETL/ELT processes from internal and external sources (APIs, flat files, enterprise apps).
• Implement data quality controls, validation logic, and monitoring to ensure data accuracy.
• Create automated tests across unit, system, integration, and regression scopes.
• Document data flows, dictionaries, and technical specs to support governance.
• Identify opportunities for continuous improvement in data engineering processes and tooling.
• Participate in code reviews and engineering best practices; leverage AI tools (GitHub Copilot).

Skills

SQL

Data modeling

AWS

Snowflake

IDMC

Git

CI/CD

GitHub Copilot

ETL/ELT

Agile

Education

Bachelor's degree in Computer Science, Engineering, Information Systems, or related field

Tools

Snowflake

AWS

IDMC

Git

GitHub Copilot

Job description

Senior Data Engineer at Liberty Mutual in Indianapolis, IN (hybrid, U.S.-based) responsible for designing and building scalable data pipelines and data solutions in a cloud-based environment within the Frontier and PL Distribution space, with 2 days in the office per week in Boston, Portsmouth, or Indianapolis.

Responsibilities

• Design, develop, and maintain scalable data pipelines, data models, and integration layers using modern cloud technologies (AWS, Snowflake, etc.)
• Analyze complex data sets and technical challenges to craft robust, adaptable solutions that align with business needs
• Partner with Product Owners, business stakeholders, and cross-functional teams to translate requirements into concrete data capabilities
• 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 controls, validation logic, reconciliations, exception handling, and monitoring to ensure data accuracy
• Create automated tests across unit, system, integration, and regression scopes to verify data solution reliability
• Conduct data profiling, root cause analysis, and issue resolution across production and non-production environments
• Document data flows, data dictionaries, and technical specifications to support governance and knowledge sharing
• Identify opportunities for continuous improvement in 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 SQL skills, including writing complex queries, data modeling, and work with relational and analytical databases
• Experience with cloud based data platforms and tools such as Snowflake and AWS or similar technologies
• Solid analytical and problem solving abilities with the ability to interpret and communicate data driven insights
• Proven ability to work in an agile, squad based environment with cross-functional teams
• Proactive, self-motivated, and detail oriented thinker
• 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
• GitHub Copilot
• Git

Benefits

• Comprehensive benefits package
• Flexible work arrangements
• Professional development opportunities
• Access to Employee Resource Groups

Fair Chance Notices

• California
• Los Angeles Incorporated
• Los Angeles Unincorporated
• Philadelphia
• San Francisco