The Data Engineer will design and support ETL/ELT pipelines collaborate with teams to enhance data platforms and leverage analytics and governance tools.

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.
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:
Data Solutions is a key team within Global Finance Technology 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.
Data Solutions is looking to add a dynamic Senior Data Engineer to the Data Prep team. This candidate will fill 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 and able to translate business requirements into effective data solutions. 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:

• 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 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 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.

Qualifications

• Bachelor`s degree in technical or business discipline or equivalent experience.
• Minimum 3+ 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.

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