Data Engineer

Description
Join USRM Data Analytics & Engineering at Liberty Mutual as a Data Engineer. You'll build and operate cloud data platforms that deliver premium, loss, and exposure data used for regulatory reporting, actuarial models, and business decisions. You'll work on a distributed Agile team and use Snowflake, Informatica IDMC, SQL, Python, AWS, and modern DevOps and AI-assisted tooling.
**This is a hybrid role requiring two days in the office a week in one of the following locations: Boston, Portsmouth, Plano, Indianapolis, or Columbus**
** You must be authorized to work in the United States without employer sponsorship now or in the future. We will not sponsor employment visas. Candidates who will require future sponsorship, including candidates on CPT/OPT/STEMOPT who will require future sponsorship, are not eligible to apply. **
Under general supervision, responsible for the analysis, development, and execution of data solutions of moderate complexity to manage the information lifecycle needs of an organization. Collects, integrates and analyzes organizational data with the purpose of drawing conclusions from that information. Develops, constructs, tests, and maintains data architectures for data platforms, database, analytical/reporting, or data science systems. Establishes and builds data systems including providing standards, policies, practice, procedures, governance and quality assurance for data deliverables. Recommends methods to improve data reliability, quality, and efficiency.
Responsibilities
Design and develop low to moderately complex programs and tools to support ingestion, curation and provisioning of enterprise data to achieve analytics or reporting. Builds and designs data models and data architecture of low to moderate complexity that improve accessibility, efficiency, governance and quality of data. Make recommendations for how to improve data. Provides successful deployment and provisioning of data solutions to production or other required environments. Identify possible process improvements that address technology gaps within a single business process of moderate complexity. Builds proficient knowledge of technology enablers. Analyzes and prepare moderate to complex technology enabled recommendations to address gaps within a single business process. Performs other duties and projects assigned.
Key Responsibilities:

• Design, develop, and maintain ETL/ELT pipelines using Snowflake and Informatica IDMC.
• Build and optimize data models, views, and tables for analytics and reporting.
• Write, review, and optimize SQL and Python for data processing and integrations.
• Manage data storage and movement using AWS (S3 and related services).
• Implement automated testing (unit, integration, regression) for pipelines and support test tooling.
• Improve CI/CD, deployment automation, orchestration (e.g., Control-M) and monitor data workflows.
• Troubleshoot data issues, perform RCA, and implement long-term fixes.
• Produce technical documentation, data lineage, and support data governance and quality initiatives.
• Participate in sprint planning, code reviews, and mentoring of junior engineers.

Qualifications

• Bachelor's or Master's degree in a technical or business field, or equivalent experience.
• Generally 3 years of professional experience building data pipelines or data platforms.
• Hands-on experience with Snowflake and Informatica IDMC or similar ETL/ELT tools.
• Strong SQL skills and experience with Python.
• Practical experience with AWS data services (S3, Glue, etc.).
• Experience with automated testing, CI/CD, and data pipeline orchestration (e.g., Control - M, Airflow).
• Experience working on Agile teams and collaborating with analytics/business stakeholders.

Preferred:

• Experience designing cloud or hybrid data architectures and data modeling for analytics.
• Background in data warehousing, reporting, or regulatory reporting (insurance domain helpful).
• Experience with mainframe data sources or legacy ingestion (a plus).
• Familiarity or interest in AI-assisted development tools and observability platforms.
• Experience mentoring others or owning end-to-end features in production.

Working at Liberty Mutual Liberty Mutual is a Fortune 100 company focused on customer-centered digital transformation. You'll join distributed, Agile teams that balance delivery with learning and career growth. The company offers competitive compensation and benefits packages, including health and retirement plans, paid time off, and learning and development programs. Expect opportunities for cross-team collaboration, exposure to enterprise-scale data challenges, and support for professional development and mobility.
If this aligns with your experience and goals, I'd like to discuss how you can contribute to the team.
About Us
Pay Philosophy: The typical starting salary range for this role is determined by a number of factors including skills, experience, education, certifications and location. The full salary range for this role reflects the competitive labor market value for all employees in these positions across the national market and provides an opportunity to progress as employees grow and develop within the role. Some roles at Liberty Mutual have a corresponding compensation plan which may include commission and/or bonus earnings at rates that vary based on multiple factors set forth in the compensation plan for the role.
At Liberty Mutual, our goal is to create a workplace where everyone feels valued, supported, and can thrive. We build an environment that welcomes a wide range of perspectives and experiences, with inclusion embedded in every aspect of our culture and reflected in everyday interactions. This comes to life through comprehensive benefits, workplace flexibility, professional development opportunities, and a host of opportunities provided through our Employee Resource Groups. Each employee plays a role in creating our inclusive culture, which supports every individual to do their best work. Together, we cultivate a community where everyone can make a meaningful impact for our business, our customers, and the communities we serve.
We value your hard work, integrity and commitment to make things better, and we put people first by offering you benefits that support your life and well-being. To learn more about our benefit offerings please visit: https://LMI.co/Benefits
Liberty Mutual is an equal opportunity employer. We will not tolerate discrimination on the basis of race, color, national origin, sex, sexual orientation, gender identity, religion, age, disability, veteran's status, pregnancy, genetic information or on any basis prohibited by federal, state or local law.
Fair Chance Notices

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

USD $83000.00 - $154000.00