Data Services Manager

Successful candidates will be responsible for:

• Developing custom SQL scripts, based on agency supplied marketing segmentation plans, within client owned data warehouses (Civis Platform, SQL Server, BigQuery, etc.);
• Creating the applicable reporting required by the internal account team, and/or client, based on the data captured in the marketing segmentation plan;
• Extracting final data segments, as CSV files, from the data warehouse and post them to the applicable file transfer system;
• Creating marketing campaigns, efforts, source codes, segments, packages, and panels within the client’s CRM;
• Ingesting datasets into the client’s CRM using built-in CRM tools, 3rd party ingestion tools and/or data warehouse connectors;
• Batching new fundraising gifts into the client’s CRM;
• Monitoring and maintaining the client’s warehouse ETL/ELT processes;
• Extracting data directly from the client’s CRM;
• Creating and maintaining automation workflows/processes within data warehouse platforms;
• Building custom integrations to ingest/extract data to/from different systems. I.e. Build a custom Python script that opens a SFTP connection, extracts a CSV file, converts the binary data into a dataframe and ingests the dataframe into a data warehouse table;
• Setting up version control in GitHub; and
• Creating and/or making updates to analytical dashboards, such as Tableau.

Must-have qualifications:

• 5+ years of experience developing tables, views, functions and scripts within data warehouse systems such as Civis Platform (Redshift), SQL Server, MySQL or BigQuery;
• 3+ years of advanced reading, writing and updating SQL statements in one of the following languages SQL Server, PostgreSQL, MySQL or BigQuery;
• 2+ years of experience in one or more fundraising CRM platforms such as Salesforce NPSP, Blackbaud CRM, NGP, EveryAction or Raiser’s Edge is highly preferred;
• 2+ years of experience working with fundraising direct marketing data is strongly preferred;
• Proven experience managing data conversion, manipulation, cleansing, standardization, and reporting;
• Strong interpersonal skills;
• Excellent client services skills;
• Ability to be a team player, ready and able to dig in, as well as delegate effectively;
• Comfortability working independently as well as within and across teams;
• Impeccable ethical standards and professional presence;
• Excellent organizational skills, attention to detail and ability to manage and prioritize short and long term goals; and
• Highly self-motivated and always looking for opportunities to make things better. 

Nice-to-have qualifications:

• 2+ years of experience developing/managing data ETL/ELT in a modern data warehouse;
• Experience reading and writing JavaScript and/or Python;
• Experience creating, updating and maintaining dashboards in Tableau, Klipfolio or PowerBI;
• Experience using version control tools, such as GitHub or BitBucket; and
• Experience at a marketing agency.