Data Engineer

Summary

Join Donorbox, a leading fundraising platform, as a Data Engineer and play a key role in building and maintaining our data infrastructure. You will design, build, and optimize ETL/ELT workflows, create and refine data models in PostgreSQL, and ensure data quality. Collaborate with Data Analysts and other teams to understand data requirements and deliver accurate datasets and reports. Build reporting foundations, document data systems, and deploy data products to Superset. Work in an agile environment, present data products, and gather feedback. This fully remote position, based in Latin America, offers a competitive salary and excellent benefits.

Requirements

• Experience: 2+ years of hands-on experience in a Data Engineering role
• Strong proficiency in SQL
• Proficiency in Python , dbt , and Airflow
• Experience with PostgreSQL databases, or other similar database servers like Oracle or MySQL
• Familiarity with Superset or other visualization tools like PowerBI and Tableau
• A solid understanding of core software engineering principles, including modular code design, testing, and version control (e.g., Git)
• A proactive mindset, a strong willingness to learn new technologies, and a collaborative spirit are essential
• Exposure to working within agile development environments

Responsibilities

• Develop and Maintain Data Pipelines: Design, build, and optimize robust ETL/ELT workflows using SQL , Python , dbt , and Airflow to ingest and process data from various sources
• Design and Optimize Data Models: Create and refine data models, primarily within PostgreSQL , ensuring they are efficient, scalable, and support our analytical and reporting needs
• Ensure Data Quality and Usability: Cleanse, transform, and structure data to ensure accuracy, consistency, and a format suitable for analysis and reporting
• Collaborate with Stakeholders: Work closely with Data Analysts, business users, and other cross-functional teams to understand their data requirements, identify necessary data sources, and deliver accurate datasets and reports
• Build Reporting Foundations: Support the creation of summary tables and enhance database models to provide Data Analysts with ready-to-use data for their work
• Document Everything: Maintain clear and concise documentation for data systems, pipelines, data flows, and schemas, making it easy for others to understand and utilize our data assets
• Deploy Data Products: Help deploy datasets, reports, and dashboards to Superset for wider consumption
• Practice Software Engineering Excellence: Follow best practices in software development, including version control , testing , and modular code design
• Work in an Agile Environment: Operate effectively within our agile development framework, contributing to continuous improvement and quick iterations
• Present and Gather Feedback: Engage with stakeholders to present completed data products and gather valuable feedback for further iterations

Preferred Qualifications

Experience working with Ruby

Benefits

• Fully remote work from the comfort of your home
• Eligibility for employee equity plan (stock options)
• Reimbursement package for home office expenses and professional development, up to $1.5k
• Health insurance premium reimbursements, up to 75% for you and your family
• Generous time off policy of 21 days (birthday included 🎉), 8 holidays of your choice, and 2 paid volunteer days
• Wellness program with fitness and mindfulness classes