Overview
On Site
$60 - $90
Contract - W2
Contract - 12 Month(s)
Skills
capital market
Fixed income
Job Details
Hi,
Hope you are doing well
Role: Data Modeler
Location: Atlanta, GA or Charlotte, NC
Duration: (Contract for 12 months) but extendible every 6 months, long term need
W2 only
1. 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.
2. Creates the implementation Logical data model and implementation Physical data model and provides the Data Definition Language (DDL) to the DBAs for implementation into the database management system (DBMS).
3. Maintains models in the Enterprise Data Model Repository which hosts most of Truist's models for both in- house and certain vendor databases.
4. Own, maintain and enforce data modeling standards, policies, and procedures in order to ensure consistency between artifacts and designs and promote re-use.
5. Works closely with the Metadata Team in order to publish model information to the Metadata Hub including diagrams, business definitions, etc. Reverse engineers production databases including vendor into data models for Metadata, Application, and DBA information/documentation.
6. Serves as a communication conduit 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 Truist Naming Standards.
7. Generates model Data Dictionary and assist BAs with Data Mapping. Applies several DDL customizations based on the DBMS technology and DB specifics. Adjusts data structures to optimize for performance and access. Manage the licensing, support, and vendor relationship for the ERwin Data Modeler Suite. Recommends changes to existing policies and procedures. Implements process improvements.
8. 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.
9. Design and development of data models (logical/physical) leveraging Golden Source data model
10. Experience working with data modeling tools like Erwin to create ER diagrams
11. Define data structures, schemas and tables
12. Experience with Snowflake
2. Creates the implementation Logical data model and implementation Physical data model and provides the Data Definition Language (DDL) to the DBAs for implementation into the database management system (DBMS).
3. Maintains models in the Enterprise Data Model Repository which hosts most of Truist's models for both in- house and certain vendor databases.
4. Own, maintain and enforce data modeling standards, policies, and procedures in order to ensure consistency between artifacts and designs and promote re-use.
5. Works closely with the Metadata Team in order to publish model information to the Metadata Hub including diagrams, business definitions, etc. Reverse engineers production databases including vendor into data models for Metadata, Application, and DBA information/documentation.
6. Serves as a communication conduit 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 Truist Naming Standards.
7. Generates model Data Dictionary and assist BAs with Data Mapping. Applies several DDL customizations based on the DBMS technology and DB specifics. Adjusts data structures to optimize for performance and access. Manage the licensing, support, and vendor relationship for the ERwin Data Modeler Suite. Recommends changes to existing policies and procedures. Implements process improvements.
8. 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.
9. Design and development of data models (logical/physical) leveraging Golden Source data model
10. Experience working with data modeling tools like Erwin to create ER diagrams
11. Define data structures, schemas and tables
12. Experience with Snowflake
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.