Business Intelligence (BI) Analyst

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

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 environmentThis 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. 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. 2. Writes and revises complex queries and reports in accordance with project specifications and timelines; maintains accurate procedural documentation for verification and replication.
3. 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. 4. Performs work in conformance with established College, department, professional organization, federal, and state guidelines as well as best practices, policies and procedures.
5. 5. Remains current on College policies and procedures and assesses their impact on the integrity of institutional data.
6. 6. Assists in write ups of statistical methods and results.
7. 7. Uses visualization applications to communicate analytical results to senior administration, college staff/faculty, and representatives from external organizations.
8. 8. Maintains confidentiality of information.
9. 9. Performs other related duties, as assigned.
10. 10. Ability to work additional hours, as needed.

• 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

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.