Job Listings

Business Intelligence Systems Analyst

Henry Ford College
Job Location:
Dearborn, Michigan
Requisition ID: req562

Compensation Type: Salary

Compensation Range: $57,063.00 - 64,193.00

Schedule: 8am-4:30pm M-F Fall and Winter Semesters 8am-6:30pm M-Th Spring and Summer Semesters

Henry Ford College (HFC) is a comprehensive public college located in Dearborn, Michigan that serves 11,390 students. Founded in 1938, it continues to be dedicated to preparing students for a rapidly changing world and workplace by offering more than 120 associate degrees, career and university transfer programs and a bachelor's degree in Culinary & Hospitality Studies.

The HFC Mission is to transform lives and build better futures by providing outstanding education. As a student-centered, evidence-based college, our success is measured by the success of our students. We empower learners through the development of independent, critical, and creative thinking, and we foster diversity, inclusion, understanding, and acceptance to prepare learners to succeed in a global society. We anticipate and respond to the needs of our stakeholders, exceed their expectations, and serve the public good.

HFC employees receive competitive compensation packages including generous benefits for full-time faculty, administrative, and staff positions. Please see collective bargaining agreements for details at

HFC presents an opportunity for a Business Intelligence Systems Analyst

Job Description Summary

The Business Intelligence Systems Analyst supports the College's Institutional Research function in reporting and dataset development. The Analyst's primary responsibility is to write code to extract data, either on an ad hoc basis, or as fully developed end-user reports. Additional responsibilities include analysis of reporting requirements, development and maintenance of external datasets, data forensic/integrity analysis, development of report specifications, extracting data for state and federal reports, development and maintenance of extract, transform, load (ETL) processes, and development and maintenance of dashboards, data visualizations, and other business intelligence tools.

The Business Intelligence Systems Analyst collaborates with staff from the Institutional Research to determine end-user needs and collaborates with staff from the Information Technology Services department to translate and apply those needs within the ERP system.

This position typically requires a bachelor's degree or higher plus three years of related experience, or an equivalent combination of education and experience in information technology and/or institutional research. However, HFC recognizes that there are alternative career paths in which candidates may gain the expertise and ability to perform the essential duties.

Education, experience, and training that demonstrates proficiency and the ability to perform the essential duties will be evaluated for equivalency to the education, competencies, and experience qualifications listed below.

Competencies and Qualifications

The most successful candidate will have a career that reflects:

Applied Technical Skills
  • Knowledge of systems analysis and administrative IT systems (ERP); demonstrated proficiency in the incorporation of multiple information systems.
  • Mastery of one or more computer programming languages.
  • Knowledge of SQL and relational database management systems, relational data analysis and business intelligence reporting.
  • Ability to develop and document information processes.
Analytical Skills
  • Demonstrated ability to use complex analytic judgment and ingenuity to plan and perform difficult work where only general methods may be available.
  • Demonstrated ability to create new processes and procedures where existing methods do not exist.
  • Strong desire to work with highly complicated technical projects and problems which require exceptional judgment, considerable ingenuity, and initiative in dealing with factors not easily evaluated.
Operational Excellence Skills
  • Deductive and inductive reasoning skills to develop innovative ways to acquire and manage data, improve analysis, and streamline recurring studies for optimal efficiency.
  • Ability to develop, evaluate, enhance, and/or implement quality improvement practices, processes, procedures, or policies that have an impact on operations.
Collaborative Skills
  • Ability to develop and promote a department culture that is conducive to effective relationships among diverse teams and audiences.
  • Excellent interpersonal, written, and verbal communication skills; the ability to present complex technical information to a broad constituency is essential.
Essential Duties
  • Write code to extract data from the college's ERP and other data sources based on customer-driven report specifications.
  • Extract data for state and federal reports.
  • Develop and maintain extract, transform, load (ETL) processes.
  • Develop and maintain dashboards, data visualizations, and other business intelligence tools.
  • Conduct data forensic analyses and monitor the overall integrity of data, complying with state and federal requirements and taking appropriate steps to correct data discrepancies when noted.
  • Other duties related to institutional research and reporting as assigned.
Additional Information:

For applicants viewing this ad from an external site, please go to and click the "Jobs" link to apply.

For further information about HFC, please visit us at or on Facebook,, Twitter,, LinkedIn,
This website is part of the HigherEdJobs network.