Business Intelligence Coordinator

Coordinate and implement solutions which transform internal college data into meaningful and useful information used to enable more effective strategic, tactical and operational insights and decision making.

ESSENTIAL DUTIES AND RESPONSIBILITIES:
This position description should not be interpreted as all inclusive. It is intended to identify the major responsibilities and requirements of the job. The incumbents may be requested to perform job-related responsibilities and tasks other than those stated on this description.

1. Identify and lead projects that create systems which provide timely, accurate, and useful data, information, metrics and analysis to support data-driven decision-making. Assist decision-makers with analyzing, understanding and generating action based on data.
2. Design, develop, validate and implement business intelligence solutions such as reports and dashboards. Take a leadership role in developing, supporting and delivering predictive analytics.
3. Lead in the design, implementation, and validation of a college data lake/data warehouse.
4. Lead or assist in designing, monitoring, analyzing and reporting information for internal and external customers which supports operations and tracks attainment of college goals and objectives.
5. Collaborate with Information Technology Services staff on BI projects. Identify barriers and recommend solutions for security, data integrity, self-service, definition and policy issues which limit analysis and functionality of required information.
6. Design and deliver BI training, direction and support to IRE staff and the College's functional users.
7. Promote the use of BI tools.
8. Provide timely, readily accessible data acquisition, information and analysis for college staff that can be used in decision-making Provide consultation to other areas of the College regarding design and interpretation of reports and/or studies to address their unique needs.
9. Ensure timely and accurate institutional reporting in compliance with Federal, state and system-level mandates (e.g., IPEDS, WTCS reporting).
10. Coordinate with and support College data governance efforts.
11. Maintain current professional/ technical knowledge through professional education and activities. Know and stay current on related laws and regulations. Participate on College and state-wide committees.

REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES:

• Thorough knowledge of research techniques (e.g., advanced data analysis tools such as SPSS; research principles and methodologies).
• Thorough knowledge of and proficiency in the design use and integration of databases, data models and/or other data sources.
• Thorough knowledge of and proficiency in direct querying and the use of business intelligence tools (e.g. SQL, PowerBI, Python) with large databases to develop solutions, reports, and assure data integrity.
• Effective interpersonal communication skills - oral, written and listening.
• Ability to maintain confidentiality and an aptitude for working with confidential information.
• Ability to read, understand and follow technical manuals and procedural documentation.
• Analytical ability to compile and review numerical data and statistics and to effectively communicate complex analytical information and recommendations to non-technical staff.
• Ability to attend closely to detailed work, completing and maintaining a high level of accuracy.
• Ability to apply critical thinking and problem-solving skills to work processes.
• Ability to train users on analytical tools and provide feedback.
• Intermediate proficiency with computer software applications such as word processing, spreadsheets, presentations and/or publishing.

1. Master's degree in a technical (Statistics, Computer Science, Information Management) or analytical (e.g. Psychology, Sociology, Business Administration) field.
2. Three (3) years of related experience with emphasis on business intelligence working with large databases and an ERP system.