Business Intelligence Systems Analyst

Business Intelligence Systems Analyst

Henry Ford College presents an opportunity for a Business Intelligence Systems Analyst. The Business Intelligence Systems Analyst (BISA) 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.

Core Competencies and Qualifications

HFC recognizes that there are alternative career paths in which candidates may gain the expertise and ability to perform the essential duties and may consider a combination of education and experience in lieu of a conferred degree.

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

• 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.
• In addition, we seek someone who values and demonstrates:
• 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 change and current information; adapts behavior or work methods in response to current information, changing conditions, or unexpected obstacles; effectively deals with ambiguity.
• Teamwork - Encourages and facilitates cooperation, pride, trust, and group identity; fosters commitment and team spirit; works with others to achieve goals.

Essential Duties and Responsibilities including but not limited to

• 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 and qualified to perform.

Additional Information

Salary: The posted salary range reflects Steps 1-6. The full range includes Steps 1- 14 ($65,941.00- $104,107.00). Starting salaries are typically below the top of the range and are determined based on skills, experience, and qualifications. Work Eligibility: This position is not eligible for employment visa sponsorship now or in the future. While we have attempted to capture the core functional responsibilities in the role, the statements contained in this job announcement reflect general details as necessary to describe the principal functions of this job, the level of knowledge and skill typically required, and the scope of responsibility. It should not be considered an all-inclusive listing of work requirements. Therefore, performing additional job-related duties not listed above may be required as assigned. For applicants viewing this ad from an external site, please go to hfcc.edu/jobs to apply.