Job ID: 2023-17198 Type: Full-Time # of Openings: 1 Category: Financial Services and Procurement
The Business Intelligence Manager leverages data and turns it into actionable insights that enable the Engineering and Campus Energy group and the Office of Sustainability to solve problems. The Manager will also effectively communicate this information to department staff and key stakeholders.
This position shall create reports, visualizations and dashboards that allow the department staff to effectively use data to:
Manage and reduce university energy use
Efficiently operateenergy plants, geoexchange, and distribution systems.
Monitor city water usage for compliance to meet our obligations for the OIW water rate.
The Business Intelligence Manager will be expected to know what data needs to be communicated, how to collect, process, prepare, and develop visualizations and reports. Additionally, the Manager must search out new applications for data analytics within the department that are not presently known that have the possibility of improving operations and decision making.
This position regularly collaborates and shares data with OIT, plant personnel, engineering personnel, FF&T, sustainability, outside vendors, faculty, and students.
Review current data used in the department.
Research the department operations for important analytics that are not currently leveraged.
Identify and suggest key performance indicators (KPIs) useful for department operations.
Develop analytics management plan, review with leadership, and lead the implementation
Develop visualizations, dashboards, and reports for the Engineering and Campus Energy group and the Sustainability Office.
Automate data collection and preparation
Ensure that the data sets are accurate and clean
Serve as an administrator for Princetonâ™s energy portal (front end and underlying system). Develop expertise in the system and configure it to meet the goals of Princetonâ™s Office of Sustainability.
Extract value from EnergyCAP, the universityâ™s new utility bill management system by performing analysis of data.
Support other sustainability-related content development for the offices using data.
Fulfill faculty/student/staff requests for energy data.
Ensure that all the reporting software is backed up.
Stay current on data analytic techniques and software
Partner with Princetonâ™s Center for Data, Analytics and Reporting (CeDAR) to gather requirements for an integrated information warehouse dataset for reporting
Current data reporting: Monthly energy reports for plant and campus;Annual energy reports;Building energy use anomaly reports;Sustainability metric reports; ad-hoc reports.
Future Reports: Plant efficiency reports; Distribution efficiency reports; Yearly Major Maintenance budgets and spend rate; Plant maintenance labor hours per month; Equipment downtime; Bore field temperature trend reports; Plant annual cost tracing for various spend categories.
This position must embody the core values essential to the Facilities Organization: teamwork, innovation, integrity, inclusiveness, respect, and sustainability.
Bachelorâ™s degree in data analytics, finance, accounting, engineering, statistics, computer science, or another analytical discipline
Understand data security issues associated analytics.
Demonstrate excellent, clear written and verbal communication skills including the ability to convey complex technical concepts to non-technical persons.
Strong interpersonal skills
Expert skills in Microsoft Excel are required, including the use of advanced analytical functions, pivot tables, PowerPivot, and the ability to work with connected databases.
Experience gathering requirements, turning them into specifications, and delivering analytic products.
Advanced knowledge of Tableau or similar data visualization tools
Ability to leverage APIâ™s for consuming data assets
Experience creating and executing SQL scripts.
Minimum three (3) years relevant experience in data analytics.
Ability to manage multiple projects simultaneously.
Ability to establish and maintain effective work relationships and to build partnerships.
Ability to manage projects.
Certified LEED Professional or Certified Energy Manager
Experience applying AI to energy systems management.
Experience with the EnergyCap program.
Five (5)+ years relevant experience.
Knowledge of sustainability concepts and best practices in higher education, such as environmental and sustainability science, curricular integration, systems thinking, and climate action planning.
Ability to develop Machine Learning models using data and apply them to operational improvements
Princeton University is an Equal Opportunity/Affirmative Action 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. KNOW YOUR RIGHTS
Princeton University is a vibrant community of scholarship and learning that stands in the nation's service and in the service of all nations. Chartered in 1746, Princeton is the fourth-oldest college in the United States. Princeton is an independent, coeducational, nondenominational institution that provides undergraduate and graduate instruction in the humanities, social sciences, natural sciences and engineering.As a world-renowned research university, Princeton seeks to achieve the highest levels of distinction in the discovery and transmission of knowledge and understanding. At the same time, Princeton is distinctive among research universities in its commitment to undergraduate teaching.Today, more than 1,100 faculty members instruct approximately 5,200 undergraduate students and 2,600 graduate students. The University's generous financial aid program ensures that talented students from all economic backgrounds can afford a Princeton education.