Spanish bilingual and Hispanic jobs since 1997. Diversity job fairs since 2006. employers     login   |   register - post a job
Hispanic Diversity Recruitment - best jobs for hispanic, latino & bilingual (spanish & portuguese) jobseekers
    Log me in!   |   Site Map   |   Help   
 Business Intelligence Analyst - Auburn Hills, Michigan, United States

Job information
Posted by: Oakland Community College 
Hiring entity type: Other 
Work authorization: Existing work authorization required for United States
Position type: Direct Hire, Full-Time 
Compensation: ******
Benefits: See below
Relocation: Not specified 
Position functions: Management - MBA
Travel: Unspecified 
Accept candidates: from anywhere 
Languages: English - Fluent
Minimum education: See below 
Minimum years experience: See below 
Resumes accepted in: English
Cover letter: No cover letter requested
Job code: C1ekh1Opx6LQIT1TWGwvr15ElNicCK / Latpro-3760749 
Date posted: Nov-05-2020
State, Zip: Michigan, 48326


Title:                         Business Intelligence Analyst
Employee Group:       Management Staff Non-Exempt
Location:                   Auburn Hills Campus - Auburn Hills, MI
Division:                    Institutional Effectiveness
Application Deadline:  Sunday, November 29, 2020 at 11:59pm
Shift Days:                Monday - Friday: 8:30am - 5:00pm
Salary Range:            $52,628 - $59,819
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. The employee works in a high volume, fast paced, 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 assess 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 faculty and staff, and representatives from outside organizations.
  8. Maintains confidentiality of information.
  9. 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 the 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 (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 Requirement:

EDUCATION:     Bachelor’s Degree in Business, Social Science, Computer Science, Statistics or applied research methodologies.  Master’s Degree preferred.

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

Required Documents Message:
Cover Letter, Resume

recblid lw6bi57ipaan498yrxcdff5tvosyx6




Oakland Community College requires you to fill in their on-line form which will open in a different window.

Enter your email address and click 'Apply':
  Prefer not to enter your email? 

Follow the application instructions in the Job Description.