Job Details

This ad is expired.

BI Analyst
Go to our website »

Position Number: 1867555
Location: Ann Arbor, MI
Position Type: Computer and Information Technology

BI Analyst

Job Opening ID: 185485
Work Location: Ann Arbor Campus
Ann Arbor, MI
Full Time/Part Time: Full-Time
Regular/Temporary: Regular
FLSA Status: Exempt
Organizational Group: Fo Sustainability
Department: F&O Sustainability
Posting Begin/End Date: 3/11/2020 4/08/2020
Salary: $65,000.00 $80,000.00
Paid Time Off:
Career Interest: Information Technology
Engineering & Architecture
Administration
Environmental Safety & Security

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.

Job Summary
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. This position is a part of the Energy Management (EM) team, a subset of the OCS.

The 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 Energy Management effort is focused on building optimization to reduce energy consumption, contain costs, and reduce greenhouse gas emissions tied to institutional sustainability goals. The position will report directly to the Manager of Energy Management.

NOTE: This is a three year term-limited position.

Mission Statement
Facilities and Operations 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.

Responsibilities*

Develop, maintain, and improve dashboards and reports used by OCS teams and leadership, including coordinated effort with other F&O departments
Manage ad-hoc requests to fix and update existing reports, answer report/data related questions, helping 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
Support faculty and student-driven projects related to energy conservation

Required Qualifications*

Bachelor's degree in a related field or equivalent combination of education and experience
A minimum of 3 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, candidate must be able to adjust their schedule for occasional after hours work-related duties.

Additional Information
The University of Michigan, with an operating budget of over $7 billion, is a leader in higher education. We offer our employees an extensive total compensation package including competitive pay, a two-for-one retirement contribution, a variety of health insurance options, and a generous vacation plan. In addition, there are seven paid holidays and four paid season days.

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

Background Screening
The University of Michigan conducts background checks on all job candidates upon acceptance of a contingent offer and may use a third party administrator to conduct background checks. Background checks are performed in compliance with the Fair Credit Reporting Act.

Application Deadline
Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.

U-M EEO/AA Statement
The University of Michigan is an equal opportunity/affirmative action employer.

To apply, visit https://careers.umich.edu/job_detail/185485/bi_analyst