Higher-Ed BI Analyst: Data Insights & Visualizations

Oakland Community College; Auburn Hills (MI); On-site; USD 60,000 - 90,000; Full time

Job summary

Oakland Community College seeks a Business Intelligence Analyst to query institutional data and support assessment of academic and non-academic policies and programs. You will mine large datasets and identify patterns linking college practices to student success in a collaborative, multi-cultural environment.

The role requires advanced SQL, MS Access, and SPSS; proficiency with Power BI or Tableau to communicate results to senior administration.

Qualifications

• Bachelor’s degree in Business, Social Science, Computer Science, Statistics, or applied research methodologies.
• Master’s degree preferred.
• Three (3) years of data mining/querying experience in SQL.

Responsibilities

• Analyzes organizational data including enrollment patterns, enrollment projections, predictors of student success, patterns of demographics, instructional staffing replacement, and instructional costs and revenues.
• Writes and revises complex queries and reports in accordance with project specifications and timelines; maintains accurate procedural documentation for verification and replication.
• W orks collaboratively with departmental and College staff to develop extracts, statistical reports, and analyses; applies sampling techniques to determine and define groups to be surveyed.
• Performs work in conformance with established College, department, professional organization, federal, and state guidelines as well as best practices, policies and procedures.
• Remains current on College policies and procedures and assesses their impact on the integrity of institutional data.
• Assists in write ups of statistical methods and results.
• Uses visualization applications to communicate analytical results to senior administration, college staff/faculty, and representatives from external organizations.
• M aintains confidentiality of information.
• Performs other related duties, as assigned.
• Ability to work additional hours, as needed.

Skills

Data mining

Querying

Statistical analysis

Data visualization

SQL proficiency

Education

Bachelor's degree in Business, Social Science, Computer Science, Statistics, or applied research methodologies

Master's degree preferred

Tools

MS Access

SPSS

Power BI

Tableau

SQL

Job description

Oakland Community College seeks a Business Intelligence Analyst to query institutional data and support assessment of academic and non-academic policies and programs. You will mine large datasets and identify patterns linking college practices to student success in a collaborative, multi-cultural environment.

The role requires advanced SQL, MS Access, and SPSS; proficiency with Power BI or Tableau to communicate results to senior administration.