Data Management Analyst

Data Management Analyst Job no: 495099 Position Type: Full-Time Location: Elgin, IL Experience Level: Mid-Level Categories: Institutional Support, Professional/Technical Role: 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 : 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. 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.) 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.) Considerable skills with statistical software, such as SPSS (preferred or SAS or R): Considerable skills in using data visualization software, such as Tableau or PowerBI. Considerable skills in presenting and discussing statistical analysis and research findings to a wide variety of audiences with varying levels of statistical understanding Considerable skills in analyzing problems and developing creative and innovative solutions. Considerable skill in the use of the Microsoft Office Suite, including but not limited to Word, Excel, Access and Publisher Considerable skill in organizing work to meet established deadlines while maintaining attention to detail. Considerable skill in interpersonal interaction to be applied to a variety of individuals with differing education, ethnic and socio-economic backgrounds. Considerable skills in verbal and written communication to a variety of audiences. 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. Must be available to work a flexible schedule, including evenings and weekends when required by the department's needs. Desired Knowledge, Skills & Abilities: Master's degree Experience in Institutional Research or Information Technology, or a similar department in a higher educational institution Considerable skills in statistical software syntax/programming Essential Duties: 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. 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. 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. Participation in College Committees/Activities: Represents the Institutional Research office on various committees throughout the College, as directed by the SDDQ and Managing Director of Institutional Research. Provides general consultation for members of the College concerning research needs. Original Research and Development: Generates unique and innovative research projects to further the College's mission and goals, as time permits. Seeks to advance understanding of College's data by examining new or previously unused data elements through sophisticated statistical techniques. Maintains required training, licensure and/or certifications Maintains confidentiality of privileged information and adheres to applicable privacy laws Demonstrates sensitivity, understanding and respect of diverse populations within the workplace. Maintains an understanding of the work of colleagues to effectively provide backup and/or support for co-workers during times when the division is short-staffed or experiencing an increased volume of work. Adheres to department guidelines for attendance and punctuality Other Duties: Perform other job-related duties as assigned which pertain to the job description. Ability to work a flexible schedule which includes days/evenings/weekends as needed by the department. Physical Demands: Light (up to 25 lbs occasionally or 10 lbs frequently) Visual Acuity: Close visual acuity (e.g. computer, assembly) Work Environment: Moderate noise Environmental Conditions: Typical office or administrative Current SSECCA Union Member Information: The initial posting date for this position is 11/04/2024. Elgin Community College Support Staff Association (SSECCA) members that apply by 11/11/2024 and meet the posted minimum qualifications will receive full consideration. Equal Employment Opportunity Statement: Elgin Community College does not discriminate, or tolerate discrimination, against any member of its community on the basis of race, color, national origin, ancestry, sex/gender/gender identity, age, religion, disability, pregnancy, veteran status, marital status, sexual orientation, or any other status protected by applicable federal, state or local law in matters of admissions, employment, or in any aspect of the educational programs or activities it offers. In addition, Elgin Community College provides reasonable accommodations to qualified individuals with disabilities to ensure equal access and equal opportunities with regard to employment practices, educational opportunities, and programs and services. If you need a reasonable accommodation for any part of the application and hiring process, please notify the College's EEO/AA Officer. Determinations on request for a reasonable accommodation will be made on a case-by-case basis. Advertised: November 4, 2024 Central Standard Time Applications close: