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

Senior Data Modeler with Snowflake or ACORD (1271 views)

Dover, NH
January 5, 2021

***** Direct Client Requirement*****                    

Title                          : Senior Data Modeler with Snowflake or ACORD

Location                   : Dover, NH

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

Duration                  : 6 Months

Interview Type       : Skype or In Person

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

Job Type                  : W2

Experience              : 5 years

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

We are looking for a Senior Data Modeler that has ACORD experince (comes from insurance industry) or has strong SNOWFLAKE background. 

This is a 3 to 5 month long contract for one Senior Data Modeler.
Remote currently, however, after COVID and when offices reopen the expectation would be for this person to come onsite in Dover.
Senior Data Modeler for Rational Rose to Erwin model translation
The Data Analytics and Engineering (DAE) organization of *** 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.
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 this Data Modeler position.
What you will do:
• Work with the Data Office, DAE and Application Development teams to translate an extensive existing DB2 model from Rational Rose (2003 version) to Erwin (current version)
• Assist with the generation and analysis of DDL generated by Rose and Erwin
• Participate in Data Governance procedures and policy management
What you will need:
• Bachelor’s degree in Computer Science or similar
• 5+ years experience developing Conceptual, Logical & Physical data models for a data lake and data warehouse
• 5+ years experience with modeling Rational Rose
• 5+ years experience with ERwin modeling (exposure to the version we are currently using: Erwin Data Modeler 2020 R2)
• Experience in reverse engineer databases
• Experience with using the bulk editor in ERwin
• Experience with DB2 z/OS
• Software Development experience with SQL
• 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 Snowflake and/or Data Vault
• Experience with industry standard data models such as ACORD
• Experience with ETL tools such as Informatica or Snaplogic
• Exposure with messaging solution like Kafka and MQ

Position Keywords: ACORD,Data Modeler,Erwin,DB2 z/OS,SQL,Kafka and MQ,Snaplogic

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

Job Duration: 6 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 2660

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