Business Intelligence (BI) Analyst

Business Intelligence (BI) Analyst

Salary

$60,000.00 - $75,000.00 Annually

Location

College Wide

Job Type

Management Staff Non-Exempt

Remote Employment

Flexible/Hybrid

Job Number

202400365

Division

Institutional Effectiveness

Opening Date

11/09/2026

Closing Date

11/15/2026 11:59 PM Eastern

Shift Days/Hours

Monday - Friday, 8:30am - 5:00pm

• Description
• Benefits
• Questions

Summary of Purpose

The Business Intelligence Analyst queries institutional data in support of college efforts to assess the efficacy of academic and non-academic policies, procedures, services, and programs. Working in a team oriented, sequel environment the analyst mines large datasets to identify patterns and relationships between College practices and student success. This position is expected to work in a multi-cultural diverse working environment

Typical Duties

This description is intended to indicate the types of duties and responsibilities requested of the employee assigned this title. It is not intended to be an exhaustive list of all the duties and responsibilities that may be required:

1. Analyzes organizational data including examination of enrollment patterns, enrollment projections, predictors of student success, patterns of demographics, instructional staffing replacement, and instructional costs and revenues.

2. Writes and revises complex queries and reports in accordance with project specifications and timelines; maintains accurate procedural documentation for verification and replication.

3. Works collaboratively with departmental and College staff to develop extracts, statistical reports, and analyses; applies sampling techniques to determine and define groups to be surveyed.

4. Performs work in conformance with established College, department, professional organization, federal, and state guidelines as well as best practices, policies and procedures.

5. Remains current on College policies and procedures and assesses their impact on the integrity of institutional data.

6. Assists in write ups of statistical methods and results.

7. Uses visualization applications to communicate analytical results to senior administration, college staff/faculty, and representatives from external organizations.

8. Maintains confidentiality of information.

9. Performs other related duties, as assigned.

10. Ability to work additional hours, as needed.

Knowledge and Skills Required

• Advanced knowledge of MS Office software especially advanced knowledge of MS ACCESS (query and data management functions) and SPSS (or other statistical software)
• Proven skill in visualization applications such as Power BI, Tableau, etc.
• Demonstrated ability to correctly identify the statistical procedure most appropriate for variables in question
• Demonstrated ability to interpret and communicate statistical information
• Demonstrated ability to write SQL select queries including where statements to filter data, variable creation, sub queries, pivots, join, sort, and group/aggregate
• Ability to explain relational databases and the outcomes of each type of join (e.g., inner, outer, cross)
• Detail oriented and proven track record of producing high quality work
• Proven ability to operationalize complex ideas, manage complex projects, and meet strict deadlines

Minimum Education and Experience

EDUCATION: Bachelor's degree in Business, Social Science, Computer Science, Statistics, or applied research methodologies; Master's degree preferred.

EXPERIENCE: Three (3) years of data mining/querying experience in sequel. SQL coding examination required for employment.

We are excited to have you consider Oakland Community College (OCC) as your employer of choice!

OCC strives to provide valuable and empowering services not only to our students, but also to our employees.

See below the benefits offered by the College under the benefit types: full-time and part-time

Full-Time Positions for the Following Employee Groups:

Classified, Exempt (Non-union), Faculty, Maintenance, Operating Engineers, Public Safety, Teamsters

Benefit Effective Date: First of the month after date of hire

Medical

• Multiple PPO medical plans with prescription coverage to choose from; Plans provided by Blue Cross Blue Shield of Michigan (BCBSM)

• Free preventive services on every plan

• Health Savings Account (HSA) available with the High Deductible medical plans

• BCBSM through the Western Michigan Health Insurance Pool (WMHIP) medical is offered to all employment groups

• There is a $2,000 prorated Medical Opt Out stipend with proof of other applicable medical coverage

Dental

• Blue Cross Blue Shield of Michigan (BCBSM) plan provided by the College, no payroll deductions

Vision

• NVA (National Vision Administrators) plan provided by the College, no payroll deductions

Flexible Spending Accounts (FSAs)

• Health Care, Limited Purpose, Dependent Care, and Adoption FSAs are available

Life Insurance

• The College provides $120,000 of coverage (portion is subject to taxation), no payroll deductions

Disability

• 70% of wages provided for Short-Term and Long-Term Disability

Retirement

• College employees are part of the Michigan Public School Employees Retirement System (MPSERS) provided by the Michigan Office of Retirement Services (ORS)
• The Exempt, Faculty, and Teamsters employee groups can elect the Optional Retirement Plan (ORP) provided by TIAA; opting out of MPSERS

Voluntary Retirement Accounts

• Employees can open and contribute via payroll deduction into 403(b) and/or 457(b) voluntary retirement accounts provided by TIAA

Voluntary Benefits

• Employees can elect voluntary benefits of optional life insurance (for self, spouse, and/or children), cancer protection, pet insurance, legal & ID shield, long term and/or critical care during annual open enrollment in November

Tuition

• OCC tuition waiver program for employees and their dependents
• Employees may take Non-OCC classes using the tuition reimbursement program

Employee Assistance Program (EAP)

• Employees have a free resource to assist with a wide-range of needs, including counseling sessions

Employee Group: Classified Part-Time

Benefit Effective Date: First of the month after date of hire

Part-time Classified employees are offered the opportunity to have medical, dental, vision at the full monthly premium; life insurance is also available at a nominal cost. Participation requires that benefit costs be taken via payroll deduction.

Medical

• Multiple PPO medical plans with prescription coverage to choose from; Plans provided by Blue Cross Blue Shield of Michigan (BCBSM)

• Free preventive services on every plan

• Health Savings Account (HSA) available with the High Deductible medical plans

• BCBSM through the Western Michigan Health Insurance Pool (WMHIP) medical is offered to all employment groups

Dental

• Blue Cross Blue Shield of Michigan (BCBSM) plan that has free in-network preventive services including two annual cleanings

Vision

• NVA (National Vision Administrators) plan that includes annual examinations with participating providers

Life Insurance

• Employees can choose to have a life insurance policy of $10,000 or $20,000

Retirement

• College employees are part of the Michigan Public School Employees Retirement System (MPSERS) provided by the Michigan Office of Retirement Services (ORS)

Voluntary Retirement Accounts

• Employees can open and contribute, via payroll deduction, into 403(b) and/or 457(b) voluntary retirement accounts provided by TIAA

Tuition

• OCC tuition waiver program for employees and their dependents
• Employees may take Non-OCC classes using the tuition reimbursement program

Employee Group: Adjunct Faculty, Part-time Hourly (Non-union), and Casual Instructors*

Retirement

• College employees are part of the Michigan Public School Employees Retirement System (MPSERS) provided by the Michigan Office of Retirement Services (ORS)

Voluntary Retirement Accounts

• Employees can open and contribute, via payroll deduction, into 403(b) and/or 457(b) voluntary retirement accounts provided by TIAA

Tuition

• OCC tuition reimbursement program available for Adjunct Employees
• Edustaff employees are not eligible for OCC benefits.

Contact Information: hr@oaklandcc.edu

01

Do you have a Bachelor's degree in Business, Social Science, Computer Science, Statistics, or applied research methodologies?

• Yes
• No

02

Do you have three (3) years of data mining/querying experience in sequel?

• Yes
• No

03

Are you a member of the OCC Teamsters Union?

• Yes
• No

04

What is your expected salary? Please note our salary range as listed in the job posting.

Required Question

Employer Oakland Community College Office Of Human Resources

Address 2900 Featherstone Rd.

Auburn Hills, Michigan, 48326

Phone 248-341-2022

Website https://www.oaklandcc.edu/