MissionWired is looking for a Data Engineer to structure client data for effective and efficient querying and advanced segmentation to support fundraising strategies for nonprofits and Democratic organizations.
Requirements
- Experience with and advanced knowledge of SQL;
- Ability to build and optimize data pipelines, architectures, and data sets;
- Experience with Civis or similar data warehouse systems;
- Experience with DBT;
- Knowledge of Python;
Responsibilities
- Building SQL pipelines to extract, transform, and load data sets from a variety of internal and external data sources;
- Working in client systems such as Salesforce and Civis;
- Creating SQL queries against data tables to enable advanced segmentation for direct mail campaigns;
- Structuring data to enable effective and efficient querying and segmentation;
- Assembling large and complex data sets that meet project needs;
- Using an array of technological languages and tools to connect systems and move data;
- Working toward constantly improving data reliability and quality;
Other
- 2+ years of professional experience;
- Attention to detail;
- Curiosity to innovate on ways to solve data management issues;
- Passion, energy, and excitement for progressive and philanthropic causes.
- Experience working with cross-functional teams in a dynamic environment.
