Business Intelligence Analyst Associate, Reporting and Analytics

Department: Alumni Relations & Development
Salary/Grade: EXS/6

Target hiring range for this position will be between $63,000-$70,000 per year. Offered salary will be determined by the applicant's education, experience, knowledge, skills and abilities, as well as internal equity and alignment with market data.

Job Summary:

This role supports reporting and analytical needs across the Alumni Relations and Development organization. This job function focuses on developing, maintaining, and enhancing reports and dashboards using fundraising and advancement data, with an emphasis on Oracle SQL and structured reporting workflows. The position requires intermediate SQL knowledge and the ability to troubleshoot data and reporting issues with guidance from senior team members as needed. The team member will work closely with stakeholders to understand reporting requirements, ensure data accuracy, and support both ad-hoc and recurring reporting needs, while also contributing to documentation and self-service enablement efforts. Exposure to Salesforce reporting and CRM Analytics is preferred, with additional familiarity in tools such as Tableau and Cognos considered a plus.

Please note: The target budgeted salary for this position is $63,000 - $70,000 annually. Offers will be based on candidate experience and education, as well as equity within Northwestern University.

Please note: This role is eligible for a hybrid work arrangement, up to two days remote and three onsite.

*Note: Not all aspects of the job are covered by this job description.

Specific Responsibilities:

• Develop and maintain reports and dashboards using various tools and methods
• Understand reporting needs of customers and document requirements as necessary
• Provide timely ad-hoc support to customer requests
• Become familiar with data models (CRM and data warehouse)
• Create functional or technical documentation on reports and processes as needed
• Promote self-service reporting and training amongst organization
• Collaborate with central IT team as needed for particular data and reporting processes

Miscellaneous

Performs other duties as assigned.

Minimum Qualifications (Education, Experience, Certifications, Skills)

• Bachelor's degree
• 1+ years of experience with SQL
• 6+ months experience with Tableau or Cognos

Preferred Qualifications (Education, Experience, Certifications, Skills)

• 6+ months experience with salesforce lightning reports or crm analytics
• Experience working in advancement operations, supporting fundraising
• Familiarity with an advancement crm

Minimum Competencies

Analytical Thinking & Data Problem Solving

• Ability to translate business questions into structured data queries and reports; apply SQL to extract and analyze data; and identify and resolve data inconsistencies in a methodical way.

Stakeholder Communication & Requirements Gathering

• Ability to engage stakeholders to understand reporting needs, ask clarifying questions, document requirements, and communicate data insights clearly to technical and non-technical audiences.

Data Accuracy & Process Discipline

• Strong attention to detail in validating report outputs, maintaining documentation, and supporting consistent, reliable reporting workflows.

Benefits:
At Northwestern, we are proud to provide meaningful, competitive, high-quality health care plans, retirement benefits, tuition discounts and more! Visit us at https://www.northwestern.edu/hr/benefits/index.html to learn more.

Work-Life and Wellness:
Northwestern offers comprehensive programs and services to help you and your family navigate life's challenges and opportunities, and adopt and maintain healthy lifestyles.
We support flexible work arrangements where possible and programs to help you locate and pay for quality, affordable childcare and senior/adult care. Visit us at https://www.northwestern.edu/hr/benefits/work-life/index.html to learn more.

Professional Growth & Development:
Northwestern supports employee career development in all circumstances whether your workspace is on campus or at home. If you're interested in developing your professional potential or continuing your formal education, we offer a variety of tools and resources. Visit us at https://www.northwestern.edu/hr/learning/index.html to learn more.

Northwestern University is an Equal Opportunity Employer and does not discriminate on the basis of protected characteristics, including disability and veteran status. View Northwestern's non-discrimination statement. Job applicants who wish to request an accommodation in the application or hiring process should contact the Office of Civil Rights and Title IX Compliance. View additional information on the accommodations process.