Business Intelligence (BI) Analyst

Oakland Community College Office Of Human Resources•College Wide, MI

11h

About The Position

The Business Intelligence Analyst queries institutional data to help the College assess the effectiveness of academic and non-academic policies, procedures, services, and programs. In a team-oriented SQL environment, the analyst mines large datasets to identify patterns and relationships between College practices and student success. The position works in a multicultural, diverse environment. The analyst analyzes organizational data, develops complex queries and reports, collaborates with College staff on data extracts and statistical analyses, and communicates findings through visualization applications. The role also maintains procedural documentation, follows applicable guidelines and policies, protects confidential information, and may perform related duties as assigned.

Requirements

Bachelor’s degree in Business, Social Science, Computer Science, Statistics, or applied research methodologies.
Three years of data mining or querying experience in SQL.
Advanced knowledge of MS Office software, especially MS Access query and data management functions, and SPSS or other statistical software.
Skill in visualization applications such as Power BI or Tableau.
Ability to identify the statistical procedure most appropriate for the variables in question.
Ability to interpret and communicate statistical information.
Ability to write SQL SELECT queries using WHERE statements to filter data, variable creation, subqueries, pivots, joins, sorting, and grouping or aggregation.
Ability to explain relational databases and the outcomes of different join types, including inner, outer, and cross joins.
Detail-oriented, with a proven record of producing high-quality work.
Ability to operationalize complex ideas, manage complex projects, and meet strict deadlines.
SQL coding examination required for employment.

Nice To Haves

Master’s degree preferred.

Responsibilities

Analyze organizational data, including enrollment patterns and projections, predictors of student success, demographic patterns, instructional staffing replacement, and instructional costs and revenues.
Write and revise complex queries and reports according to project specifications and timelines, and maintain procedural documentation for verification and replication.
Collaborate with departmental and College staff to develop data extracts, statistical reports, and analyses; apply sampling techniques to define groups for surveys.
Perform work in accordance with College, departmental, professional organization, federal, and state guidelines, as well as best practices, policies, and procedures.
Stay current on College policies and procedures and assess their effects on the integrity of institutional data.
Assist in writing up statistical methods and results.
Use visualization applications to communicate analytical results to senior administration, College staff and faculty, and external organization representatives.
Maintain confidentiality of information.
Perform other related duties as assigned.
Work additional hours as needed.