Data Analyst

The Data Analyst is responsible for ensuring the efficient operation of the institutional research data warehouse and related tables and files, creating and supporting database queries via Access and Structured Query Language (SQL), and maintaining and developing data dashboards for the college. The Data Analyst is also responsible for supporting new and ongoing initiatives related to institutional research, institutional effectiveness, and student success.

We are looking for a collaborative, self-starter who is detail-oriented and comfortable working independently and as part of a team. The successful candidate will demonstrate strong interpersonal skills, communication skills, critical thinking and quantitative skills, and be willing to learn.

The Data Analyst is a member of the Effectiveness & College Relations team that manages the College's data, monitoring reports, marketing and websites, and ctcLink enterprise system. This position works most closely with the Director of Institutional Research and the Vice President of the department.

Access to accurate and relevant data is a critical aspect of any organization's Diversity, Equity and Inclusion (DEI) work. The person in this position will assist with data disaggregation to support Curriculum and Program Review, Institutional Monitoring, and other DEI initiatives.

The Data Analyst position is 40 hours per week. The typical schedule is Monday through Friday, 8:00 am to 5:00 pm. This position is primarily an on campus position with the opportunity to work occasional remote hours once training has been completed. Depending on the salary offer, this exempt position may be eligible for overtime under FLSA. This position reports to the Director of Institutional Research.

Check us out on Facebook and Instagram!

• Manage files and tables that make up the institutional research data warehouse and related databases.
• Perform high-level database queries using Structured Query Language (SQL) and other technologies.
• Develop and maintain enrollment reports and related processes in collaboration with institutional research and other college staff.
• Maintain thorough documentation of data processes, definitions, and reports.
• Monitor and maintain consistency of institutional coding and data to ensure data quality and adherence to data governance principles.
• Develop and maintain data dashboards using Tableau and related technology.
• Produce tables, graphs and narrative analysis of qualitative and quantitative data, potentially utilizing statistical analysis techniques and tools as appropriate.
• Leverage Python or R for advanced data processing, analysis, and visualization to ensure efficient insights and automation of reporting functions.
• Support institutional monitoring, accreditation, assessment, and ad-hoc data needs and requests in collaboration with institutional research and other college staff as needed.
• Support survey administration and reporting as needed to ensure adherence to data privacy and security regulations like FERPA.
• Prioritize and manage multiple data requests and projects effectively.
• Conduct longitudinal and cohort tracking as needed.
• Support compliance reporting as needed.
• Serve on college committees and work groups as assigned.
• Support People Soft (PS) Query Development.
• Perform other duties as assigned.

This description is not intended and should not be construed to be an exhaustive list of all responsibilities, skills, effort, work conditions, and benefits associated with the job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor’s degree in information systems, computer science or related field, or equivalent education and experience.
• Prior work experience in database management.
• Strong working knowledge of Structured Query Language (SQL).
• Proficiency in at least one programming or statistical computing language, preferably Python or R
• Demonstrated communication, interpersonal and teamwork skills.
• Experience with Microsoft Access or similar relational database, including data management and query functions.
• Proficient with general office technologies including Microsoft Word/Google Docs, Excel/Google Sheets, and PowerPoint/Google Slides.

• Working knowledge of Oracle/People Soft.
• Prior work experience in higher education.
• Proficient in Tableau or similar dashboard software.
• Ability to apply statistical analysis tools for…