Senior Data Engineer

OverviewDonorbox is seeking a motivated Senior Data Engineer to join our growing team.In this role, you'll take ownership of building and maintaining the data infrastructure that drives analytics and informs key business decisions.You'll transform raw data into actionable insights, solve complex technical challenges, and help shape the future of our data systems.If you're passionate about data, thrive in a collaborative environment, and enjoy making an impact, we want to hear from you.ResponsibilitiesDevelop 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.Mentor and Collaborate: Serve as a technical leader, mentoring junior engineers and promoting best practices in coding, data modeling, and system design.You'll also work closely with data analysts and business stakeholders to translate business needs into technical requirements.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.Own the Solution: Take ownership of complex data problems from start to finish, from identifying the root cause to implementing a production-ready solution.Conduct regular performance audits on existing data pipelines, databases, and dashboards, and implement optimizations.Qualifications & ExperienceExperience: 5+ years of hands-on experience in a Data Engineering role, with a proven track record of building and managing production data systems.Technical Proficiency:Strong proficiency in SQL, Python, dbt, and Airflow.Extensive experience with PostgreSQL or similar relational databases (e.g., MySQL, Oracle).Familiarity with Superset or other visualization tools like PowerBI and TableauSoftware Engineering Principles: A solid understanding of core software engineering principles, including modular code design, testing, and version control (e.g., Git).Problem-Solving Skills: The ability to think critically, solve complex problems independently, and drive projects to completion.Communication: Excellent communication skills, with the ability to explain complex technical concepts to both technical and non-technical audiences.Agile Experience: Experience working in an agile development environment.Bonus PointsExperience working with Ruby.Experience in the nonprofit or fundraising technology sector.Experience with SaaS.DetailsFully remote based in Latin AmericaSalary: $45k-$60k USD, based on experience and locationBenefits & PerksFully remote work from the comfort of your homeEligibility for employee equity plan (stock options)Reimbursement package for home office expenses and professional development, up to $1.5kHealth insurance premium reimbursements, up to 75% for you and your familyGenerous time off policy of 21 days (birthday included ), 8 holidays of your choice, and 2 paid volunteer daysWellness program with fitness and mindfulness classesLove your work and our mission of serving nonprofitsThe Application ProcessWe have 5 stages:Apply here and fill out our questions to tell us about youPrescreen Call with the Talent teamTechnical Interview with Hiring ManagerPanel/Final InterviewBackground + Reference ChecksIf this sounds like the right role for you, please apply today and let us know why.We look forward to hearing from you#J-*****-Ljbffr