Marketing Data Analyst

Data Analyst About You

You are naturally self-directed and goal setting. Data is second nature to you; how it can be used is what you dream about. You recognize that communication is key to stakeholders (Frontier and our clients) understanding data’s value, and you thrive in a collaborative environment. You can operate with little top-down instruction and are ok with engaging in repetitive tasks, but more importantly you are motivated by that repetitiveness to work on optimizing, eliminating, or automating those tasks so that everyone can move on to increasing strategic work. You seek a dynamic balance between productivity and precision, using your flexibility to achieve greater ends.

About Us

Frontier (by Societ) is a marketing agency that helps charities elevate their donor support. We work exclusively with charities, all across Canada. Our strategic focus is in effective and efficient integrated marketing.

The Gig

You’ll work with Frontier’ s data and our strategy team in fulfilling the fundraising data requirements for our clients (with a view towards also engaging with the online and social media aspects of fundraising data as well), and producing meaningful numerical summaries of our fundraising campaigns’ performance.

Major Responsibilities

• Sort and segment mailing list data for all fundraising appeals for clients
  • Example data operations on an ongoing basis for clients:
    • Grouping hundreds of thousands of individual donations by donor.
    • Assigning a value to each donor based on: recency, frequency, and amount - grouping donors accordingly.
    • Deduplicating donors based on varied criteria (alternative address spellings, donors who have moved, etc).
  • Building, maintaining and enhancing segmentation processes for frontier product offerings
• Integrate other types of data and giving:
  • Integrate client online giving with offline giving data to inform future mailings and digital strategy.
  • Source alternative data sources in order to identify new avenues to engage with donors in a data-driven way.
• Provide regular reporting on overall giving for clients for both internal and external use.
• Extracts trends using automated analysis in order to inform donor strategy
• Bring further automation to our regular processes and mailing list generation.
• Brings a sense of ownership and drive to optimize existing processes and identify ways to better utilize existing data streams.
• Requesting and reviewing data from clients. Reformatting when necessary, and communicating with them to receive a consistent format.
• Analyze client donor bases to recommend volume changes
• Support strategists with acquisition targeting
• For clients who are not able to access their own CRMs, directly pull/put together mailing lists.
• Support with KPI analysis
• Support with forecasting analysis
• Support with fundraising trends & determining/creating benchmarks
• Creating new ways to leverage data for fundraising success

The Must Haves

• Strong attention to detail and flexibility in when to apply that attention
• Mid-to-high level proficiency in Python programming (or similar).
• Experience and with version control systems (e.g. Github)
• Strong in Excel/Google Sheets, including common and higher level functions.
• Some level of practical statistics (e.g. choosing sample sizes, inferential statistics such as t-test and Chi-square, avoiding pitfalls with descriptive statistics and experimental design).
• Enjoys goal-oriented, self-directed projects.

The Nice to Haves

• Experience working with nonprofits or charities.
• Experience with data visualization
• Experience with JavaScript/Google App Script
• Understanding of online tools like Slack, Google Apps, etc.

Benefits

• 3 weeks vacation
• Paid Canadian holidays off
• 6 paid sick days and 2 paid personal days
• Opportunities for professional development