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.
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.
Experience and Qualifications:Required Education and Experience: - 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.
Preferred Education and Experience: - 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.
We reserve the right to amend or withdraw Motiva jobs at any time, including prior to the closing date. Depending on qualifications, the successful candidate may be offered a position at a more appropriate level and/or grade.
