Data Engineer - Python, SQL and Snowflake / Redshift
This is W2 only position. Client seeks strong Python Developer with expertize in Redshift or Snowflake. This is a remote position seeking storng Python developers with SQL.
Please confirm:
ā¢ You can write Object Oriented python code and used concepts like encapsulation, interfaces and inheritance
ā¢ Strong SQL Data Analysis experience.
ā¢ You have designed complex data models that involve many tables, facts and dimensions and know how to give careful consideration to the type of data model required for different scenarios
ā¢ You have recent, hands on experience in building a lakehouse following the medallion architecture using modern stacks like dbt on either Snowflake or Redshift
Job Description for Data Engineers:
1 Redshift (will accept Snowflake or BigQuery experience as a replacement) - Required
2 Strong SQL skills - Required
3 Dimensional modeling in a data warehouse (star and snowflake schemas) - Required
4 Strong Python experience - Required
5 Good Data Analysis skills - Required
6 Git CI/CD experience (GitHub or Gitlab) - Required
7 Proficient in use of AI (Gitlab Duo, Gemini, or similar) for coding efficiency - Required
8 Apache Airflow, Mage, or similar orchestration service experience - Desired
9 AWS services (S3, Postgres, IAM) experience - Desired
10 DBT experience - Desired
11 Experience in daily Engineering operations, support, and issue resolution. - Desired
From soft skills and SDLC perspective, the following are needed:
1 Agile mindset and experience - Required
2 Curious/Growth mindset - Required
3 Alignment to the 5 Red Cross Core values (collaborative, committed, compassionate, creative, credible) - Required
Apply tot his job
Apply To this Job
Please confirm:
ā¢ You can write Object Oriented python code and used concepts like encapsulation, interfaces and inheritance
ā¢ Strong SQL Data Analysis experience.
ā¢ You have designed complex data models that involve many tables, facts and dimensions and know how to give careful consideration to the type of data model required for different scenarios
ā¢ You have recent, hands on experience in building a lakehouse following the medallion architecture using modern stacks like dbt on either Snowflake or Redshift
Job Description for Data Engineers:
1 Redshift (will accept Snowflake or BigQuery experience as a replacement) - Required
2 Strong SQL skills - Required
3 Dimensional modeling in a data warehouse (star and snowflake schemas) - Required
4 Strong Python experience - Required
5 Good Data Analysis skills - Required
6 Git CI/CD experience (GitHub or Gitlab) - Required
7 Proficient in use of AI (Gitlab Duo, Gemini, or similar) for coding efficiency - Required
8 Apache Airflow, Mage, or similar orchestration service experience - Desired
9 AWS services (S3, Postgres, IAM) experience - Desired
10 DBT experience - Desired
11 Experience in daily Engineering operations, support, and issue resolution. - Desired
From soft skills and SDLC perspective, the following are needed:
1 Agile mindset and experience - Required
2 Curious/Growth mindset - Required
3 Alignment to the 5 Red Cross Core values (collaborative, committed, compassionate, creative, credible) - Required
Apply tot his job
Apply To this Job