Data Analyst

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.

Example Of Duties & Responsibilities

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 PeopleSoft (PS) Query Development.

Perform other duties as assigned.

Typical Qualifications

Minimum Qualifications

• 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.

Preferred Qualifications

• Working knowledge of Oracle/PeopleSoft.
• Prior work experience in higher education.
• Proficient in Tableau or similar dashboard software.
• Ability to apply statistical analysis tools for quantitative/qualitative data analysis.
• Awareness of data governance principles and best practices.

How To Apply

An online application must be completed for consideration. Click "Apply" at the top of the page to get started. Paper submissions or emailed materials will not be accepted. A complete application must also include the following documents:

• Letter of Interest (cover letter) - describing your interest in Lower Columbia College and this position, how your experience, knowledge/skills, education, abilities etc. meet the qualifications for this position
• Resume
• References - please provide at least three professional references including one current or former supervisor
• Unofficial transcripts (if applicable)

Upon request, accommodations are available for persons with disabilities for the Lower Columbia College hiring process. Please contact Human Resources to request an accommodation. The Human Resources Office is accessible to persons with disabilities.

To be employed at Lower Columbia College, applicants must currently reside in Washington or Oregon, or be willing to relocate to one of these states. This is a condition of employment for all positions at the College. Please ensure your application reflects your current residency or intent to relocate if selected for the role.