Virtuous is looking to hire a Senior Data Engineer to develop, manage, and optimize data infrastructure that drives strategic decision-making for mid-sized charities. The goal is to enable efficient data collection, transformation, and storage to support fundraising, marketing, volunteerism, and online giving through data-driven insights.
Requirements
- 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 familiarity with cleaning, structuring, and aggregating the raw data to make it useful for analysis and reporting (e.g. DBT)
- 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
- Experience with AI or predictive models
- Knowledge of advanced statistical methods and data science techniques.
- Experience with cloud platforms such as AWS, Azure, or GCP.
Responsibilities
- Support the design, development, and maintenance of our enterprise data warehouse and ETL/ELT pipelines.
- Architect and implement data solutions that support a wide range of reporting, insights, analytics, and fundraising needs, including donor segmentation, campaign attribution, and predictive modeling.
- Support in building and managing robust, scalable data pipelines from various internal and external sources (e.g., CRM, third-party data sets) into our data warehouse.
- Ensure data integrity, reliability, and security.
- Troubleshoot and resolve data-related issues to ensure a single source of truth for key metrics.
- Conduct exploratory data analysis to undercover trends and insights.
- Build and manage comprehensive reports and dashboards.
Other
- Experience in the nonprofit sector or with donor/constituent relationship management (CRM) systems (e.g., Virtuous, Salesforce NPSP, Blackbaud, HubSpot, EveryAction).
- Familiarity with business intelligence tools (e.g., Sigma,Tableau, Power BI, Looker).
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration abilities.
- Detail-oriented and able to manage multiple tasks and projects simultaneously.
