Senior Data Engineer
Job Description
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