Senior Cloud Data Engineer, Investments Tech (SQL/AWS/Snowflake)

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.
Description
Are you looking for a chance to be part of a high performing team that is passionate about data? Are you intrigued by Investments and Finance? Does the thought of building a modern cloud-based data platform from the ground up excite you? If yes, then j oin us and be part of a team that's forging the path to data-driven success.
At Liberty Mutual Investments (LMI), we manage a high-quality investment portfolio utilizing a disciplined strategy. We have a large and varied customer base, supported by strategic business units that function as a complete investment firm within our Fortune 100 Company. Our investment professionals are critical to our ability to keep our promises to policyholders, claimants, and their families. We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.
Note: This role has a hybrid work arrangement (2 days/week in Boston, MA)
Job Description:
At Liberty Mutual Investments Technology , we are seeking a highly skilled Sr. Data Engineer to join our dynamic team. As a Sr. Data Engineer in our Data Engineering Chapter, you will play a pivotal role in shaping the future of data analysis while thriving in a fast-paced environment that encourages personal growth and development.
Key Responsibilities:

• Demonstrate expertise in SQL as part of our Data and Analytics squad. Design, develop, and enhance data and analytics solutions and pipelines, driving data-driven decision-making processes.
• Collaborate with scrum masters, product owners, and engineering teams to iteratively create data and analytics solutions that meet both business and technical requirements.
• Work closely with development team in building Innovative, cloud native solutions using SQL, AWS, Snowflake, Python, Rest API etc.
• Continuously enhance full delivery pipeline through automation, expanded yet increasingly efficient test coverage, ultimately optimizing time-to-market and overall quality
• Optimize and fine-tune existing data pipelines for performance, scalability, and reliability.
• Implement data quality checks and monitoring processes to ensure data accuracy and consistency.
• Stay current with industry trends and best practices in data engineering and recommend improvements to existing processes.
• Mentor junior engineers in the team; collaborate in technical documentation; participate in code reviews and adhering to engineering excellence/best practices.

Qualifications

• Proficient in SQL and hands on experience with Python
• Experience with Data modeling and data warehousing
• Experience with public cloud data platforms: Snowflake (preferable), AWS, Azure
• Proficiency with AWS Services including but not limited to AWS S3, AWS Glue, AWS Lambda, AWS EC2
• Proficient with ETL/ELT data pipelines, patterns for loading Data Warehouses, Lakes
• Experience with build/deploy automation & DevOps frameworks (CI/CD, Bamboo, GitHub Actions, pipeline-as-code)
• A design thinking and test-driven development mindset
• Experience with business intelligence tools and reporting solutions (Power BI, Tableau etc.).
• A bachelor's degree in a technical or business discipline, or equivalent experience
• 5+ years of related data engineering experience with focus on designing and building data pipelines.

Bonus Skills:

• Previous experience in Investments / Asset Management, Finance Data modeling, is highly desirable.
• Familiarity in building and consuming APIs (REST, API Gateway, etc.)
• Cognizance of security concerns, from access control and authentication to secured processes.
• Knowledge of containerization and orchestration tools (e.g.: Docker, Kubernetes)
• A comprehensive understanding of agile environments and the ability to adapt to rapidly changing circumstances.

About Us
As a purpose-driven organization, Liberty Mutual is committed to fostering an environment where employees from all backgrounds can build long and meaningful careers. Through strong relationships, comprehensive benefits and continuous learning opportunities, we seek to create an environment where employees can succeed, both professionally and personally.
At Liberty Mutual, we believe progress happens when people feel secure. By providing protection for the unexpected and delivering it with care, we help people embrace today and confidently pursue tomorrow.
We are proud to support a diverse, equitable and inclusive workplace, where all employees feel a sense of community, belonging and can do their best work. Our seven Employee Resource Groups (ERGs) offer a centralized, open space to bring employees and allies together to connect, learn and engage.
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 $112000.00 - $194000.00