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
Technical Skills
Strong expertise in:
Experience with:
Strong understanding of:
Preferred Qualifications
CERTIFICATIONS, LICENSES, REGISTRATIONS:
JOB KNOWLEDGE, SKILLS, ABILITIES:
SUPERVISORY RESPONSIBILITIES: NONE
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.
Cactus Companies is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, veteran status, genetic information, or any other characteristic protected by law.
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:
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.