What are the responsibilities and job description for the Data Analytics and Data Warehouse Coordinator position at Lake Land College?
JOB
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.
EXAMPLE OF DUTIES
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.
SUPPLEMENTAL INFORMATION
Database Management/Basic Programming Testing Required
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.
EXAMPLE OF DUTIES
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.
SUPPLEMENTAL INFORMATION
Database Management/Basic Programming Testing Required
