Senior Data Modeler - Oracle & MongoDB

KELLY'S, INC.
Fort Worth, United States of America
22 days ago

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Fort Worth, United States of America

Tech stack

Cloud Database
Information Systems
Databases
Data Architecture
Data Dictionary
Data Governance
Data Integration
Data Structures
Data Warehousing
Relational Databases
Database Design
Dimensional Modeling
Document-Oriented Databases
MongoDB
Online Analytical Processing
NoSQL
Oracle
Oracle Applications
Lucidchart
Reverse Engineering
Information Technology
Physical Data Models
Oracle Cloud Infrastructure

Job description

Grow your career as a Data Modeler with an innovative global bank in Irving, TX. Contract role with strong possibility of extension and/or conversion. Will require working a hybrid schedule 3 days onsite per week. Not open to third party employment or sponsorship

Join one of the world's most renowned global banks and trusted brand with over 200 years of continuously evolving financial services worldwide. Will be responsible for designing, implementing, and maintaining data models for our diverse database environments, which include both Oracle (relational) and MongoDB (NoSQL) platforms. You will work alongside some of the smartest minds in the industry who are excited to share their knowledge and to learn from you., * Analyze and translate business requirements into conceptual, logical, and physical data models for both Oracle and MongoDB environments.

  • Develop and maintain relational data models (ERDs) for our Oracle databases, including defining tables, keys, relationships, and constraints.
  • Design and document flexible, scalable document-based data models for our MongoDB collections, focusing on optimal structure for application access patterns.
  • Create and manage the data dictionary and metadata for all models to ensure clarity and consistency.
  • Collaborate with business stakeholders and analysts to understand and document data requirements.
  • Work with development teams to ensure they correctly implement and utilize the data models.
  • Partner with DBAs to optimize data models for performance, scalability, and security.
  • Establish and enforce data modeling standards, best practices, and guidelines across the organization.
  • Reverse engineer data models from existing databases to document and understand current data structures.
  • Evaluate and recommend new data modeling tools and techniques.
  • Support data integration and migration efforts by providing clear data mappings and transformation logic.
  • Continuously review and refactor data models to adapt to changing business needs and improve efficiency.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • Proven experience as a Data Modeler or Data Architect.
  • Strong expertise in relational data modeling for enterprise-level systems, preferably in an Oracle environment.
  • Demonstrable experience in NoSQL data modeling, specifically for document databases like MongoDB.
  • Proficiency with industry-standard data modeling tools (e.g., Erwin, ER/Studio, Sparx EA, Lucidchart).
  • A deep understanding of the fundamental differences between relational and NoSQL database design principles.
  • Excellent analytical and problem-solving skills.
  • Strong communication and interpersonal skills, with the ability to explain complex technical concepts to both technical and non-technical audiences.

Desired Skills & Experience

  • Experience in the financial services or banking industry.
  • Knowledge of data warehousing concepts, dimensional modeling, and OLAP.
  • Familiarity with data governance, data quality, and master data management (MDM) principles.
  • Experience with cloud database platforms (e.g., Oracle Cloud, MongoDB Atlas).
  • Understanding of Agile/Scrum development methodologies.

Apply for this position