Business Intelligence Developer

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

The Business Intelligence Developer will be responsible for developing, maintaining, and enhancing analytical solutions that drive data-informed decision-making across F&O. This individual will utilize reporting tools such as Crystal Reports, Tableau, and BIRT to design, develop, and deploy advanced reporting solutions. The ideal candidate will also possess strong SQL skills to extract, transform, and analyze complex datasets, ensuring the accuracy and relevance of information delivered.

In this role, the Business Intelligence Developer will:

• Collaborate with stakeholders to understand reporting needs, translating requirements into effective and actionable business intelligence solutions.
• Design, create, and maintain a wide range of reports and dashboards that support operational and strategic decision-making.
• Write efficient and optimized SQL queries to extract data from various databases, ensuring accurate data representation.
• Perform advanced data analysis to identify trends, patterns, and insights that inform business decisions.
• Support data integrity by validating the accuracy and quality of data used in reports and dashboards.
• Train and support end-users to ensure effective use of BI tools and delivered solutions.
• Work with cross-functional teams to identify opportunities for process improvement through better data management and reporting.

Who We Are

Facilities and Operations (F&O) is primarily responsible for stewardship of the university's physical properties, including 37 million square feet of building space. We are responsible for sophisticated and complex academic, research, and clinical facilities, as well as associated environmental stewardship and regulatory compliance. F&O is a positive organization dedicated to the principles of being respectful, collaborative, solutions-based, and proactive. For more information please visit our website: fo.umich.edu.

About Facilities and Operations Information Services (FOIS)

FOIS's mission statement is to provide the right information at your fingertips. FOIS specializes in the unique information systems, infrastructure, and business processes that help F&O effectively achieve its mission.

The list below showcases some of F&O's most critical information systems:

• Building Information Management (BIM)
• Geographic Information Systems (GIS)
• Construction Project Management
• Engineering Document Management System (EDMS)
  • Building Blueprints
  • Floor plans
• Facilities Integrated Work Management System
• Power Plant Management
• Training
• Fleet management
• Key and Access Control
• Building Automation Controls
• Visualization and Reporting Tools
• Custom Software Development
• Partner / Customer Support

Required Qualifications*

• Bachelor's degree in computer science or related field or 5 years equivalent experience.
• Minimum two years developing, supporting, and maintaining dashboards and reports using Tableau.
• Minimum two years writing SQL to develop, support, and maintain reports or ETL scripts.
• Minimum two years developing, supporting, and maintaining reports using Crystal Reports or similar reporting tools.
• Proven track record of meeting or exceeding project expectations and deadlines.
• Experience working effectively within a team environment.
• Demonstrated ability to effectively communicate technical ideas both verbally and in written documents to all levels of the organization.
• Effective listening, written, and oral communication skills.
• Ability to travel between sites across all U-M campuses.

Desired Qualifications*

• Experience in developing BIRT reports.
• Proficiency in data visualization techniques for reporting purposes.

Modes of Work

Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. This position requires at minimum 2 days on-site per week. Learn more about the work modes.

Additional Information

Facilities and Operations is a positive organization dedicated to the principles of being respectful, collaborative, solutions-based, and proactive.

Facilities and Operations seeks to recruit and retain a diverse workforce as a reflection of our commitment to serving 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.

This position may work with and/or support systems that maintain or process sensitive institutional data as defined by university policy. Successful candidates must comply with federal, state, and local law, and/or university policies or agreements that require the university to implement specific privacy and security safeguards, including but not limited to ITAR, EAR, HIPAA, and FISMA.

Eligibility Requirement:

Candidates for this position must be legally authorized to work in the United States at the time of application. Visa sponsorship is not available for this position.

Benefits at the University of Michigan

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
• Flexible spending accounts for healthcare and dependent care expenses
• Dental and Vision Insurance
• Parental and Maternity Leave

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.

256793

Business Intelligence Developer

BI Analyst Intermediate

Ann Arbor Campus

Hybrid

Full-Time

Regular

Exempt

Business Operations

Facilities & Operations - IS

11/12/2024 - 11/26/2024

$75,000.00 - $90,000.00

Administration
Facilities Operations
Information Technology