Associate Director, Business Intelligence

Associate Director, Business Intelligence

Department

Adv-Data & Analytics

Category

Information Technology

Job Type

Full-Time

Overview

Reporting to the Director of Data & Analytics, the Associate Director, Business Intelligence is responsible for directing and producing time-sensitive reporting and analytical needs, addressing business questions through dynamic and thoughtful business intelligence and contributing to the effectiveness and efficiency of the daily operations University Advancement. The department of Data & Analytics plays a critical strategic role within Advancement, providing the analytical framework, data architecture, application development and tools for data-driven decision making at all levels of the organization. This position is a hands-on technical role.

In addition to supervising Business Intelligence Analysts, this position will report to the Director of Data & Analytics and serves as a liaison to other senior members of Advancement; participates in strategic policy development, and works to successfully execute special projects in support of the Advancement enterprise.

This is a hybrid role in Princeton, NJ.

Responsibilities

Data reporting & visualization:
• Develop business intelligence and analytic solutions. Use data visualization software (Salesforce Lightning, CRM-A & Tableau) and predictive modeling tools (such as R or SAS) to analyze and communicate complex data and information clearly and efficiently to users.
• Conduct high quality data analysis; analyzing, interpreting and synthesizing information; and preparing the presentation of data to support analytics, prospect research, prospect management and the strategic decision making of the Office.
• Develop and maintain proficiency in using advanced analytic and database tools, internet resources, in-house data, and other references.
• Ensure a consistent look and feel, quality assurance and best practices among analysts’ products in alignment with business needs.

Team and Project management:
• Recruit, mentor and direct the development of business intelligence analysts: including setting performance standards and measures; providing appropriate levels of training, mentoring and professional development; and fostering a strong sense of teamwork and cross-functional communication and collaboration among direct reports, the DS&I staff and with other groups within Advancement and the University.
• Oversee project management for business intelligence projects and initiatives. Collaborate with the Data & Analytics Director to determine strategy, priorities and assignments for departmental efforts. Interact with Advancement staff to initiate and execute requests.
• Working with the Data & Analytics Director and as a liaison to provide an effective and efficient business intelligence structure and environment for University Advancement. Review and recommend use of new technologies, vendor services and information sources, keeping abreast of news and relevant industry trends.

Team & business user collaboration:
• Working closely with data warehousing team members, conceive of and contribute to strategies and best practices in maintaining a comprehensive, reliable, and innovative data environment.
• Work with business users to define desired outcomes and business requirements of analyses and dashboards; Conduct end user training in BI tools as needed.
• Identify critical process improvement areas for the Office and collaborate in developing procedures and solutions for enhancing a high level of customer service.

Ad-hoc projects and data quality:
• Ensure data quality by identifying and communicating appropriate changes and updates to the Alumni and Donor Records department.
• Participate in department projects and initiatives; assist with special projects as required, meeting project deadlines.

Qualifications

Essential Qualifications:

• 5+ years of professional experience required in an analytical or information specialist role within an academic, nonprofit, corporate or consulting setting.
• Experience in designing business intelligence solutions using Salesforce (Lightning, CRM-A, Tableau) required. Aptitudes toward bringing together the art and science of data visualization in order to uncover trends, realize insights, explore sources, and tell stories. Analytical acumen necessary to interpret and manage data.
  • Experience with statistical programs, data mining, and comprehensive analysis required.
  • Prior business or technical staff management experience in delegating, planning and mentoring to ensure staff meet and exceed expectations. Management of staff or high level project management required.
  • Proficiency at planning and setting meaningful objectives to meet office goals. Ability to articulate and promote goals and implement strategic plans.
  • Strong interpersonal skills; as well as strong initiative and self-motivation and the ability to work both independently and manage teams within a customer-service oriented environment.
  • Excellent written/oral/interpersonal communication skills in order to: identify and articulate business challenges, project objectives, and analytical approach.
  • Organizational skills to handle several projects simultaneously, accommodate shifting priorities, and meet deadlines.
  • Understanding of cloud data warehousing and experience with ETL tools (such as Matillion and Snowflake) a plus.
  • Experience with relational databases and data extraction tools (such as SQL) as plus.
  • Advanced proficiency in the Microsoft Office, in particular thorough knowledge of Excel and PowerPoint.
  • Ability to maintain strict confidentiality and handle sensitive information and material in a discretionary manner.
  • Commitment to University Advancement’s mission to inform, involve, and inspire the global community of alumni and friends, and adhering to its guiding principles of High Performance, Innovation, Civility, and Collaboration.
  • Demonstrated ability to work effectively and build relationships with individuals from diverse backgrounds, identities, abilities, and experiences.
• Bachelor's degree is required.

Preferred Qualifications:

• Advanced degree preferred
  • Understanding of philanthropy (mission, practice, trends) and fundraising practices (the development cycle, prospect management policies and practices and engagement) preferred.
  • Knowledge of and commitment to the values and mission and higher education and the goals and guiding principles of the Office of Development a plus.
  • Sense of humor is a plus.

We are an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability status, protected veteran status, or any other characteristic protected by law.

The University considers factors such as (but not limited to) scope and responsibilities of the position, candidate's qualifications, work experience, education/training, key skills, market, collective bargaining agreements as applicable, and organizational considerations when extending an offer. The posted salary range represents the University's good faith and reasonable estimate for a full-time position; salaries for part-time positions are pro-rated accordingly.

If the salary range on the posted position shows an hourly rate, this is the baseline; the actual hourly rate may be higher, depending on the position and factors listed above.

The University also offers a comprehensive benefit program to eligible employees. Please see this link for more information.

Standard Weekly Hours

36.25

Eligible for Overtime

No

Benefits Eligible

Yes

Probationary Period

180 days

Essential Services Personnel (see policy for detail)

No

Physical Capacity Exam Required

No

Valid Driver’s License Required

No

Experience Level

Director

#Ll-DP1

Salary Range

$136,000 to $150,000