Key skills
AWSETLPythonSparkSQLSnowflakeS3GlueAthenaCI/CD
About this role
Role Overview
- Understand and translate business needs into data models supporting long-term solutions.
- Perform reverse engineering of physical data models from databases and SQL scripts.
- Analyse data-related system integration challenges and propose appropriate solutions.
- Assist with and support setting the data architecture direction (including data movement approach, architecture/technology strategy, and any other data related considerations to ensure business value).
Requirements
- 5+ Years of experience as a Data Engineer
- Strong technical expertise in SQL Advanced SQL querying skills (joins, subqueries, CTEs, aggregation)
- Strong knowledge of joins and common table expressions (CTEs)
- Experience in Snowflake, ETL, SQL, CI/CD
- Strong expertise in ETL process and with various data model concepts
- Knowledge of star schema and snowflake schema
- Good to know about AWS services such as S3, Athena, Glue, EMR/Spark with a major emphasis on S3 and Glue
- Good knowledge of Python
Tech Stack
- AWS
- ETL
- Python
- Spark
- SQL
Benefits
- Health insurance and wellness programs
- 401(k) retirement plan
- Paid time off
- Flexible work arrangements
- Professional development opportunities