Cactus Wellhead - Data Engineer & Architect

This is a Cactus Wellhead position and is located in Houston, TX

Looking for local candidate

In office 4 days; work from home 1 day (option)

JOB SUMMARY: The Senior Data Engineer / Data Architect is responsible for designing, building, and governing the enterprise data platform on Azure Databricks. This role owns both hands-on data engineering delivery and data architecture design, ensuring that enterprise data is reliable, scalable, secure, and ready to support analytics, reporting, and AI initiatives.

The position plays a critical role in transforming data from ERP, CRM, and other enterprise systems into trusted, reusable data products that enable business insights and future AI capabilities. The role operates with high ownership across the full lifecycle, from ingestion and transformation to data modeling, governance, and platform optimization, aligned with a modern Lakehouse architecture.

ESSENTIAL FUNCTIONS, ROLES AND RESPONSIBILITIES: Essential duties and responsibilities include the following:

Data Engineering & Pipeline Development

Design and build end-to-end data pipelines (batch and near real-time) using Databricks and Spark

Implement and maintain Bronze / Silver / Gold data architecture layers

Ingest data from ERP, SaaS applications, APIs, and legacy systems into Lakehouse

Optimize pipelines for performance, scalability, and cost efficiency

Implement CI/CD pipelines using GitHub

Data Architecture & Modeling

Define and maintain the enterprise data architecture and standards

Design logical and physical data models across core business domains (finance, operations, field service)

Establish consistent definitions for critical entities (customer, job, revenue, etc.)

Ensure data structures support both analytics and AI/ML workloads

Data Governance, Security & Quality

Implement and manage Unity Catalog–based governance (RBAC, lineage, auditability)

Define and enforce data standards for naming, access control, and data quality

Ensure compliance with security policies (e.g., sensitive HR and financial data protection)

Establish monitoring, validation, and reconciliation processes to ensure data accuracy and reliability

Platform & Integration Design

Define scalable patterns for:

Data ingestion

Transformation pipelines

Data access (BI tools, APIs, AI models)

Integrate Databricks with Azure services (ADLS, APIs, enterprise systems)

Ensure platform reliability, observability, and operational excellence

AI & Advanced Analytics Enablement

Prepare and structure data for AI/ML use cases and automation initiatives

Partner with analytics and AI teams to deliver datasets supporting predictive models and AI-driven workflows

Enable reusable datasets and feature-ready data pipelines

Collaboration & Leadership

Partner with business stakeholders, application teams, and analytics teams to translate requirements into scalable solutions

Provide technical leadership for data engineering best practices and architecture decisions

Mentor junior engineers or contractors as the platform scales

EDUCATION, TRAINING, EXPERIENCE:

Experience

6–10+ years of experience in data engineering, data architecture, or enterprise data platforms

Hands-on experience building and supporting data pipelines in cloud environments

Experience working with enterprise systems (ERP, CRM, or similar)

Technical Skills

Strong expertise in:

Azure Databricks / Apache Spark

Python / PySpark

SQL (advanced)

Experience with:

Azure Data Lake Storage (ADLS)

CI/CD with Github

API and data integration patterns

Strong understanding of:

Data modeling (dimensional and normalized)

Data governance and security (RBAC, lineage)

Preferred Qualifications

Experience with Delta Lake and Lakehouse architecture

Exposure to ML/AI pipelines or data science workflows

Experience in manufacturing, oil & gas, or ERP-heavy environments

CERTIFICATIONS, LICENSES, REGISTRATIONS:

None required

JOB KNOWLEDGE, SKILLS, ABILITIES:

Familiarity with modern programming languages and frameworks (C#, .NET, SQL, JavaScript).

Experience with DevOps, CI/CD, and source control for ERP development.

Knowledge of cloud-based ERP solutions and migration strategies.

Strong background in data integration, ETL, and reporting tools (Power BI, SSRS, Tableau).

SUPERVISORY RESPONSIBILITIES: NONE

Occasionally may be exposed to hazards such as loud noise, heavy equipment, temperature extremes, toxic or caustic chemicals; risk of electrical shock.

The noise level in the work environment is usually moderate.

Disclaimer: This job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the employee for this position. Duties, responsibilities, and activities may change at any time with or without notice.

Safety is our top priority. All employees must comply with our comprehensive safety programs, participate in required safety training, and demonstrate commitment to our safety-first culture. This position may require working in potentially hazardous environments if you are traveling to a branch or plant location. Ensure that you follow all safety guidelines that are required when working in the field, branch or manufacturing facility.

This position generally operates in a professional office environment. The role routinely uses standard office equipment such as computers, phones, photocopiers, and filing cabinets. While performing the duties of this job, the employee is regularly required to:

Sit for extended periods at a desk and work on a computer

Use hands to finger, handle, or feel objects, tools, or controls

Reach with hands and arms

Talk and hear

Occasionally lift and/or move up to 25 pounds

Walk or stand periodically throughout the day

Maintain sustained concentration on computer screens

Work under deadlines with frequent interruptions

The noise level in the work environment is usually moderate. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Cactus Companies maintains a drug-free workplace and participates in E-Verify.