Senior Data Engineer

Expert-level experience with SQL server and data modeling in a cloud data warehouse, such as Snowflake. Ability to create ETL tools and optimize big data sets, including cleaning, structuring, and aggregating raw data. Familiarity with DBT. Experience in the nonprofit sector or with donor/constituent relationship management (CRM) systems. Familiarity with business intelligence tools (e.g., Sigma, Tableau, Power BI, Looker). Knowledge of event-driven architecture and streaming data technologies (e.g., Kafka). Knowledge of python and/or the ability to easily pull data from APIs. Strong analytical and problem-solving skills. Excellent communication and collaboration abilities. Detail-oriented and able to manage multiple tasks and projects simultaneously. Experience working with nonprofits or a strong desire to support nonprofit initiatives. A curious and analytically-minded approach to data analysis.

Support the design, development, and maintenance of enterprise data warehouse and ETL/ELT pipelines. Architect and implement data solutions for reporting, insights, analytics, and fundraising needs. Build and manage scalable data pipelines from various sources into the data warehouse. Ensure data integrity, reliability, and security. Troubleshoot and resolve data-related issues. Conduct exploratory data analysis to uncover trends and insights. Build and manage comprehensive reports and dashboards. Partner with product managers, engineers, and stakeholders to understand data requirements and deliver solutions. Translate business needs into technical specifications.