Senior Data Engineer

Job Summary / Overview

Our client is seeking a highly skilled and detail-oriented Senior Data Engineer to join their product engineering team. This role is responsible for designing, building, and optimizing scalable data infrastructure that enables strategic decision-making across the organization.

The ideal candidate will have deep expertise in data architecture, ETL/ELT processes, and cloud data warehousing, with hands-on experience using tools such as SQL, Python, Snowflake, and DBT. This individual will play a critical role in ensuring data integrity, accessibility, and performance while supporting analytics, reporting, and machine learning initiatives.

This position requires a blend of technical excellence, strategic thinking, and strong collaboration skills. The successful candidate will work cross-functionally with product, engineering, and data teams to deliver impactful data solutions in a mission-driven environment.

Key Responsibilities

Data Architecture & Strategy

• Design, develop, and maintain enterprise data warehouse solutions
• Architect and implement scalable ETL/ELT pipelines to support reporting, analytics, and operational use cases
• Build data models that enable insights across fundraising, marketing, and donor engagement efforts
• Support use cases such as donor segmentation, campaign attribution, and predictive analytics

Data Pipeline Development

• Build and manage robust, scalable data pipelines from internal and external data sources (e.g., CRM systems, third-party datasets)
• Ensure high levels of data integrity, reliability, and security across all pipelines
• Optimize data ingestion, transformation, and storage processes

Data Quality & Governance

• Monitor, troubleshoot, and resolve data-related issues to maintain a single source of truth
• Implement best practices for data validation, governance, and quality assurance
• Ensure consistency and accuracy of key business metrics

Data Reporting & Visualization

• Perform exploratory data analysis to identify trends, patterns, and insights
• Develop and maintain dashboards and reports for business stakeholders
• Enable data accessibility for analytics, reporting, and machine learning applications

Collaboration & Stakeholder Engagement

• Partner with product managers, engineers, data scientists, and business stakeholders to understand data requirements
• Translate business needs into scalable technical solutions
• Support cross-functional initiatives with data-driven insights and recommendations

Required Qualifications

• Expert-level experience with SQL Server and data modeling in cloud data warehouses (e.g., Snowflake)
• Strong experience building and optimizing ETL/ELT pipelines using tools such as DBT
• Proficiency in Python and/or experience working with APIs for data ingestion
• Experience working with large, complex datasets and transforming raw data into actionable insights
• Familiarity with business intelligence tools such as Tableau, Power BI, Looker, or similar platforms
• Understanding of event-driven architectures and streaming technologies (e.g., Kafka)
• Strong analytical, problem-solving, and critical thinking skills
• Excellent communication and collaboration abilities
• Highly detail-oriented with the ability to manage multiple projects simultaneously
• Experience working with CRM systems or data models related to customer or donor engagement
• Passion for or experience supporting nonprofit initiatives or mission-driven organizations

Preferred Qualifications

• Experience designing tools or frameworks that enable self-service analytics
• Exposure to AI, machine learning, or predictive modeling techniques
• Knowledge of advanced statistical methods and data science concepts
• Experience with cloud platforms such as AWS, Azure, or GCP
• Strong understanding of data governance frameworks and best practices
• Experience mentoring or guiding junior team members
• Advanced degree in Data Science, Computer Science, Statistics, or a related field

Additional Information

• This role offers the opportunity to work in a mission-driven environment focused on delivering impactful, data-driven solutions
• The position involves collaboration across cross-functional teams, including product, engineering, and data stakeholders
• The work environment emphasizes innovation, collaboration, and continuous improvement
• Candidates should be comfortable operating in a fast-paced setting with evolving priorities and high-impact projects
• The organization values curiosity, open communication, and a strong sense of ownership in delivering results