Senior Data Engineer

Senior Data Engineer designs and builds scalable data pipelines and cloud based data solutions within Liberty Mutual's Frontier and PL Distribution space, in a hybrid U.S. role based in Indianapolis with two in office days per week in Boston, Portsmouth, or Indianapolis, salary USD 106,000 - 197,000 per year.

Responsibilities

• Design, develop, and maintain scalable data pipelines, data models, and integration processes using cloud technologies such as AWS and Snowflake.
• Analyze complex data sets and technical problems to craft effective, flexible data solutions aligned with business needs.
• Collaborate 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.
• Create automated tests across unit, system, integration, and regression scopes to verify 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 opportunities for continuous improvement across data engineering processes and tooling, and recommend changes.
• Collaborate with engineers and architects, contribute to code reviews, and uphold 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.
• 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, able to clearly 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
• Workplace flexibility
• Professional development opportunities
• Employee Resource Groups opportunities

Fair Chance Notices

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