Business Intelligence Systems Analyst

Position Description Summary

Henry Ford College presents an opportunity for a Business Intelligence Systems Analyst.

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.

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.

Please note: This is a fully onsite position located in Dearborn, Michigan and requires that you meet the I-9 standards today.

The most successful candidate will have a career that reflects the following:

• 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.

• 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 and problems which require exceptional judgment, considerable ingenuity, and initiative in dealing with factors not easily evaluated.

• 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.

• 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.

• Customer Service – Works with clients and customers (any individuals who use or receive the services or products that your work unit produces, including the public, individuals who work in the College, or organizations outside the College) to assess their needs, provide information or assistance, resolve their problems, or satisfy their expectations; knows about available products and services; is committed to providing quality products and services.
• Integrity/Honesty – Contributes to maintaining the integrity of the organization; displays high standards of ethical conduct and understands the impact of violating these standards on an organization, self, and others; is trustworthy.
• Accountability – Holds self and others accountable for measurable high-quality, timely, and cost-effective results. Determines objectives, sets priorities, and delegates work as appropriate. Accepts responsibility for mistakes. Complies with established control systems and rules.
• Flexibility – Is open to…