Logical Data Modeler

Position: Logical Data Modeler

Position Term: 18 Month Contract Full-time

Location: Houston, TX, US - (On-site)

Company Details:

Our client works closely with customers to provide the necessary infrastructure to serve growing markets and safely deliver natural gas products to reliably fuel the clean energy economy. With interstate natural gas pipelines and gathering & processing operations throughout the country, we reliably deliver value to our employees, investors, customers and communities by running our business with authenticity and a safety-driven culture, leading our industry into the future.

Position Details:

Our client is 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.

Qualifications & Requirements:

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.