Logical Data Modeler

Logical Data Modeler Location: Houston, TX Skills: data modeling, database design, or data architecture., cloud platforms (e.g., Azure, Google, and AWS) and cloud-native databases., installation, configuration, and maintenance of Oracle DBMS., ETL processes., data modeling tools (e.g. ERwin, ER/Studio, etc). If you post this job on a job board, please do not use company name or salary. Experience level: Mid-senior Experience required: 7 Years Education level: Bachelor’s degree Job function: Information Technology Industry: Oil & Energy Pay rate : $55 per hour Total position: 1 Relocation assistance: No Visa sponsorship eligibility: No 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.