Business Intelligence Analyst

Princeton University; Princeton (NJ); Hybrid; USD 97,000 - 108,000; Full time

Job summary

Princeton University is seeking a Business Intelligence Analyst for the Data & Analytics team within the Data Strategy & Innovation department in Princeton, NJ. The role emphasizes complex data analysis and dashboard development to support Advancement Office decision making.

You will collaborate with data teams, leveraging Salesforce CRMA, Tableau, SQL and Python to deliver actionable insights and reports to donors, volunteers and campus partners.

Qualifications

• Bachelor's degree required.
• 3+ years of professional experience in analytical/research/information roles.
• Experience with data reporting, visualization and analytic tools.

Responsibilities

• Develop BI and analytic solutions to draw actionable insights from data, including Salesforce data visualization.
• Maintain proficiency with enterprise reporting tools (Salesforce CRMA, Tableau), SQL and Python.
• Prepare clear, concise reports with attention to accuracy and detail.
• Work with data warehousing teams to define reporting and analytics requirements and train end users.

Skills

Salesforce Lightning Reports

Salesforce CRM-A

Tableau

Education

Bachelor's degree

Tools

SQL

Python

Microsoft Office

Job description

Overview

The Business Intelligence Analyst is a member of the Data & Analytics team within the department of Data Strategy & Innovation. Data Strategy & Innovation is dedicated to housing, managing, analyzing and disseminating information and data to inform Advancement Office strategy; foster strong relationships with donors, volunteers and campus partners; and promote effective integration. Reporting to the Associate Director, Business Intelligence, the Business Intelligence Analyst is responsible for complex and high-quality data analysis and presentation of data related to the advancement of Princeton University's Advancement office. Candidates must be able to initiate and manage projects related to the analysis of internal data, providing value-added critical-thinking using independent judgment, strategic thinking and problem-solving skills. This individual should be fluent in extracting, analyzing and preparing dashboards and reports of database information, statistics and financial figures.

This is a hybrid role in Princeton, NJ.

Responsibilities

Data reporting, Visualization & Analytics:

• Develop business intelligence and analytic solutions to draw actionable insights from data. Experience with Salesforce data visualization software to analyze and communicate complex data and information clearly and efficiently to end users.
• Develop and maintain proficiency with enterprise reporting and analytics tools (especially, Salesforce CRMA & Tableau), SQL and Python.
• 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.
• Utilize statistical methods to assist with strategic planning initiatives.
• Gain and maintain proficiency in the use of proprietary and internal databases and well as appropriate analytical tools.

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; understanding of data warehousing and experience with ETL tools is preferred.
• Work with business users to define reporting and analytics requirements; Conduct end user training in BI tools as needed.

Qualifications

Essential Qualifications:

• Proficiency in Salesforce Lightning Reports, Salesforce CRM-A, and Tableau.
• 3+ years of professional experience in an analytical, research or information specialist role within an academic, nonprofit, corporate or consulting setting.
• Excellent quantitative analysis skills, attention to detail and the ability to think strategically.
• Demonstrated ability to use technology to gather, interpret, organize and present data.
• Experience with database management, analysis, and database visualization and reporting tools.
• Ability to identify and articulate business challenges, project objectives, and analytical approach.
• Prepare clear, concise reports with attention to accuracy and detail.
• Knowledge of tools and techniques for collecting, synthesizing and analyzing data.
• Strong customer service orientation and the ability to interact effectively with diverse groups.
• Strong initiative, self-motivation and the ability to work both independently and in teams.
• Organizational skills to handle several projects simultaneously to accommodate shifting priorities and meet deadlines.
• Excellent written/oral/interpersonal communication skills.
• Proficiency with Microsoft Office suite.
• Ability to maintain strict confidentiality and handle sensitive information and material in a discretionary manner.
• High degree of professionalism, a positive 'can do' attitude and strong work ethic.
• Demonstrated ability to work effectively and collaboratively with others.
• Appreciation for the principles of fundraising.
• Commitment to University Advancement’s mission to inform, involve, and inspire Princeton’s global community of alumni and friends, and adhering to its guiding principles of High Performance, Innovation, Civility, and Collaboration.
• Bachelor's degree is required.

Preferred Qualifications:

• Knowledge of Princeton’s mission.
• Experience in Salesforce CRM-A, Tableau.
• Experience in higher education.
• Advanced degree / graduate education.
• Previous experience in a fundraising environment.

Princeton University is 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

Mid-Senior Level#Ll-DP1

Salary Range

$97,000 to $108,000