Business Intelligence DeveloperApply NowHow to ApplyA 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 SummaryThe 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 AreFacilities 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 WorkPositions 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 thework modes (https://hr.umich.edu/working-u-m/my-employment/ways-we-work-resource-center/ways-we-work-implementation-group/modes-work) .Additional InformationFacilities 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 MichiganThe 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 ScreeningThe 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 DeadlineJob 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 StatementThe University of Michigan is an equal opportunity/affirmative action employer.Job DetailJob Opening ID256793Working TitleBusiness Intelligence DeveloperJob TitleBI Analyst IntermediateWork LocationAnn Arbor CampusAnn Arbor, MIModes of WorkHybridFull/Part TimeFull-TimeRegular/TemporaryRegularFLSA StatusExemptOrganizational GroupBusiness OperationsDepartmentFacilities & Operations - ISPosting Begin/End Date11/12/2024 - 11/26/2024Salary$75,000.00 - $90,000.00Career InterestAdministrationFacilities OperationsInformation TechnologyApply Now