Salary
💰 $45,000 - $60,000 per year
Tech Stack
AirflowETLMySQLOraclePostgresPythonRubySQLTableau
About the role
- Design, build, and optimize robust ETL/ELT workflows using SQL, Python, dbt, and Airflow
- Create and refine data models in PostgreSQL to support analytics and reporting
- Cleanse, transform, and structure data to ensure accuracy and usability
- Mentor junior engineers and collaborate with data analysts and stakeholders
- Support creation of summary tables and enhance database models for analysts
- Maintain clear documentation for data systems, pipelines, flows, and schemas
- Deploy datasets, reports, and dashboards to Superset for wider consumption
- Follow software engineering best practices: version control, testing, modular design
- Operate within an agile framework and contribute to continuous improvement
- Present data products to stakeholders and gather feedback for iterations
- Own complex data problems from root cause analysis to production-ready solutions
- Conduct regular performance audits on pipelines, databases, and dashboards and implement optimizations
Requirements
- 5+ years of hands-on experience in a Data Engineering role
- Strong proficiency in SQL, Python, dbt, and Airflow
- Extensive experience with PostgreSQL or similar relational databases (MySQL, Oracle)
- Familiarity with Superset, PowerBI, or Tableau
- Solid understanding of software engineering principles: modular code design, testing, version control (Git)
- Ability to think critically and solve complex problems independently
- Excellent communication skills for technical and non-technical audiences
- Experience working in an agile development environment
- Experience mentoring junior engineers and promoting best practices
- Bonus: Experience with Ruby
- Bonus: Experience in nonprofit or fundraising technology sector
- Bonus: Experience with SaaS