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

Senior Data Modeler for Data Warehouse (891 views)

Dover, NH
May 19, 2020

***Direct Client Requirement ****

Title:Senior Data Modeler for Data Warehouse 

Location: Dover, NH

Duration:  Long term

Rate: DOE

Interview Type: Skype

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

Job Type: C2C,C2H ,W2

Experience: 8 YEARS

Job Description :

This is a year long contract for two Senior Data Modeler. After COVID, and when offices reopen the expectation would be for this person to come onsite in Dover.

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. 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+ year’s 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
• 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 Analytics,Data Modeler, Data Warehouse,Data Governance,Erwin or ER/Studio,nformatica, Snaplogic,Kafka and MQ

Pay Rate: DOE

Job Duration: long term

% Travel Required: None

Job Posted by: Employer


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