In A Nutshell
Structure client’s data, enabling effective and efficient querying and advanced segmentation.
Responsibilities
- Building SQL pipelines to extract, transform, and load data sets from a variety of internal and external data sources;
- Architecting data systems;
- Working in client systems such as Salesforce and Civis and transferring data between them;
- 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;
- Joining each and every one of your colleagues in creating an inclusive workspace; and
- Collaborating with cross-functional teams to support their data infrastructure needs.
Skillset
- 4+ years of professional experience;
- Experience with and advanced knowledge of SQL;
- Experience with Civis or similar data warehouse systems;
- Ability to build and optimize data pipelines, architectures, and data sets;
- Attention to detail;
- Curiosity to innovate on ways to solve data management issues; and
- Passion, energy, and excitement for progressive and philanthropic causes.