Senior Data Engineer, Virtuous

• Asking questions with a spirit of curiosity
• Giving feedback freely with candor & grace, welcoming it in return
• Displaying a passion for philanthropy and technology
• Serving with joy. Everyone is willing to make the coffee!
• Celebrating the wins & milestones of others
• Assuming good intent & demonstrating trust in others
• Pursuing relationships with people different from themselves & creates space to be human
• This role requires a blend of technical expertise, strategic thinking, and a deep understanding of data's role in a nonprofit context
• The ideal candidate is someone who thrives in a fast-paced environment, is passionate about data, and possesses a strong technical background
• You will also have extensive experience in building, maintaining and optimizing data pipelines and architectures, particularly within an environment that supports sophisticated fundraising and marketing operations
• 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)
• 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)
• 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

Desirable

• We are seeking a highly skilled and detail-oriented Senior Data Engineer to join our product engineering team
• In this role, you will be responsible for developing, managing, and optimizing data infrastructure that drives strategic decision-making
• You will be responsible for implementing scalable data pipelines that enable efficient data collection, transformation, and storage across environments
• Utilizing technologies such as SQL and Python to ensure seamless data flow and accessibility for analytics, reporting, and machine learning applications
• Your expertise in ETL processes, data warehousing and tools like Snowflake and DBT and a familiarity with .NET will be critical for maintaining data integrity and availability
• You will collaborate closely with a cross-functional team, including product management, engineering, and data operations, to ensure data accuracy and efficiency
• This position offers a unique opportunity to contribute to meaningful projects and support our mission through data-driven insights
• Data Architecture & Strategy: 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
• Data Pipeline Development: 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
• Data Quality: Troubleshoot and resolve data-related issues to ensure a single source of truth for key metrics
• Data Reporting & Visualization: Conduct exploratory data analysis to undercover trends and insights. Build and manage comprehensive reports and dashboards
• Collaboration: Partner closely with product managers, designers, software engineers, ML engineers, data scientists, and business stakeholders to understand their data requirements and deliver solutions that empower their work. Translate business needs into technical specifications