remote
Senior Data Warehouse Specialist - IvoryCloud
Software Engineer
Senior Data Warehouse Specialist designing, building, and maintaining complex data pipelines using SQL, ETL, Python, and AWS Snowflake to deliver reliable reporting environments for program staff and leadership.
About the role
Key Responsibilities
- Design, develop, and maintain scalable data pipelines that extract, transform, and load data from diverse client source systems into enterprise reporting environments.
- Implement robust data modeling and schema design to support business intelligence and analytics needs.
- Collaborate with cross‑functional teams to document business rules, data quality standards, and performance metrics.
- Optimize pipeline performance using AWS services (Glue, Redshift, S3) and Snowflake best practices.
- Monitor, troubleshoot, and resolve data issues, ensuring high data integrity and availability.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field.
- Extensive experience with SQL, ETL tooling, and data warehouse technologies (Snowflake, Redshift).
- Proficiency in Python for data transformation and automation.
- Hands‑on knowledge of AWS data services (Glue, S3, Redshift).
- Strong analytical skills, attention to detail, and ability to translate business requirements into technical solutions.
Skills
sqlpythonawssnowflake