Donorbox is looking for a motivated and collaborative Data Engineer to join our growing team. As a Data Engineer, you'll be instrumental in transforming raw data into valuable insights. Design, build, and optimize robust ETL/ELT workflows using SQL, Python, dbt, and Airflow to ingest and process data from various sources. Create and refine data models, primarily within PostgreSQL, ensuring they are efficient, scalable, and support our analytical and reporting needs. Cleanse, transform, and structure data to ensure accuracy, consistency, and a format suitable for analysis and reporting.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.
Support the creation of summary tables and enhance database models to provide Data Analysts with ready-to-use data for their work. Follow best practices in software development, including version control, testing, and modular code design.