Senior Data Engineer
Job Description
In Deloitte's Austin hub, the Senior Data Engineer collaborates on client engagements to design and optimize data pipelines and analytics solutions. The role centers on building ETL and ELT workflows, developing PySpark and Spark SQL notebooks, and leading data engineering efforts within the Project Delivery Model to enable scalable, data-driven outcomes.
Position details
- Location: Austin, TX (onsite)
- Salary: USD 95,000 - 150,000 per year
- Education: Bachelor's degree
Responsibilities
- Maintain regular communication with Engagement Managers (Directors), project teams, and representatives from multiple functional or technical groups, escalating issues as needed for management review
- Design, build, and optimize ETL and ELT pipelines using Azure Data Factory and Databricks
- Develop and refine PySpark and Spark SQL notebooks for large-scale data transformations
- Architect end-to-end data solutions across development, UAT, and production environments using Unity Catalog
- Lead design discussions with client architects and other counterparts
- Collaborate with teams on data contracts and schema agreements
- Lead the design and optimization of high‑volume data pipelines
- Define and enforce data engineering standards, including naming conventions, partitioning strategies, cluster configurations, and Spark tuning
- Drive performance improvements through AQE tuning, clustering strategies, broadcast joins, and shuffle partition management
- Design Databricks cluster policies, autoscaling configurations, and cost optimization approaches
- Conduct root cause analyses on production incidents and implement durable fixes
- Mentor junior and mid-level engineers through code reviews and pair programming
- Evaluate new technologies and recommend adoption (for example, DABs, DLT, Auto Loader, Serverless Compute, and event hubs)
Requirements
- Proficiency in Python, PySpark, Spark SQL, and SQL Server
- Experience with Azure components such as Data Factory, ADLS Gen2, Key Vault, and Azure Monitor
- Familiarity with Databricks technologies including Delta Lake, Unity Catalog, and Workflows
- Knowledge of Apache Airflow
- Git or Azure DevOps experience
- Deep understanding of Spark internals, including DAG optimization, spill analysis, and skew handling
- Delta Lake advanced features such as time travel, deletion vectors, and predictive I/O
- Unity Catalog governance aspects including row/column security, external locations, and system tables
- Infrastructure as code with Terraform and Azure ARM templates
- Bachelor's degree in Computer Science, Information Technology, Computer Engineering, or a related IT discipline, or equivalent experience
- Limited immigration sponsorship may be available
- Ability to travel approximately 10% on average, based on client and project needs
Technologies
- Python, PySpark, Spark SQL, SQL Server
- Azure: Data Factory (ADF), ADLS Gen2, Key Vault, Azure Monitor
- Databricks: Delta Lake, Unity Catalog, Workflows
- Apache Airflow
- Git, Azure DevOps
- Delta technologies and optimization: DABs, DLT, Auto Loader, Serverless Compute, event hubs
- Infrastructure as code: Terraform, Azure ARM templates