Business Intelligence Analyst Senior

Apply Now

How to Apply

A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.

Summary

As part of the Energy Management (EM) team, a subset of the Office of Campus Sustainability (OCS), the Business Intelligence Analyst Senior (BI Analyst) will create and maintain a robust data infrastructure and reporting tools to support the daily work of the EM team for energy management decision making, as well as other projects across all OCS focus areas.  Various data sets are available to the team including daily consumption of utilities at the meter level, daily weather data, and calculated baselines for each meter. Comparing daily performance to the baseline model will allow the EM staff to identify building energy conservation opportunities. The EM effort is focused on building optimization to reduce energy consumption, contain costs, and reduce greenhouse gas emissions tied to institutional sustainability goals. Future projects and focus will expand to cover other areas of focus within the OCS, including but not limited to full spectrum carbon emissions (including scope 3 emissions), recycling, composting, and others. The position will report directly to the Manager of EM.

Mission Statement

The mission of the University of Michigan is to serve the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic values, and in developing leaders and citizens who will challenge the present and enrich the future.

Who We Are

Facilities and Operations (F&O) has primary responsibility for the stewardship of the university's physical properties, including nearly 36 million square feet of building space.  We are responsible for supporting sophisticated and complex academic, research and clinical facilities, as well as environmental stewardship and regulatory compliance.  We optimize our resources to support the university's commitment to academic excellence and cost containment. The Office of Campus Sustainability (OCS) is responsible for driving institutional sustainability efforts throughout operations, research, and healthcare. 

Why Work at Michigan?

Being part of something greater, of serving a larger mission of discovery and care — that's the heart of what drives people to work at Michigan. In some way, great or small, every person here helps to advance this world-class institution. It's adding a purpose to your profession. Work at Michigan and become a victor for the greater good.

The University of Michigan, with an operating budget of over $7 billion, is a leader in higher education. In addition to a career filled with purpose and opportunity, the University of Michigan offers a comprehensive benefits package to help you stay well, protect yourself and your family, and plan for a secure future. Benefits include:

  • Generous time off
  • A retirement plan that provides two-for-one matching contributions with immediate vesting
  • Many choices for comprehensive health insurance
  • Life insurance
  • Long-term disability coverage
  • Paid maternal and parental leave
  • Flexible spending accounts for healthcare and dependent care expenses

Responsibilities*

  • Develop and present reports and definitions, graphs, dashboards and portal interfaces used by OCS teams and leadership, including coordinated effort with other F&O departments
  • Manage requests to fix and update existing reports, answer report/data related questions, help team members with documentation
  • Gather requirements and engage with stakeholders to help design and format front-end Tableau reports
  • Ensure data is accurate and data displays according to requirements provided
  • Responsible for documentation of processes to build and maintain reports
  • Help define criteria for metrics and understand where data is sourced
  • Support data entry and management of GIS efforts across OCS
  • Manage cross functional unit projects and/or teams which include project planning, task management, status reporting, etc.
  • Support faculty and student-driven projects related to energy conservation and the reduction of carbon emissions

Required Qualifications*

  • Bachelor’s Degree in a quantitative field like business, computer science, informatics, engineering, biostatistics, public health, economics
  • A minimum of 5 years of experience supporting organization creating and maintaining data infrastructure and reporting tools
  • Organizational skills, written, and verbal skills 
  • Strong problem solving and analytical skills
  • Strong team player with the ability to take initiative and work well independently
  • Adaptable and quick learner, willingness to acquire and develop new skills as needed
  • Adaptability and flexibility to adjust to fluctuating changes in project needs
  • Passion for delivering compelling solutions that exceed customer expectations
  • Demonstrated proficiency with current computer technology and applications (i.e. Tableau, Google Docs, Microsoft Office Suite, work management interface, etc.)
  • Ability to construct simple to moderate SQL statements to query and access data in various RDBMS such as Oracle, SQLServer, MySQL 
  • Experience creating reports and dashboards in Tableau
  • Ability to travel frequently between sites across the U-M Ann Arbor campus
  • Ability to work autonomously and make self-directed decisions about priorities and work

Desired Qualifications*

  • Ability to use query tools to obtain data from data sources
  • Experience using programming language such as Python
  • Experience working with a diverse population at all levels, including bargained for and non-bargained for staff, faculty, and students
  • Interpersonal skills
  • Experience with digital building control technology and building automation systems (BAS)
  • Knowledge of building heating, ventilation, air conditioning, electrical, and water systems
  • Experience working in research laboratory facilities and with associated building systems is highly desired
  • Passion for energy conservation and waste reduction activities or environmental action
  • Experience in a higher education, public service, or a non-profit organization is highly desired
  • Demonstrated proficiency with AiM software (work management interface)

Work Schedule

Work schedule is primarily regular business hours, however, the candidate must be able to adjust their schedule for occasional after hours work-related duties. 

Work Locations

This position may be eligible for remote and/or flexible work opportunities, to include both on-site and remote work. Candidates must live or be able to relocate within a reasonable communiting distance form Ann Arbor. Flexible work agreements are reviewed annually and are subject to change dependent on the business needs of the hiring department, throughout the course of employment.

Additional Information

F&O is a positive organization dedicated to the principles of being respectful, collaborative, solutions-based, and proactive.

The Office of Campus Sustainability seeks to recruit and retain a diverse workforce as a reflection of our commitment to serve the diverse people of Michigan, to sustain the excellence of the university, and to offer our students richly varied disciplines, perspectives and ways of knowing and learning.  

To learn more about The Office of Campus Sustainability and our work on campus, please visit our website at www.ocs.umich.edu.

Note: Candidates for this position must be legally authorized to work in the United States. Visa sponsorship is not available for this position.

U-M EEO/AA Statement

The University of Michigan is an equal opportunity/affirmative action employer.

U-M COVID-19 Vaccination Policy

COVID-19 vaccinations are now required for all University of Michigan students, faculty and staff across all three campuses, including Michigan Medicine.  This includes those working or learning remotely.  More information on this policy is available on the Campus Blueprint website or the U-M Dearborn and U-M Flint websites.