Senior Data Engineer

Description

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.

At Liberty, you'll thrive in a hybrid setting that fosters in-person collaboration, innovation and growth. This approach optimizes both remote and in-person interactions, enabling you to connect and ideate with your team and deepen valuable relationships across the company, while still enjoying the flexibility of remote work for focused tasks and projects.

This role has a hybrid work schedule (2 days onsite) and we are considering candidates based in Portsmouth, NH, Boston, MA, Plano, TX, Indianapolis, IN, Remote and Columbus, OH.

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.

Hiring Manager - Collin Shrake

Job Introduction:

The Data Solutions is a key team within the Global Finance Technology organization, supporting the flagship LII OneGL program. We are building complex data pipelines to extract data from numerous source systems, transform the data to meet business requirements, and prepare it for loading into the SAP FPSL platform. Collaborating closely with Product Owners and Business users, we iterate quickly to ensure accuracy and reliability as we move towards a Production launch. Looking ahead, Data Solutions will be on the front lines for integrating LII OneGL data into the organization's North Star Architecture, leveraging AWS, Snowflake, PostgreSQL, Power BI, Erwin for data modeling, and IDMC for data governance — all to unlock insights through analytics, generative AI, and more.

The team is looking to add a dynamic Senior Data Engineer to the Data Prep team. This candidate will play a key hands-on role writing SQL, developing stored procedures, designing transformations, and collaborating across the program. Key skillsets include strong SQL expertise, strong experience with stored procedures, Python, PostgreSQL, Snowflake, Amazon AWS, FCS, and Power BI. The ideal candidate is well-rounded in Data Engineering concepts, comfortable with cross-team collaboration, able to translate business requirements into effective data solutions, and fluidly leverages GenAI tools to boost efficiency for themselves and others on the team. 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.

There's never been a more exciting time to join the team. If you're eager to be part of a transformative program focused on data engineering and modern cloud technologies, consider joining us!

About the job:

- Collaborate 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 FCS 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 other database logic.

- Leverages data for analytics and reporting.

- Identifies and implement process improvements.

- Builds strong knowledge of technology and mentors others.

- Follows best practices for Production support.

- Make recommendations for how to improve data.

- Challenges status quo and is focused on continuous improvement.

- Leverages generative AI tools to work efficiently.

Qualifications

- Bachelor`s degree in technical or business discipline or equivalent experience

- Minimum 5+ years of Data Engineering experience.

- Knowledge of a variety of data platforms/tools such as Snowflake and IDMC.

- Experience with Python or Java, SQL, and AWS (S3, etc.) and AI technologies

- Extensive knowledge of IT concepts, strategies, methodologies.

- Experience working with agile methodologies and cross-functional teams (Product Owners, Scrum Masters, Developers, Test Engineers).

- Must be proactive, demonstrate initiative, and be a logical thinker.

- Must be team oriented with strong collaboration, communication, prioritization, and adaptability skills required.

Additional Qualifications:

- Excited by trying new technology and learning new tools.

- Understanding of Cloud / Hybrid data architecture concepts.

- Understanding of insurance industry products.

- Experience developing back end, database/warehouse technology solutions.

- Demonstrates leadership and active pursuit of optimizing CI/CD process and tools, testing frameworks and practices.

AI Fluency:

Actively uses AI tools to improve the speed, quality, and scale of work; can point to concrete workflows where AI adds value; critically evaluates and validates AI-generated output; and applies AI responsibly, protecting confidential and customer data.

Employees may apply for a new role after completing 12 months of employment in their current position.

Employees should review all role requirements and apply only for positions for which they are eligible. Hiring processes may vary by country, including differences in procedures, requirements, and timelines. For country-specific details, please consult your local recruiting / HR team.

## Travel
10%