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.
Want more jobs like this?
Get jobs in Columbus, OH delivered to your inbox every week.
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.
- 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.
- 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.
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
Perks and Benefits
Health and Wellness
- Long-Term Disability
- FSA
- HSA With Employer Contribution
- HSA
- Health Insurance
- Dental Insurance
- Vision Insurance
- Life Insurance
- Short-Term Disability
- Mental Health Benefits
Parental Benefits
- Birth Parent or Maternity Leave
- Non-Birth Parent or Paternity Leave
- Fertility Benefits
- Adoption Assistance Program
- Family Support Resources
- Adoption Leave
Work Flexibility
- Flexible Work Hours
- Remote Work Opportunities
- Hybrid Work Opportunities
Office Life and Perks
- Happy Hours
- Snacks
- On-Site Cafeteria
- Casual Dress
- Holiday Events
Vacation and Time Off
- Personal/Sick Days
- Paid Holidays
- Paid Vacation
- Volunteer Time Off
- Leave of Absence
Financial and Retirement
- Performance Bonus
- 401(K) With Company Matching
- Financial Counseling
Professional Development
- Mentor Program
- Promote From Within
- Learning and Development Stipend
- Tuition Reimbursement
- Internship Program
- Associate or Rotational Training Program
- Access to Online Courses
- Lunch and Learns
- Shadowing Opportunities
Diversity and Inclusion
Company Videos
Hear directly from employees about what it is like to work at Liberty Mutual Insurance.