Data Modeler/ Data Architect

Role: Data Modeler or Data Architect Location: Irving, TX (Hybrid or On Site, based on role needs)   Duration: 6 months C2H 
Description:
Job Summary:
We are seeking an experienced Data Modeler to join our data architecture team. The successful candidate will be responsible for designing, implementing, and maintaining data models for our diverse database environments, which include both Oracle (relational) and MongoDB (NoSQL) platforms. This role is crucial for ensuring that our data assets are well-structured, optimized for performance, and aligned with business requirements. You will work closely with business analysts, application developers, and database administrators to translate complex business needs into effective and scalable data models.
 Key Responsibilities Data Modeling and Design:
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.
 Collaboration and Strategy:
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.
 Maintenance and Optimization:
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.
 Required Qualifications               
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, 
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.                                                
 Preferred Skills                 
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.