Senior Data Engineer

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 #J-18808-Ljbffr