Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Senior Data Modeler (972 views)

September 8, 2020

** Direct Client Requirement *****

Title: Senior Data Modeler

Location: Dover, NH

Rate: DOE/If your experience and skills match call us immediately for submission

Duration:Long term

Interview Type: Skype and Phone

Work Status: Successful applicants must be legally authorized to work in the U.S.

Job Type: W2

Preffer W2: U S C/G C/H1B Transfer/OPT/CPT/H4 EAD and other US work authorization are accepted

Job Description

I am looking for a SENIOR Data Modeler that must have experience with ACORD (looking for insurance (not healthcare) experience.
Senior Data Modeler for Data Warehouse
The Data Analytics and Engineering (DAE) organization of Liberty Mutual Global Retail Marketing is expanding its data modeling team. DAE Data Modelers design analytical databases that translate complex business data into usable computer systems. Data Modelers work with data architects to design databases and data structures that meet organizational needs using conceptual, logical, and physical data models. Their models are designed to improve efficiency and business value and may focus on issues such as reducing data redundancy, improving data quality or improving data movement across systems.
An ideal DAE Data Modeler is an analytical and creative thinker who is not intimidated by roadblocks and challenges. They understand how to successfully evaluate problems and develop appropriate solutions. Data Modelers perform well under pressure, possessing great focus while completing projects efficiently. They should be able to work well as part of a team, but also carry responsibility for their own work. Data Modelers also need to be able to work on multiple projects at a time, with the ability to quickly understand and incorporate new technologies. Below are the skills and abilities that DAE will look for in a Data Modeler.
What you will do:
•             Work with the Data Office, DAE and Application Development teams to translate business needs into data models
•             Create and Maintain Conceptual, Logical and Physical Data Models
•             Participate in Data Governance procedures and policy management
•             Mentor, contribute and govern Data Management standards and best practices
What you will need:
•             Bachelor’s degree in Computer Science or similar
•             5+ years experience translating Business rules into Conceptual, Logical & Physical data models for a data lake and data warehouse
•             5+ years experience with modeling tools such as Erwin or ER/Studio
•             Prior experience with Data Warehouse modeling techniques using Data Vault 2.0
•             2+ years experience with Snowflake
•             3+ years experience with cloud-based Data Warehouse and Data Lake environments
•             Software Development experience with SQL
•             Experience in converting relational data models to semi-structured data (XML, JSON) or vice versa
•             Must be able to work independently and collaboratively on large scale data projects
Experience in these areas is a Plus:
•             Experience in the insurance industry
•             Experience with industry standard data models such as ACORD is a must have
•             Experience with ETL tools such as Informatica or Snaplogic
•             Exposure to Business Intelligence tools (PowerBI, MicroStrategy)
•             Experience with MDM solutions
•             Exposure with messaging solution like Kafka and MQ

Position Keywords: Data modeler,warehouse,Erwin or ER/Studio,MDM,kafka,snowflake

Pay Rate: DOE

Job Duration: long term

% Travel Required: None

Job Posted by: Employer

Job ID: OOJ - 2284

Work Authorization: Successful applicants must be legally authorized to work in the U.S

Don't have time now?
Get a reminder in your inbox