Senior Data Engineer

Liberty Mutual Insurance • Boston, MA

1d • Hybrid

About The Position

We deliver our customers peace of mind every day by helping them protect what they value most. Our passion for placing the customer at the center of everything we do is driving a transformational shift at Liberty Mutual. Operating as a tech startup within a Fortune 100 company, we are leading a digital disruption that will redefine how people experience insurance.
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.
This role has a hybrid work schedule (2 days onsite) and we are considering candidates based in Portsmouth, NH, Boston, MA, Plano, TX, Columbus, OH and Indianapolis, IN.
Job Introduction:
Finance Enablers is a key team within Global Finance Technology, supporting the GRS Finance space and the IT platform behind crucial processes such as financial book close and analytical reporting. We support multi-dimensional data cubes encompassing 9TB and 4.4 billion rows of data, and over 950 end users. Collaborating closely with Product Owners and Business users, we create solutions that make financial data accessible and insightful for decision-makers across the organization. As we embark on our journey toward the organization's North Star Architecture — a complete modernization of our platform leveraging AWS, Snowflake, PostgreSQL, Power BI, Erwin for data modeling, and IDMC for data governance — there's never been a more exciting time to join the team. If you're eager to be part of a transformative initiative that bridges a robust Microsoft-based platform with cutting-edge cloud technologies, consider joining Finance Enablers as we drive the next generation of financial data excellence!
The Finance Enablers team is looking to add a dynamic Senior Data Engineer to the team. This candidate will play a critical role in both maintaining and modernizing GRS financial data and integrating it with broader Liberty Mutual platforms. Key skillsets include strong SQL expertise, experience with multi-dimensional data and technologies such as SSAS, SSRS, and SQL Server, cross-team collaboration, and the ability to translate business requirements into effective data solutions. Experience with AWS is highly preferred, as the team will be transitioning to a modernized tech stack including Snowflake, PostgreSQL, Power BI, Python, Erwin, and IDMC. The ideal candidate is well-rounded in Data Engineering concepts and comfortable working with both Microsoft SSAS and modern AWS platforms. Responsibilities will include supporting and optimizing existing multi-dimensional data cubes, collaborating with Product Owners and Business users to design and deliver solutions, and contributing to the platform's modernization under the North Star Architecture initiative. We are seeking a team member who is self-motivated, willing to learn and upskill as needed, and has a willingness to accept peer review and mentor others.

Requirements

• Bachelor's or Master's degree in technical or business discipline or equivalent experience, technical degree preferred.
• Minimum 5+ years of data engineering experience.
• Extensive SQL experience (developing and optimizing complex queries).
• Extensive experience building data pipelines (ETL/ELT).
• Extensive experience with both relational (SQL Server, Postgres) and dimensional data (SSAS, Snowflake).
• Experience with relational and dimensional data modeling using industry standard methodologies and tools (Erwin, UML).
• Experience utilizing data governance (Informatica IDMC).
• Experience with cloud platforms (AWS preferred).
• Experience developing and deploying DDL.
• Experience building automation into data modeling and deployments.
• Must be proactive and self-driven, demonstrate initiative and be a logical thinker.
• Strong leadership, communication, collaboration skills with a track record of taking solution ownership.
• Excellent communication and collaboration skills.

Nice To Haves

• Experience working with financial data preferred.
• Experience with insurance industry preferred.

Responsibilities

• Collaborates with team, product owners, and business users to maintain and enhance a critical data platform used for both operational and analytical purposes.
• Designs, build, and support data ETL/ELT pipelines using tools such as SSIS and IDMC.
• Utilizes data modeling and governance to conceptualize and implement data transformations and integrations necessary to meet business needs.
• Supports programmatic elements within system, such as stored procedures and script logic.
• Leverages data for analytics and reporting.
• Identifies and implements process improvements.
• Builds strong knowledge of technology and mentors others.
• Follows best practices for Production support.
• Makes recommendations for how to improve data.
• Challenges status quo and is focused on continuous improvement.
• Leverages generative AI tools to work efficiently.

Benefits

• 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://www.libertymutualgroup.com/about-lm/careers/benefits

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 251-500 employees