Data Analytics and Data Warehouse Coordinator

The Data Analyst and Data Warehouse Coordinator reports to the Director of Data Analytics. This position will create, implement and refine existing and new technology and data resources/tools that will support departments in applying evidence-based practices to make data-informed decisions. This position is responsible for executing institutional projects including, but not limited to, the implementation of department dashboards, developing reports to meet stakeholder needs, utilizing analytics tools to support student success and maintaining the data integrity in various systems. This is an onsite position.

1.Assist the Director of Data Analytics in collaboration with departments throughout the college; become a trusted data and insights provider to internal stakeholders.

2.Ensure regular reporting of key metrics, data strategy, and communicate successes to all college stakeholders.

3.Identify the data needed to support institutional initiatives, accreditation processes, and quality improvement processes, and, if needed, develop methods to collect and store that data within new or existing systems.

4.Facilitate the development and implementation of dashboards and other reporting functionality for end users using Tableau or other analytical software.

5.Assist with the Director of Data Analytics in designing and documenting an institutional data governance system, in collaboration with IT and other relevant stakeholders that includes documented data definitions, data steward guidelines, and other appropriate documentation.

6.Provide administrative and technical development and with the support of the Director of Data Analytics in maintaining a SQL based data warehouses.

7.Identify, maintain and clean data stored in various systems including the college's ERP system, data warehouses, and data collected from third party software.

8.Develop interactive and intuitive data visualizations to communicate meaning of data through webpages, reports, and presentations to campus leadership and other constituents.

9.Assist with mandated state reporting to the State of Illinois - Community College Board. Perform edits to ensure data is submitted in a clean and concise timeframe.

10.Ensure the security and integrity of data under the position's purview by following the confidential and sensitive information procedures and other industry best practices. Participate in the development/updating of procedures and best practices as required.

11.Along with the Director of Data Analytics, design, sustain and trouble-shoot queries that extract data from the various College information systems, databases and the data warehouse. Create reports and data query systems using business intelligence tools.

12.Perform other job-related duties as assigned.

Education: Bachelor's degree required. Master's degree in Computer Science, Business Administration, Information Technology. Math or related field strongly preferred.

Experience: Five to eight years of experience in a post-secondary educational institution or research office.

Knowledge: Data mining and data analysis skills with the ability to present complex information in a simple manner, discern the business problem, and recommend actions to others. Ability to manage ambiguity while presenting alternatives and new ideas to staff and stakeholders. Good interpersonal, written and oral communication skills.

Skills: Previous interaction and/or work experience with Tableau is preferred. Advanced Microsoft Excel skills (e.g., VLOOKUP, Pivot Tables) and experience with statistical analysis packages and coding (e.g., Tableau, SQL, R, Python) are recommended.

Personal: Demonstrated ability to work independently as well as work collegially with a diverse population of students, staff and community in a fast-paced work environment with multiple priorities and interruptions. Detail-oriented, self-starter. Ability to provide informative and timely analysis.

Database Management/Basic Programming Testing Required