Data Engineer

At NextAfter, data analysis is a key part of the engine that powers results for the nonprofits that we serve. This position is responsible for working with data from a variety of disparate sources to get it into a format that can produce insights that lead to more donors and dollars for our clients.

The Data Engineer supports NextAfter’s efforts to identify and communicate insights obtained from the analysis of data in a way that is enlightening to both technical and non-technical people.

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Transforming raw tables from email marketing and advertising platforms into consistent views that allow for analysis across multiple systems
• Loading new client data into the data warehouse and producing quality control reports
• Tracking down data integrity issues and identifying potential solutions
• Blending multiple sources of data in a way to produce insights that could not be found in a single system 

Qualifications and Skills:

• Deep knowledge of data processing, ETL/ELT pipelines, and data normalization/enrichment utilizing SQL programming language. Experience with BigQuery or RedShift is a requirement.
• Experience working with financial and constituent data
• Proficiency in DBT for data transformation
• Experience integrating data into dashboards like Looker DataStudio, Tableau, or Qlik
• Knowledge of web analytics like Google Analytics, advertising data from platforms like Facebook, Google Ads, and Bing, and email marketing data from platforms like Hubspot and Mailchimp
• Proven experience managing projects and multiple competing priorities (consulting or agency experience is a plus)
• Demonstrably strong communication skills
• Strong passion to identify and solve real business problems using data
• Attention to detail
• Experience analyzing nonprofit donor data is a plus

Education and Experience

• Bachelor’s or Associate’s degree in Computer Science, Information Technology, or similar level of professional experience
• 3-5 years of experience in a related role

Salary Range: $90,000 to $110,000 annually