Data Management Analyst

 

About ECC:

Elgin Community College serves over 9,000 students at every stage of their educational journeys, including university transfer programs, career and technical education, continuing education classes, and adult basic education. As a community, we pride ourselves on nurturing a welcoming campus where every person—students, staff members, faculty members, and campus visitors—feels valued. The work of each ECC employee is central to the college’s mission, and as an employer, the college fosters a positive environment through professional challenges, excellent benefits, and opportunities for recognition and camaraderie.

Work Schedule:

8:00 AM to 5:00 PM Monday through Friday

Rate of Pay:

This position is a grade 214 with a minimum of $64,236 and a mid-point of $85,648. Salary offer will be commensurate with the education/experience, in alignment with the College’s compensation philosophy, and the current CBA, if applicable.

FLSA Status:

Non-Exempt

Grant Funded:

No

Job Summary:

An employee in this classification performs work of moderate difficulty by serving as the Institutional Research (IR) Office lead in quality control testing for the College’s data warehouse, and to assist the Senior Director of Data Quality (SDDQ) in preparing, coordinating and managing external data submissions. Work is distinguished by the ability to work with sensitive and private data and maintain the highest level of confidentiality and ethical consideration. General supervision is received by the assigned manager.

Required Knowledge, Skills & Abilities:

1. Bachelor’s degree required in a related field with a minimum of two years of experience in an educational setting or relevant research experience or equivalent combination of training and experience.
2. Good knowledge of the development, management, and use of relational databases and in querying, creating and maintaining working datasets from an ERP/student information system (e.g., Ellucian Colleague, Banner, etc.)
3. Considerable skills working directly with data warehouse or data management systems and using one or more common query/reporting tools (e.g., SSMS, SQL, TOAD, Cognos, SSRS, Crystal Reports, etc.)
4. Considerable skills with statistical software, such as SPSS (preferred or SAS or R):
5. Considerable skills in using data visualization software, such as Tableau or PowerBI.
6. Considerable skills in presenting and discussing statistical analysis and research findings to a wide variety of audiences with varying levels of statistical understanding
7. Considerable skills in analyzing problems and developing creative and innovative solutions.
8. Considerable skill in the use of the Microsoft Office Suite, including but not limited to Word, Excel, Access and Publisher
9. Considerable skill in organizing work to meet established deadlines while maintaining attention to detail.
10. Considerable skill in interpersonal interaction to be applied to a variety of individuals with differing education, ethnic and socio-economic backgrounds.
11. Considerable skills in verbal and written communication to a variety of audiences.
12. Considerable skill in operating a personal computer, applicable software and peripheral equipment as well as learning and adapting to new and updated programs and technology.
13. Must be available to work a flexible schedule, including evenings and weekends when required by the department’s needs.

Desired Knowledge, Skills & Abilities:

1. Master's degree
2. Experience in Institutional Research or Information Technology, or a similar department in a higher educational institution
3. Considerable skills in statistical software syntax/programming

Essential Duties:

1. Data Warehouse Support and Administration: Serves as IR system administrator for the data warehouse.  Analyzes and maintains working knowledge of data warehouse systems, including integration with other college systems; performs upgrades, recommends improvements, documents daily, weekly and other tasks and troubleshooting documentation. Maintains, documents, and monitors security, working with IT to resolve issues.
2. Prepare Data Submissions to External Reporting Agencies: At the direction of the SDDQ, prepares data extracts for submission to fulfill various national, state and local reporting requirements. Works with IT to troubleshoot and update data extraction processes as needed.
3. Prepare/Maintain Tableau Data Visualizations: Assists SDDQ and Managing Director in maintenance of existing and creation of new data visualization dashboards used by stakeholders to interact with the College’s data warehouse. These dashboards will primarily be created using Tableau software.