Information Systems Data Engineer

About the Organization

ClimateWorks Foundation is a global organization committed to our mission: to end the climate crisis by amplifying the power of philanthropy. Since our founding in 2008, we have awarded over $2 billion in grants to more than 850 organizations advancing climate solutions around the world. We helped grow the field of climate philanthropy to where it stands today, establishing infrastructure, global networks, and momentum for continued growth. Through our Global Programs and Services, we equip philanthropy with global knowledge, networks, and solutions to drive climate progress.

·       Scaling solutions: Our collaborative Global Programs— focused on solution areas including carbon dioxide removal, cooling, industry, transportation, and more — produce results that are bending the greenhouse gas emissions curve. From the U.S. to Europe, China, Brazil, and beyond, we collaborate with a diverse community of funders, NGOs, and climate leaders to accelerate just and equitable climate solutions.

·       Guiding and supporting funders: Our Global Services provide funders with comprehensive resources to assess, build, evolve, and execute high-impact climate-giving strategies. Our Global Intelligence service equips funders and the climate community with climate insights to pinpoint opportunities for impact and philanthropic insights to help identify investment priorities. We facilitate Global Collaborations that enable funders to increase individual and collective impact. Our Global Grantmaking services enable funders to invest in climate solutions around the world.

·       Fostering collaboration, exploration, and growth: Our collaborative approach and commitment to learning ensures that we continuously explore innovative ideas and emerging opportunities — all with the aim of scaling philanthropy-supported initiatives to help end the climate crisis.

As experts in climate science, public policy, economic and social analysis, and strategic philanthropy, ClimateWorks’ staff understands the multi-faceted challenges and opportunities of climate change. We are researchers, strategists, collaborators, and grantmakers who care passionately about our mission. For more information, please visit.

Department Summary

The Information Systems & Technology Department (IS&T) serves as a key partner within the broader operations function at ClimateWorks, managing and optimizing the organization's use of technology and information to support key business objectives. The IS&T team owns the development and maintenance of the long-term roadmap for ClimateWorks’ broader systems architecture, including the ongoing development of system implementations, feature, and functionality enhancements. In addition, user support and help desk, risk management, cybersecurity, infrastructure management and network administration are core responsibilities of the IS&T department.

The Information Systems division within the IS&T Department also collaborates closely with the Global Intelligence Department to curate and maintain the systems and processes that are used to collect, store, analyze and share climate and philanthropic insight related data with internal staff and partners. The philanthropic insights function of the Global Intelligence service is one of many shared responsibilities between the Global Intelligence team and the Information Systems team in support of the Global Intelligence Service.

The Information Systems Data Engineer      will report to the Senior Director, Information Systems & Technology to serve as the primary engineer responsible for designing, building, and maintaining a new data architecture and pipelines that integrate data from multiple business systems.     The successful candidate should have 7+ years working in complex organizations standing up new data pipelines, warehouses, and architecture technologies.  They should be a strategic thinker who is able to see how departmental processes and data points are interconnected and skilled at authoring and implementing performant and accurate technical solutions that facilitate flows of and access to information.

Essential Tasks

Systems Architecture

● Design, build, and manage eficient 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 marts, 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.

 Systems Governance and Planning

● 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).

Required Qualifications

● 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.

● Adept in identifying relative level-of-effort required and associated complexities for technical projects to determine realistic approaches and roadmaps.

● 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.

Preferred Qualifications

● Significant experience and understanding of CRM/ERP/Grants Management Systems architecture and APIs (e.g., Salesforce).

● Experience building schemas and models for Tableau.

● Knowledge of data governance, data quality, and compliance frameworks.

● Experience with non-profit operations and fundraising processes.

Compensation

ClimateWorks offers an excellent benefits package and a competitive salary that is commensurate with experience (geographic differential applied based on location)

Salary Range (Bay Area / NYC): $130,000 - $140,000 annually

Salary Range (Other US): $120,000 - $130,000 annually

*** ClimateWorks strives to create an equitable culture of transparency and fairness.

Location

ClimateWorks Foundation is based in the San Francisco Financial District. This position is classified as US Flexible. Exceptional candidates can work from the SF office or from other locations, geographic differential applied to compensation based on local cost of labor.

Equal Employment Opportunity

We are committed to equal employment principles. We strive to find ways to attract, develop, and retain the talent needed to meet business objectives, and to recruit and employ highly qualified individuals representing the diverse communities in which we live. 

Our employment policies and decisions on employment and promotion are based on merit, qualifications, performance, and business needs. We make the decisions and criteria governing the employment relationship with all employees in a nondiscriminatory manner, without regard to race, color, age, national origin, religion, sexual orientation, gender, gender identity, marital status, sex (including childbirth, breastfeeding, and related medical conditions), pregnancy, uniform service member and veteran status, citizenship status, disability, protected medical condition, genetic information, or any other status protected under applicable federal, state, or local laws. Support and belief in this principle is a basic responsibility of all employees. 

This policy extends to all aspects of our employment practices, including but not limited to recruiting, hiring, discipline, termination, promotions, transfers, compensation, benefits, training, leaves of absence, and other terms and conditions of employment.  

Application Process 

All qualified candidates are encouraged to apply as soon as possible. To be considered for this position, interested candidates must submit a resume and cover letter. This position will remain open until filled.

Employment at the ClimateWorks Foundation is at-will.