Logical Data Modeler

5 Star Recruitment; Houston (TX); On-site; USD 85,000 - 115,000; Full time

Job summary

A recruitment agency is seeking a highly skilled Logical Data Modeler to join their Database Team in Houston, TX. The ideal candidate will have over 3 years of experience in data modeling and database design, with expertise in Oracle database technologies. Responsibilities include designing data models, collaborating with stakeholders, and supporting data integration and governance efforts. Candidates should possess strong analytical skills and proficiency in data modeling tools such as ERwin or ER/Studio. A bachelor's degree or technical certification is preferred.

Qualifications

• 3+ years of experience in data modeling, database design, or data architecture.
• Strong understanding of relational database concepts, normalization, and data integrity.
• Proficiency in data modeling tools such as ERwin or ER/Studio.

Responsibilities

• Design and maintain logical data models that reflect business requirements.
• Collaborate with stakeholders to gather and interpret data requirements.
• Translate business needs into normalized data structures.

Skills

Data modeling

Database design

Problem-solving

Communication

Education

Bachelor's degree or technical certification

Tools

ERwin

ER/Studio

Job description

Job Summary

We are seeking a highly skilled and detail-oriented Logical Data Modeler with expertise in Oracle database technologies to join our Database Team in Houston, TX. This role is pivotal in designing, developing, and maintaining logical data models that support enterprise data strategies, ensuring data consistency, integrity, and accessibility across systems. The desired role would also perform some database administration tasks.

Key Responsibilities

• Design and maintain logical data models that reflect business requirements and support enterprise data architecture.
• Collaborate with business analysts and stakeholders to gather and interpret data requirements.
• Translate business needs into normalized data structures and entity-relationship diagrams (ERDs).
• Ensure logical models align with physical database implementations and performance goals.
• Maintain metadata and data dictionaries to support data governance and lineage.
• Support data integration, migration, and transformation efforts by providing data modeling expertise.
• Conduct impact analysis for changes to data models or business processes.
• Stay current with industry trends, tools, and best practices in data modeling and database design.
• Installs, configures, and maintains database management software and related tools following recommend standards and security guidelines.
• Supports the application development teams in the design and creation of secure database structures and objects, migrating changes through the project development life cycle and into the production environment.
• Develops scripts and processes to perform data migration requests related to refreshing development and test environments from production.
• Performs performance and tuning of the overall database in addition to application specific queries.
• Support ETL database functions and processes.
• Other duties as assigned.

Required Qualifications

• 3+ years of experience in data modeling, database design, or data architecture.
• Strong understanding of relational database concepts, normalization, and data integrity.
• Proficiency in data modeling tools (e.g. ERwin, ER/Studio, etc).
• Familiarity with data governance, metadata management, and data quality principles.
• Excellent analytical, problem-solving, and communication skills.

Preferred Qualifications

• Bachelor's degree or technical certification with a minimum of three (3) years' related experience.
• Experience with supporting Oracle databases.
• Experience with cloud platforms (e.g., Azure, Google, and AWS) and cloud-native databases.
• Exposure to database administration tasks such as installation, configuration, and maintenance of Oracle DBMS.
• Experience supporting development lifecycle environments and data migration scripting.
• Knowledge of data warehousing and ETL processes.