Senior Data Modeler

Overview

Hybrid
$70 - $75
Contract - W2
Contract - 12 Month(s)

Skills

Data Model
Data definition Language
Erwin
Meta Data
Physical Logical data Model

Job Details

Immediate need for a talented Senior Data Modeler. This is a 12+months contract opportunity with long-term potential and is located in Atlanta, GA (Hybrid). Please review the job description below and contact me ASAP if you are interested.

Job ID: 25-69262

Pay Range: $70 - $75/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

  • Supports Work streams in their data design needs ranging from Operational databases to Analytical Data Marts and Warehouses.
  • Gathers and analyzes data and business requirements and translates them into a data model.
  • Creates the implementation Logical data model and implementation of Physical data model and provides the Data Definition Language (DDL) to the DBAs for implementation into the database management system (DBMS).
  • Maintains models in the Enterprise Data Model Repository which hosts most of Client s models for both in- house and certain vendor databases.
  • Own, maintain and enforce data modeling standards, policies, and procedures to ensure consistency between artifacts and designs and promote re-use.
  • Works closely with the Metadata Team to publish model information to Metadata Hub including diagrams, business definitions, etc.
  • Reverse engineers production databases including vendor into data models for Metadata, Application, and DBA information/documentation.
  • Serves as communication conduct between the business and the developers by providing information as to what data is available, where it is located and how to access it, along with definitions of what it means.
  • Applies table and column abbreviations from the Client Naming Standards.
  • Generates model Data Dictionary and assist Client with Data Mapping.
  • Apply several DDL customizations based on DBMS technology and DB specifics.
  • Adjusts data structures to optimize performance and access.
  • Manage the licensing, support, and vendor relationship for the Erwin Data Modeler Suite.
  • Recommend changes to existing policies and procedures. Implements process improvements.
  • Leads complex projects with moderate resource requirements and risk. Interprets internal/external business challenges and recommends best practices.
  • Uses sophisticated analytical thought to exercise judgment and identify innovative solutions.
  • Mentors less experienced teammates to build technical expertise.
  • May have people management responsibilities.
  • Design and development of data models (logical/physical) leveraging Golden Source data model
  • Define data structures, schemas and tables

Key Requirements and Technology Experience:

  • Key Skills; Data Model, Data definition Language ,Erwin ,Meta Data, Physical Logical data Model
  • Experience working with data modeling tools like Erwin to create ER diagrams
  • Experience with Client
  • At least 10 years of data modeling experience

Our client is a leading Banking Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy .

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.