Senior Data Engineer to implement and maintain an Azure cloud based data platform and medallion architecture for RectorSeal's Data & BI team in a delivery focused, hands-on role with hybrid on-site work in Houston.

Responsibilities

Design and deploy scalable cloud data platforms to support manufacturing operations, inventory management, and distribution analytics.
Build and maintain Lakehouse environments and ELT/ETL workflows using Databricks, Lakeflow, Azure Data Factory, FiveTran, and Azure Data Lake Storage.
Consolidate data from ERP and diverse source systems, including JD Edwards (JDE), HubSpot, Oracle, and SQL Server.
Configure and manage Unity Catalog, applying access policies, lineage settings, and metadata in line with governance.
Implement RBAC and ABAC across the data platform, including row level and column level security in Unity Catalog and ADLS.
Monitor pipeline health, troubleshoot failures, and perform root-cause analysis on data quality or performance issues.
Participate in daily support and respond to production incidents in a timely manner.
Actively share knowledge and produce clear technical documentation for all solutions, including pipeline designs, data flow diagrams, runbooks, and configuration notes.
Maintain up-to-date documentation in the team knowledge base.
Contribute to team standards and best practices.

Requirements

Databricks: 5+ years of hands-on data engineering experience, strong Python skills, proficient with Delta Lake, PySpark/Spark SQL, notebooks, jobs, and cluster management.
Azure Data Platform: Proficient with Azure Data Lake Storage Gen2 and the broader Azure data ecosystem, including Azure Data Factory, Azure Logic Apps, and Azure Key Vault.
Data Integration: Practical experience with connector management, APIs, and Lakeflow (Workflows / DLT pipelines); hands-on with medallion architecture, dimensional modeling, and incremental load.
Source Systems: 5+ years with Oracle (PL/SQL, stored procedures) and SQL Server (T-SQL, CDC, query optimization); experience extracting from JD Edwards (JDE) table structures and business data models.
Access Control: Hands-on with RBAC/ABAC, row-level security, and column-level security across Databricks, Unity Catalog, and relational databases.
DevOps: Experience with Git, Azure DevOps or GitHub Actions, Ansible, and CI/CD pipelines.
Power BI: Knowledge and hands-on experience with Power BI.
Agile: Familiar with Agile methodology, participate in Sprint planning.

Technologies

Databricks
Delta Lake
PySpark
Spark SQL
Lakeflow
Azure Data Factory
FiveTran
Azure Data Lake Storage
Unity Catalog
Azure Data Lake Storage Gen2
Azure Logic Apps
Azure Key Vault
Oracle
JD Edwards (JDE)
HubSpot
SQL Server
Git
Azure DevOps
GitHub Actions
Ansible
Power BI
Event Hubs
Kafka
Structured Streaming
Azure Functions
Azure ML
Azure Synapse
Microsoft Fabric
Oracle Cloud
dbt

Benefits

Medical, dental, and vision plans
401(k)
Pension
Life insurance
Paid time off program with paid holidays
Wellness programs

Compensation

RectorSeal uses market data to establish salary ranges and pays within the defined range based on experience and market position. In addition, pay incentives may be offered based on corporate and individual performance or at the discretion of leadership.

About RectorSeal

Based in Houston, RectorSeal, LLC, a wholly owned subsidiary of CSW Industrials, Inc. (NYSE: CSW), serves HVAC/R, plumbing, electrical, and construction markets with innovative products designed to enhance efficiency and reliability.

About the Role

This delivery focused, hands-on position centers on implementing and maintaining an Azure based data platform and scalable medallion architecture to advance enterprise data initiatives. Primary responsibilities include implementation, platform maintenance, operational excellence, and modernization efforts within RectorSeal's Data & BI team in a hybrid Houston setting.

Senior Data Engineer

Job Description