Data Analyst

DATA ANALYST

(Full-Time Exempt)

Open Date: March 13th, 2024

Close Date: March 26th, 2024

Anticipated Start Date: May 1st, 2024

Our collaboratively developed shared definition of equity is that as a College “we aspire to ensure that all students, faculty, and staff have access to resources and support in proportion to their needs and that they feel respected, connected, and can thrive in their goals.” Peninsula College’s equity efforts are led by an Equity Standing Committee with cross-campus representation. The committee appoints equity work groups and develops, assesses, and updates an annual equity plan. That committee’s collective work has identified the need for a position that can lead the College’s work in equitable hiring practices and equity training for all employees and that can act as resource for the College’s equity partners by sharing expertise and leadership.

THE COLLEGE

Located in the northwest corner of the United States, Peninsula College is nestled in the foothills of the Olympic Mountains. The main campus in Port Angeles, Washington, overlooks the Strait of Juan de Fuca and the nearby city of Victoria, British Columbia, and has easy access to the Pacific Ocean, Olympic National Park, and Seattle. Port Angeles is two hours from Seattle and a one-hour ferry ride to Victoria, Canada. The College is honored to serve six sovereign American Indian nations in the region: Jamestown S’Klallam, Lower Elwha Klallam, Quileute, Makah, Hoh, and Port Gamble S’Klallam.

The College is honored to have strong relationships with these six federally recognized Tribes in the College’s service district. The College is home to Longhouse of Learning. It is the first Longhouse in the nation to be built on a community College campus. The College offers transferable Indigenous language courses in Klallam/S’Klallam, Makah and Quileute and Hoh languages. Instructional programs include a Tribal Homeland Security & Emergency Management certificate and an Integrated Indigenous Studies transfer pathway. The College is committed to doing more and taking future direction from the Tribes.

As a public comprehensive community college with baccalaureate-granting authority, Peninsula College is highly regarded by businesses, schools, and community partners for its culture of inclusiveness, innovation, high academic standards, and community engagement. The College is part of the 34-college Washington State Community and Technical College System and is accredited by the Northwest Commission on Colleges and Universities.

The College serves more than 2,500 students through its main campus and Port Townsend and Forks campuses, its correctional facilities, community education, and its online course offerings. The College community is vibrant, engaged, and known for its commitment to serving the diverse needs of the local communities across its 3,600 square mile service district.

The College culture is defined by its Guiding Principles and its shared governance model, which values respect, open and honest communication, integrity and collaboration. The College is a leader in the Guided Pathways work in Washington State and sees developing an equitable and socially just institution as a central part of that work. The College is highly regarded as a warm and welcoming place. Click here for a video about Peninsula College.

POSITION SUMMARY

This full-time position supports institutional research and student success in a highly collaborative and cooperative capacity. The research analyst will support the college's commitment to using data for continuous improvement, data integrity, transparency and accessibility by providing data and analysis for use in assessment, planning and reporting. This individual will be responsible for the extraction, transformation, and analysis of complex data sets to answer key institutional questions.

The candidate will need to be proficient in handling diverse types of data and formats, ranging from raw files to structured relational databases. The ability to present these insights through high-quality visualizations tailored to multiple audiences is crucial. A successful candidate will need to show that they can balance working as part of a team with a high degree of independence, managing competing priorities and overseeing projects.

ESSENTIAL FUNCTIONS

• Provide research and analysis in support of institutional effectiveness, assessment, and planning.
• Produce tables, graphs, dashboards, and narrative analyses of data to easily display, summarize, and communicate student success scenarios, e.g., retention, enrollment, graduation, etc.; develop and maintain a meaningful set of standard reports for internal and external audiences using tools such as SSRS, Tableau, and Power BI.
• Assist in responding to reporting requirements from governmental agencies, such as the U.S. Department of Education (IPEDS and Gainful Employment reporting) and the State Board for Community and Technical Colleges (student, employee, and financial reporting).
• Perform high-level database queries using Structured Query Language (SQL), PeopleSoft (Oracle), and other related technologies.
• Maintain the Data Mart Ticket Portal; evaluate, prioritize, and respond to ad hoc requests from administrators, faculty, staff, and outside entities in a timely manner.
• Using appropriate technology, automate and maintain daily FTE Reports, Finance Suite Reports, Tableau extract refreshes, and other processes as identified.
• Monitor institutional coding practices to ensure consistency and integrity of student and enrollment data.
• Serve on college committees as assigned, including Data Accountability Workgroup (DAWG) and Data Integration Group (DIG).
• Participate in college-wide Lean process improvement activities.
• Working collaboratively with cross-departmental teams, Design and develop software solutions to support research initiatives and data analysis.
• Provide professional development opportunities for the campus on the collection, understanding, application, and use of data and data products via training and data presentations.
• Support survey administration and reporting.

Competencies:

• Commitment to functioning as an effective team member.

• Strong interpersonal skills to interact with a diverse population with respect and dignity and in a manner that promotes an environment of inclusion, free from discrimination and harassment.

• Excellent analytic, written, and verbal skills.

• Ability to prioritize and manage multiple projects simultaneously.

• Ethics and integrity, and sound professional judgment.

• Commitment to student success.

• Strong planning and organizational skills.

Minimum Requirements

Prior work experience in database management.

Strong working knowledge of Structured Query Language (SQL).

Bachelor’s degree or equivalent professional experience in Data Sciences, Computer Science, Business Analytics, or related field.

Demonstrable experience in handling raw data files in CSV, JSON formats.

Demonstrated experience in advanced Excel functions.

Demonstrated skills with qualitative and quantitative analysis.

Preferred Qualifications

Prior experience with PeopleSoft/Oracle.

Knowledge of Washington State community/technical college data processing.

Prior experience with Tableau, Power BI, SQL Server Reporting Services (SSRS) or other reporting software.

Prior experience with programming such as Python, PowerShell, Microsoft Power Automate or similar language.

Prior experience with Microsoft Teams or other cloud-based collaboration tools (Google Docs).

Knowledge of Lean process improvement theory and practice.

Required work schedule and work environment:

• Work is typically performed in an office environment and requires standing and/or sitting and using computers for extended periods of time.

• Position requires the ability to travel to in-district and out-of-district events.

Required background clearance:

Yes.

EMPLOYMENT PAY AND BENEFITS INFORMATION

• Full-Time Exempt position; 40 hours a week; 8am-5pm
• Annual Salary Range: $68,000.00 - $73,000
• Anticipated monthly salary: $5,666.67 – $6083.33

Full Time Employee Benefits:

• Excellent benefits package including medical, dental, life, and long-term disability insurance; paid vacation and sick leave; retirement plan options; optional credit union and tax-deferred annuity programs. Peninsula College contributes $1,145 per month towards the cost of the Washington State employee insurance programs. The college also supports professional development.
• Peninsula College is a qualified employer for the Public Service Loan Forgiveness program. If you work for the College full time, have had Direct Loans and are on an eligible repayment plan, you are eligible to apply.
• Full-time employees are eligible to apply and participate in the Peninsula College Employee Tuition Program.
• Sick leave accrual is 8 hours per month.
• Vacation Leave accrual is 16 hours per month.

Application Submission Procedure:

A complete application file will include:

• a college employment application
• a cover letter addressing specific qualifications of this position, and provide a one to two sentence statement on how you may be able to contribute to a culture of equity at Peninsula College
• a current resume
• three current professional references qualified to assess your experience and ability to perform the duties specified. Please include references’ email addresses and telephone numbers

* In compliance with the Immigration and Naturalization Act, proof of authorization to work in the United States will be required at the time of hire.

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

Application materials may be uploaded electronically, by mail, or email:

Human Resources

Peninsula College

1502 E. Lauridsen Blvd.

Port Angeles, WA 98362

Phone: (360) 417-6298

Email: pchr@pencol.edu

Applications submitted electronically will be accepted without signatures.

Jeanne Clery Statement:

Notice of Availability of Annual Security Report—Peninsula College’s Annual Crime/Security Report is available here, containing mandated information about current campus policies concerning safety and security issues, required statistics, and other related information. To obtain a paper copy of the report, please call 360-417-6559.

Non-Discrimination and Anti-Harassment:

Peninsula College is compliant with Title IX best practices. For more information visit, Anti-Harassment and Nondiscrimination | Title IX.

Peninsula College does not discriminate on the basis of race, creed, color, religion, national origin, families with children, sex, marital status, sexual orientation, including gender identity, age, honorably discharged veteran or military status, genetic information, or the presence of any sensory, mental, or physical disability or the use of a trained dog guide or service animal by a person with a disability in its programs and activities. Coordination of compliance is the responsibility of the Human Resources Officer, Hanan Zawideh, hzawideh@pencol.edu, (360) 417-6212.

Requesting Accommodations for Employment:

Please contact the Peninsula College Human Resources office, 360-417-6298 or email pchr@pencol.edu to request for any accommodations.

Peninsula College is an equal opportunity employer

Job Type: Full-time

Pay: $68,000.00 - $73,000.00 per year

Benefits:

• 401(k)
• Dental insurance
• Health insurance

Schedule:

• Monday to Friday

Ability to Relocate:

• Port Angeles, WA 98362: Relocate before starting work (Required)

Work Location: In person