Data Analyst

Lower Columbia College; Longview (WA); Híbrido; USD 65.000 - 95.000; Jornada completa

Descripción de la vacante

Lower Columbia College is seeking a Data Analyst to manage the institutional research data warehouse, run SQL queries, and build dashboards for enrollment and success metrics. The role collaborates with institutional research staff and college leadership to support data-driven decisions.

The ideal candidate will have strong SQL skills, experience with Access, and knowledge of Python or R for data processing and visualization.

Formación

• 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.
• Experience with Microsoft Access or similar relational database, including data management and query functions.
• Proficient with general office technologies including Word/Google Docs, Excel/Google Sheets, and PowerPoint/Google Slides.

Responsabilidades

• Manage the institutional research data warehouse and related databases.
• Perform high‑level database queries using SQL and other technologies.
• Develop and maintain enrollment reports and related processes with institutional research staff.
• Maintain documentation of data processes, definitions, and reports.
• Monitor data quality and data governance compliance.
• Develop and maintain data dashboards using Tableau.
• Produce tables, graphs and narrative analyses of data, including statistical techniques.
• Leverage Python or R for data processing and visualization to automate reporting.
• Support monitoring, accreditation, and ad-hoc data requests as needed.
• Assist with survey administration and reporting while ensuring FERPA compliance.
• Prioritize multiple data requests and projects; conduct longitudinal and cohort tracking as needed.
• Support PeopleSoft (PS) Query Development.

Conocimientos

SQL

Microsoft Access

Python

R

Tableau

Data visualization

Data governance

Communication

Teamwork

Educación

Bachelor’s degree in information systems or computer science or related field

Herramientas

Oracle/PeopleSoft

Descripción del empleo

At a Glance!

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.

About the Team!

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.

DEI at LCC!

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 PeopleSoft (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.

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.

The minimum qualifications may seem specific and limiting, but we do consider candidates with relatable education, experience, and skills. We encourage you to apply even if you don't meet exactly what's listed. With questions about qualifications, feel free to reach out to our HR team.

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.

Residency Requirement

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.

Lower Columbia College Human Resources

For any questions regarding this job advertisement and/or department or campus culture, please call our Human Resources office at [phone], or email us directly at [e-mail].

Equal Employment Opportunity

Lower Columbia College provides equal opportunity in education and employment and does not discriminate on the basis of race, color, national origin, citizenship or immigration status, age, perceived or actual physical or mental disability, pregnancy, genetic information, sex, sexual orientation, gender identity, marital status, creed, religion, honorably discharged veteran or military status, or use of a trained guide dog or service animal as required by Title VI of the Civil Rights Act of 1964, Title VII of the Civil Rights Act of 1964, Title IX of the Educational Amendments of 1972, Sections 504 and 508 of the Rehabilitation Act of 1973, the Americans with Disabilities Act and ADA Amendment Act, the Age Discrimination Act of 1975, the Violence Against Women Reauthorization Act and Washington State's Law Against Discrimination, Chapter 49.60 RCW and their implementing regulations. All Inquiries regarding compliance with Title IX, access, equal opportunity and/or grievance procedures should be directed to Jason Arrowsmith, Director of Security, 1600 Maple Street, PO Box 3010, Longview, WA 98632, [e-mail], Phone number, [phone], Phone number/TTY [phone].

• Learn more on our Non-Discrimination and Anti-Harassment page.
• The college is compliant with Title IX best practices. For more information, visit About Title IX.
• The college encourages qualified members of protected classes to apply.

Diversity, Equity & Inclusion

LCC celebrates and embraces diversity of all kinds, including differing beliefs, cultures, people, and experiences. We commit to institutional and individual changes that recognize, understand, and challenge patterns of social inequity and systemic disparities within our ever-changing world. For more information, see Diversity & Equity.

Jeanne Clery Statement: Notice of Availability of Annual Security and Fire Safety Report:

In compliance with the Jeanne Clery Disclosure of Campus Security Policy and Crime Statistics Act of 1998, and as a part of the College's commitment to safety and security on campus, Lower Columbia College reports the mandated information about current campus policies concerning safety and security issues, the required statistics, and other related information for the past three (3) calendar years. Lower Columbia College's Annual Security and Fire Safety Report is available online at lowercolumbia.edu/CleryASFR.

Declaration Regarding Sexual Misconduct

Pursuant to RCW 28B.112.080, applicants must declare whether they are the subject of any substantiated findings of sexual misconduct in any current or former employment or professional association or is currently being investigated for, or have left a position during an investigation into, a violation of any sexual misconduct policy at the applicant’s current or past employers or professional association. By law, post-secondary education institutions cannot hire an applicant who does not complete this form.

Mission, Vision & Values

Our Mission, Vision & Values define our reason for being, and provide the framework for planning and improvement efforts at LCC. For details on LCC's Mission, Vision & Values, see our Strategic Plan.

Conditions of Employment

• If you are hired, you will need to provide proof of identity and documentation of U.S. citizenship or appropriate legal authorization to work for the duration of this position as required by the Immigration Reform Control Act of 1995.
• Prior to a new hire, a background check including criminal record history will be conducted. Information from the background check will not necessarily preclude employment but will be considered in determining the applicant's suitability and competence to perform in the position.
• The College is committed to maintain an environment for teaching and learning which is 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.