Senior Data Engineer / Data Modeler
Company | Liberty Mutual |
---|---|
Location | Boston, MA, USA, Indianapolis, IN, USA, Plano, TX, USA, Portsmouth, NH, USA, Columbus, OH, USA |
Salary | $Not Provided – $Not Provided |
Type | Full-Time |
Degrees | Bachelor’s, Master’s |
Experience Level | Senior |
Requirements
- 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).
- Experience working with AWS preferred.
- Experience deploying DDL within Amazon AWS (Redshift, Aurora, Snowflake) preferred.
- Experience building ETL pipelines preferred.
- 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.
Responsibilities
- 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.
Preferred Qualifications
- Extensive experience developing DDL for cloud platforms (Amazon Redshift, Amazon Aurora, Snowflake) preferred.
- Experience working with AWS preferred.
- Experience building ETL pipelines preferred.
- Experience with insurance industry preferred.