Information Systems Data Engineer
ClimateWorks Foundation
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $120,000 - $140,000 per year
Job Level
SeniorLead
Tech Stack
AirflowAWSAzureCloudETLPythonSQL
About the role
- 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
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data pipelinesdata warehousedata modelsdata integrationETLELTdata governanceSQLPythondata modeling
Soft skills
organizational skillsanalytical skillscollaborationattention to detailability to work under pressuretime managementcommunicationproblem-solvingadaptabilitycommitment to diversity
Certifications
Snowflake SnoPro Core Certification