Job Url: https://www.remoterocketship.com/company/climateworks-foundation/jobs/information-systems-data-engineer-united-states-remote/ Job Description: 🇺🇸 English Post a Job Affiliates Search Remote Jobs ClimateWorks Foundation Website LinkedIn All Job Openings ClimateWorks Foundation is a global platform dedicated to accelerating climate solutions through philanthropy. With a mission to end the climate crisis, it amplifies the impact of philanthropy by collaborating with grantmakers and implementing partners worldwide. ClimateWorks supports climate solutions across a variety of sectors including transportation, food and agriculture, forests, and sustainable finance. Since 2008, it has granted over $1. 8 billion to more than 850 organizations in over 50 countries. The foundation seeks to bend the emissions curve and advance a thriving planet for all living beings. 51 - 200 employees Founded 2008 🤲 Charity 🤝 Non-profit Information Systems Data Engineer 5 days ago 🇺🇸 United States – Remote 💵 $120k - $140k / year ⏰ Full Time 🟠 Senior 🔴 Lead 🚰 Data Engineer 🦅 H1B Visa Sponsor Airflow AWS Azure Cloud ETL Python SQL Apply Now Receive Emails with Similar Jobs Report problem 📋 Description • Design, build, and manage efficient data pipelines and supporting architectures to effectively, ingest, store, retrieve, and analyze data across multiple systems. • Incorporate organizational priorities and departmental roadmaps to most effectively design, develop, and maintain the overall data warehouse strategy, architecture, data models and charts, security, and performance. • Translate business needs into high performance architectures, pipeline designs, and technical solutions. • Implement and maintain data integration processes that facilitate accurate and performant flows of information across multiple business systems. • Research and implement solutions and 3rd party integrations needed for enterprise architecture ecosystem enhancements. • Continuously monitor and optimize existing integrations and configurations, making adjustments to improve efficiency and reliability; troubleshoot as needed. • Define and implement data governance policies and best practices to ensure data quality and security. • Create and manage technical documentation including process models, specifications, and diagrams for the data warehouse and all systems integrations. • Effectively coordinate related workstreams and prioritize strong engagement with multiple project teams internally and across various contractors. • Drive ClimateWorks’ development lifecycle to accurately deploy system changes (effort assessments, technical development, user testing, and data migration). 🎯 Requirements • At least 5-7 years of experience in a related role. • Snowflake SnoPro Core Certification is required. • At least 3 years of experience building brand new schemas and data warehouses with Snowflake, Snowpark, and SnowDDL. • At least 3 years of experience using data management and data integration tools and technologies, such as Workato. • Significant experience with a variety of data modeling structures and data warehousing techniques, in addition to cloud providers such as AWS and Azure. • Experience gathering and documenting requirements for ETL processes. • Experience building and managing ETL/ELT pipelines with tools like dbt, Airflow, Fivetran. • Experience with version control systems (e.g., Git/GitHub, GitLab, Bitbucket) and documenting code and processes for collaboration and maintainability. • Experience with CI/CD frameworks and tools. • Experience implementing large, multi-system projects. • Strong understanding of data management principles. • Fluent in SQL and Python. • Meticulous attention to detail, strong organizational skills, and the ability to analyze complex data structures. • Experience and comfort working in a highly collaborative and deadline-driven professional environment. • Ability to work effectively and efficiently with minimal supervision, including working under pressure and managing shifting priorities. • Interest in climate change with a commitment to ClimateWorks’ mission and values, including a desire to understand the data itself and its strategic importance to organizational business processes. • A commitment to a diverse, inclusive, and equitable work environment. • A willingness to travel 3 – 4 times per year for in-person collaboration if located outside the San Francisco Bay Area. 🏖️ Benefits • ClimateWorks offers an excellent benefits package