Data engineer with Python and SQL expertise
Core
Designing and optimizing complex SQL data transformation pipelines and dimensional models at scale within an enterprise data warehouse.
Role type
Senior Data Engineer (SQL/Python)
Builds
Robust, scalable data transformation pipelines and optimized SQL logic
Domain
Enterprise Data Warehousing / Analytics
Required skills
Advanced SQL, Snowflake, Python, Git, Data Quality Frameworks, Dimensional Modeling, CI/CD
Preferred skills
Airflow/MWAA, AWS (S3/Glue), SRE practices, Healthcare data (PHI/PII/EDI)
Technologies
Airflow, AWS, CI/CD, Data Warehouse, Git, GitHub, Python, SQL, Snowflake
Responsibilities
Analyze query performance using analytical functions and data modeling techniques; Convert business requirements into efficient SQL pipelines; Engage in dimensional modeling (star, snowflake, denormalized); Design and enhance complex transformation logic to scale effectively
