Data Modeler

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.

Contract Duration: 6 Months

Required Skills & Experience

• 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.

What You Will Be Doing

• 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.