Lead Data Scientist, Data & Analytics

Motiva Enterprises LLC • Houston, TX

2d • Onsite

About The Position

At Motiva, our employees’ energy, passion, and dedication to excellence are what make us who we are and what allows us to generate energy that makes a house a home, gets us from point A to point B, and enables our health and wellbeing. We invest in every aspect of our employees’ lives because, at Motiva, our people matter. Headquartered in Houston, Texas, Motiva refines, distributes and markets petroleum products throughout the Americas. The company’s Port Arthur Manufacturing Complex in Port Arthur, TX, is comprised of North America’s largest refinery with a total throughput of 720,000 barrels per day, the largest base oil plant in the western hemisphere, and an integrated chemical plant. Under exclusive long-term brand licenses with Shell and Phillips 66 (for the 76® brand), Motiva’s commercial operations supply more than 12 billion gallons of fuel to customers annually. Motiva is wholly owned by Aramco, one of the world’s largest integrated energy and chemicals companies. Position Overview: We are seeking a highly skilled Lead Data Scientist, Data & Analytics with deep expertise in enterprise data modeling, data warehousing, and analytics platform engineering. This role will be responsible for designing, building, and optimizing scalable data solutions that support enterprise reporting, advanced analytics, and AI initiatives. The ideal candidate combines strong data engineering capabilities with extensive experience in logical and physical data modeling, dimensional modeling, and schema optimization. This individual will play a key role in establishing trusted, high-performance data foundations that enable reporting, self-service analytics, and AI-driven decision-making across the organization. This role is a Houston-based, in-office position at Motiva’s corporate headquarters in downtown Houston, TX.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
• 10+ years of experience in Data Engineering, Data Warehousing, Data Architecture, or related disciplines with Medallion Architecture (Bronze, Silver, Gold).
• Extensive experience creating Logical Data Models (LDMs), Physical Data Models (PDMs), and Entity Relationship Diagrams (ERDs).
• Strong hands-on experience designing and implementing dimensional models, including Star Schema and Snowflake Schema architectures.
• Hands-on experience with Databricks, Apache Spark, Delta Lake, and modern Lakehouse architectures building scalable ETL/ELT data pipelines in cloud-based environments.
• Strong understanding of data warehousing principles, metadata management, and data quality frameworks.
• Experience working with large-scale enterprise datasets and complex business processes.

Nice To Haves

• Experience supporting AI, machine learning, and advanced analytics use cases.
• Familiarity with Power BI, or other enterprise business intelligence tools.
• Experience implementing data governance, master data management (MDM), and data quality programs.
• Experience in downstream energy, supply chain, manufacturing, logistics, or other asset-intensive industries.

Responsibilities

• Design and maintain conceptual, logical, and physical data models, including Entity Relationship Diagrams (ERDs), to support enterprise data initiatives.
• Lead the design and implementation of scalable dimensional models using Star and Snowflake schemas for reporting and analytics workloads.
• Design new data schemas and optimize existing schemas to improve performance, scalability, and usability for high-volume reporting and analytical applications.
• Establish and enforce data modeling standards, naming conventions, and best practices across the enterprise.
• Build, maintain, and optimize data pipelines using Databricks, Azure Data Factory, Databricks Lakeflow Designer.
• Optimize query performance, and storage patterns to support large-scale reporting, analytics, and AI workloads.
• Support the design of semantic layers and analytical data structures that enable enterprise KPI reporting and executive dashboards.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior