26-223: Senior Data Engineer
Core
Develop, maintain, monitor, and optimize Amazon Redshift data warehouses and ETL/ELT pipelines to support enterprise analytics and reporting.
Role type
Senior Data Engineer (Data Warehouse & ETL)
Builds
Production data pipelines, data warehouse solutions, and migration artifacts to Databricks
Domain
Cloud Data Engineering (AWS)
Required skills
Amazon Redshift, SQL (complex development & tuning), ETL/ELT design, Python, AWS S3, Tableau, Production monitoring, Root-cause analysis, Databricks (learning curve)
Preferred skills
Delta Lake, Medallion Architecture, Unity Catalog, PySpark, Workflows
Technologies
Amazon Redshift, Amazon S3, Tableau, Databricks, Python, SQL
Responsibilities
Monitor scheduled ETL jobs and Redshift workloads; Design and maintain scalable ETL/ELT solutions; Perform SQL performance tuning and query optimization; Support Tableau reporting and analytics workloads; Participate in the phased migration of Redshift workloads to Databricks; Develop data validation checks and automated quality controls.
Seniority
Senior, hands-on IC