Data Analyst

Lower Columbia College is hiring a Data Analyst for a hybrid role in Longview, WA to support institutional research data, reporting, and dashboards.

Responsibilities

• Manage files and tables that make up the institutional research data warehouse and related databases.
• Run high-level database queries using 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 support 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; use statistical analysis techniques and tools as appropriate.
• Use Python or R for advanced data processing, analysis, and visualization to improve insights and automate reporting functions.
• Support institutional monitoring, accreditation, assessment, and ad-hoc data requests with institutional research and other staff as needed.
• Support survey administration and reporting as needed while ensuring adherence to FERPA and related data privacy and security regulations.
• 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.

Requirements

• 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 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.
• Proficiency 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.
• Proficiency with Tableau or similar dashboard software.
• Ability to apply statistical analysis tools for quantitative and qualitative data analysis.
• Awareness of data governance principles and best practices.

Technologies

• SQL
• Access
• Tableau
• Python
• R
• PeopleSoft (PS)
• Oracle
• PeopleSoft (PS) Query Development
• Microsoft Word
• Google Docs
• Excel
• Google Sheets
• PowerPoint
• Google Slides
• Microsoft Access
• FERPA
• ctcLink enterprise system

Team & DEI Focus

• Member of the Effectiveness & College Relations team managing college data, monitoring reports, marketing and websites, and the ctcLink enterprise system.
• Works closely with the Director of Institutional Research and the Vice President of the department.
• Supports DEI work through data disaggregation to assist Curriculum and Program Review, Institutional Monitoring, and other DEI initiatives.

Schedule and Work Conditions

• 40 hours per week.
• Typical schedule: Monday through Friday, 8:00 am to 5:00 pm.
• Primarily on campus with the opportunity for occasional remote hours once training is completed.
• This exempt position may be eligible for overtime under FLSA, depending on the salary offer.
• Reports to the Director of Institutional Research.

Compensation

• USD 74,400 - 99,000 per year.

How to Apply

• Complete an online application for consideration.
• Paper submissions or emailed materials will not be accepted.
• Include: Letter of Interest (cover letter), Resume, References, and Unofficial transcripts (if applicable).

Accommodation Notice

• Upon request, accommodations are available for persons with disabilities for the Lower Columbia College hiring process.
• Contact Human Resources to request an accommodation.

Residency Requirement

• Applicants must currently reside in Washington or Oregon, or be willing to relocate to one of these states.
• Residency is a condition of employment for all positions at the College.

Conditions of Employment

• If hired, proof of identity and documentation of U.S. citizenship or appropriate legal authorization to work for the duration of the position will be required per the Immigration Reform Control Act of 1995.
• A background check including criminal record history will be conducted prior to a new hire.
• The College is committed to maintaining an environment free of drugs and alcohol.

Anticipated Start Date

• LCC offers two start dates for new employees: the 1st and 16th (or the closest working day).

Jeanne Clery Statement

• Lower Columbia College reports mandated safety and security information, required statistics, and related information for the past three (3) calendar years.
• Annual Security and Fire Safety Report is available at: lowercolumbia.edu/CleryASFR.

Declaration Regarding Sexual Misconduct

• Per RCW 28B.112.080, applicants must declare whether they are the subject of any substantiated findings of sexual misconduct or are currently being investigated, or left a position during an investigation into a violation of any sexual misconduct policy at current or past employers or professional associations.
• Post-secondary education institutions cannot hire an applicant who does not complete this form.