Senior Data Engineer

Ares Holdings, LLC
Pittsburgh, PA, United States
11 days ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
6 years minimum
Working hours
Regular working hours

Tech stack

Data Analysis Microsoft Azure Batch Processing Big Data Software Quality Code Review Information Systems Continuous Integration Information Engineering Data Governance Data Infrastructure Data Warehousing
+22 more
Digital Architecture Dimensional Modeling Python (Programming Language) Operational Data Store Operational Databases Performance Tuning Azure Data Lake SQL Databases Data Streaming Data Ingestion Azure Data Factory Sql Optimization Apache Spark Git Data Lakes Pyspark Information Technology Data Lineage Collibra Apache Kafka Data Pipelines Databricks

Job description

We are seeking a hands-on Senior Data Engineer to build, operate, and improve an enterprise data warehouse and production data pipelines in an Azure Databricks environment., This role works across the Bronze, Silver, and Gold layers of a medallion architecture, with a strong focus on data ingestion, transformation, modeling, quality, performance, and reliability. The Senior Data Engineer will own assigned data domains as production systems, simplify legacy transformation layers, support the transition toward event-driven ingestion, and mentor other engineers as the data platform evolves., * Design, build, and support enterprise data warehouse pipelines and data models across Bronze, Silver, and Gold layers in Databricks.

  • Develop ingestion patterns and Bronze-to-Silver transformations that produce clean, standardized, and reliable data.
  • Create dimensional and harmonized data models, including conformance, survivorship, and Gold-layer promotion rules.
  • Own assigned data domains in production, including data-model integrity, pipeline reliability, ingestion SLAs, incident response, and root-cause remediation.
  • Build and maintain Delta Lake pipelines and help transition selected workloads from batch processing to event-driven, low-latency ingestion.
  • Develop streaming and high-SLA ingestion patterns using technologies such as Zerobus Ingestion and Spark Declarative Pipelines.
  • Implement row-level reconciliation, validation checkpoints, automated quality gates, and data-contract validation throughout the data lifecycle.
  • Build Gold-layer tables that support Unity Catalog metric views, lineage tracking, governed access, and downstream analytics.
  • Optimize pipeline performance, processing latency, platform reliability, and Databricks compute costs.
  • Consolidate legacy transformation layers into a simplified target architecture while validating output accuracy.
  • Monitor pipeline health, investigate anomalies, and resolve data-reliability incidents.
  • Document architecture decisions, data models, transformation logic, feed SQL, and operational procedures.
  • Review pull requests and maintain code quality through Azure DevOps, Git, and CI/CD practices.
  • Mentor Data Engineers in Databricks development patterns, SQL, Python, PySpark, testing, and documentation.
  • Collaborate directly with data governance, quality assurance, analytics engineering, and business-facing stakeholders to clarify requirements and resolve delivery issues.

Requirements

  • Six or more years of progressive data engineering experience.
  • Experience owning an enterprise data warehouse or large-scale data transformation pipelines in production with defined SLAs.
  • Deep, hands-on Databricks experience in production environments.
  • Strong experience with Delta Lake, medallion architecture, Unity Catalog, and Databricks pipeline performance optimization.
  • Advanced SQL skills and strong proficiency with Python and PySpark.
  • Ability to independently build, review, troubleshoot, and optimize complex data transformations.
  • Strong data warehousing experience, including dimensional modeling, harmonized data models, conformance rules, and survivorship logic.
  • Hands-on experience with Azure Databricks, Azure Data Lake Storage, Azure Data Factory, and CI/CD practices using Azure DevOps.
  • Experience operating production data pipelines, including monitoring, incident response, reliability management, and performance improvement.
  • Ability to learn complex, under-documented data environments and create clear, durable technical documentation.
  • Strong communication skills and the ability to work directly with technical, governance, quality, analytics, and business stakeholders., * Healthcare, pharmacy, specialty-pharmacy, or other regulated-industry experience involving clinical or operational data.
  • Production experience with event-driven ingestion using Azure Event Hubs, Kafka, or equivalent technology through Structured Streaming.
  • Familiarity with Zerobus Ingestion and Spark Declarative Pipelines.
  • Experience implementing data contracts using ODCS or an equivalent standard.
  • Familiarity with pipeline-observability platforms such as Monte Carlo.
  • Experience with enterprise data-catalog platforms such as Atlan, Collibra, or equivalent tools.
  • Experience creating governed data-pipeline assets with documented metadata and lineage.
  • Demonstrated technical leadership through mentoring, code review, standards development, and influence without formal management authority.
  • Bachelors degree in Computer Science, Data Engineering, Information Systems, or a related discipline, or equivalent professional experience.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…