Data Modeler

Mindlance; Atlanta (GA); On-site; USD 125,000 - 150,000; Full time

Job summary

An established industry player is seeking a skilled Data Modeler to join their team in Atlanta. This role involves utilizing advanced data modeling techniques to support critical projects within the financial services sector. You will be responsible for creating logical and physical data models, ensuring data integrity, and optimizing data structures for performance. The ideal candidate will have over a decade of experience in data modeling, proficiency with tools like Erwin and Snowflake, and a passion for data-driven solutions. Join a dynamic team where your expertise will drive impactful results and foster innovation in data management.

Qualifications

• 10+ years of experience in data modeling and database management.
• Proficient in using Erwin and Snowflake for data modeling tasks.

Responsibilities

• Support data design needs for operational databases and analytical data marts.
• Gather and analyze business requirements to create data models.

Skills

Data Modeling

Snowflake

Erwin Data Modeler

Analytical Skills

Database Management

Education

Bachelor's Degree

Tools

Erwin

Snowflake

Job description

Get AI-powered advice on this job and more exclusive features.

This range is provided by Mindlance. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$65.00/hr - $68.00/hr

Direct message the job poster from Mindlance

Note: this role is onsite at Atlanta, GA

Description:

Business Initiative/Purpose:

This project will perform data modeling for a critical Wholesale project utilizing the Golden Source data model and Snowflake.

Bachelor Degree: (Required, Preferred or Not Required) Preferred

Role 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 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 in order to ensure consistency between artifacts and designs and promote re-use.

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.

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.

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.

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.

Experience working with data modeling tools like Erwin to create ER diagrams.

Define data structures, schemas and tables.

Experience with Snowflake.

Must Have Skills/Prior Experiences: (Vendor should not submit any candidate that does not have these skills/prior experience.)

At least 10 years of data modeling experience.

EEO:

“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  Banking, Investment Banking, and Financial Services

Referrals increase your chances of interviewing at Mindlance by 2x

Sign in to set job alerts for “Data Modeler” roles.

Geospatial Information Systems (GIS) Data Specialist/Analyst (Remote)

Atlanta, GA $130,000.00-$155,000.00 2 weeks ago

Sr. Software Engineer- SAP ABAP (Open to Atlanta)

Atlanta, GA $99,500.00-$222,900.00 1 week ago

Atlanta, GA $112,597.33-$152,810.66 3 weeks ago

Atlanta, GA $112,597.33-$152,810.66 3 weeks ago

Atlanta, GA $116,480.00-$149,760.00 3 weeks ago

Atlanta, GA $116,480.00-$149,760.00 3 weeks ago

Atlanta, GA $116,480.00-$149,760.00 3 weeks ago

Data Analyst - Inventory Planning and Replenishment

Atlanta, GA $63,093.33-$85,626.66 3 weeks ago

Atlanta, GA $106,773.33-$144,906.66 3 weeks ago

Atlanta, GA $106,773.33-$144,906.66 3 weeks ago

Atlanta, GA $144,768.00-$209,109.33 3 weeks ago

Data Engineer (Profiles Only From Atlanta, GA)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.