CareerPlan

Lead Analyst, Advancement Data

Chicago, IL, USFull-time2026-10-29 → 2026-11-09

Core

Lead data analyst and business analyst responsible for designing data models, building data pipelines, and translating business needs into technical requirements for a university's fundraising and engagement systems.

Role type

Senior IC data analyst (business analysis & data architecture)

Builds

CRM, data warehouse, and connected platforms for alumni and donor engagement

Domain

Higher education / Non-profit fundraising

Required skills

Data modeling, SQL, ETL/ELT, system architecture, requirements gathering, stakeholder management, technical documentation, process improvement, root cause analysis, solution design

Preferred skills

Project management, enterprise data integration, AI/ML evaluation, Salesforce (Phoenix) experience, management information systems knowledge

Technologies

Salesforce (Phoenix), Data Warehouse, ETL/ELT tools, Microsoft Windows

Responsibilities

Design and maintain logical and physical data models; develop scalable data pipelines and integration frameworks; translate business needs into technical requirements; troubleshoot complex data and system issues; mentor team members on technical practices; document system architecture and governance; evaluate opportunities for AI and emerging technologies.

Seniority

Senior, hands-on IC with mentorship responsibilities