Senior Data Modeler

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.
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:
The Byte Club is a key player within Global Finance Technology's Business Data Solutions Engineering Organization, where we leverage data modeling, governance, and modern AWS platforms to build innovative solutions and optimize financial insights. We're a small, Agile and dynamic group dedicated to transforming complex business requirements into flexible & performant database designs, creating a consolidated and modernized single source of global financial data. We strive to make data accessible and insightful for analytics and reporting, for decision-makers across the organization. If you're eager to dive deep into a variety of business units and understand the critical data they provide to finance, consider joining Byte Club as we harness the power of data to drive financial excellence!
Byte Club is looking to add a dynamic Senior Data Modeler / Data Engineer to their team. This candidate will help build the future of financial data at Liberty Mutual. Key skillsets include Data Modeling using Erwin, Data Governance using Informatica suite, SQL and ETL, cross-team collaboration, translating business requirements into appropriate data elements and definitions, and deploying data models within AWS. Responsibilities will include analysis of data and data elements in collaboration with data governance teams, implementing new elements and changes into existing data models, and integration with GitHub deployment pipeline. Seeking a team member who is self-motivated with and willing to learn and upskill as needed, and has a willingness to accept peer review and mentor others.
About the job:

• Designs and develops programs and tools to support ingestion, curation and provisioning of complex enterprise data to achieve analytics, reporting, and data science.
• Identifies process improvements that address complex technology gaps within a single business process.
• Builds strong knowledge of technology enablers.
• Analyzes and prepares complex technology enables recommendations to address gaps within a single business process.
• Provides successful deployment and provisioning of data solutions to production or other required environments.
• Designs and builds data provisioning workflows/pipelines, physical data schemas, extracts, data transformations, and data integrations and/or designs and builds data architecture and applications that enable reporting, analytics, data science, and data management and improve accessibility, efficiency, governance, processing, and quality of data.
• Makes recommendations for how to improve data.
• Applies machine learning concepts to work as applicable.

Qualifications

• Bachelor's or Master's degree in technical or business discipline or equivalent experience, technical degree preferred
• Minimum 5+ years of data engineering / data modeling experience
• Extensive data modeling experience using industry standard methodologies and tools (Erwin, UML)
• Extensive experience with both relational (Postgres) and dimensional data modeling (Snowflake, SSAS)
• Extensive experience developing DDL for cloud platforms (Amazon Redshift, Amazon Aurora, Snowflake) preferred
• Extensive experience utilizing data governance (Informatica IDMC)
• Significant experience leveraging SQL to manipulate data
• Experience building ETL pipelines
• Experience working with AWS (preferred) or other cloud platform
• Experience deploying DDL within Amazon AWS (preferred) or other cloud platform
• Experience building automation into data modeling and deployments
• Experience working with financial data
• Experience with insurance industry preferred
• 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.

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 $104000.00 - $194000.00