Description
You will design and maintain cloud-based data warehouse architectures and ETL pipelines.
This role is remote.
Responsibilities
- Design and implement data warehouse solutions in collaboration with Data Science teams.
- Develop, test, and maintain data pipelines, ETL processes, and feature engineering pipelines using AWS services.
- Manage databases including Snowflake, Redshift, and DB2 with a focus on dimensional modeling.
- Implement and support feature stores and NoSQL databases.
- Troubleshoot complex ETL and SQL issues across Data Lake, Data Warehouse, and Data Mart environments.
Required Skills
- 5+ years of professional experience in data engineering.
- Strong proficiency in SQL and experience with data pipelines.
- Expertise in ETL processes and dimensional modeling.
- Experience with cloud data warehousing technologies like Snowflake.
- Familiarity with database systems such as DB2.
- Knowledge of Python and Unix scripting for data manipulation.
- Experience with CI/CD tools (GitHub, GitHub Actions, CodePipeline, CloudFormation).
Preferred Skills
- Experience with Informatica PowerCenter/IICS.
- Ability to analyze requirements and propose technical solutions.