Description

Position Summary:
The salary range for this position is $67,716.00 to $82,512.00 annually. The Research Data Analyst is an 18-month, non-permanent appointment. This position is approved to work fully remotely. Candidates for this position must live in, or be willing to relocate to, Washington State. This position reports to the Dean of Institutional Research and Effectiveness and requires regular and consistent attendance. 

The mission of Pierce College is to create quality educational opportunities to a diverse community of learners to thrive in an evolving world. The Pierce College District is committed to being an anti-racist institution; to truly be anti-racist we must work deliberately to eliminate barriers that have prevented the most promising and capable students from entering and thriving in college. We work to ensure that every student in the Pierce College District feels valued, respected, and inspired to achieve their goals. We provide a brave space for Black, Indigenous, Persons of Color (BIPOC), LGBTQ/QTPOC students, students with disabilities, and all students and staff to seek refuge, and an opportunity for them to cultivate their strengths, intelligence, resilience, and creativity.

To learn more about our Equity, Engagement, and Belonging efforts, please visit: https://www.pierce.ctc.edu/equity-engagement-and-belonging.

The Research Data Analyst is a key member of the Institutional Research team, contributing to the College's data and research efforts. The department supports the college’s mission and commitment to student belonging, learning, and thriving by providing quality, accessible, reliable, and relevant information to facilitate decision-making and planning processes, enhance institutional effectiveness, and support an institutional climate of evidence-based inquiry.

Reporting to the Dean of Institutional Research and Effectiveness, the Research Data Analyst collaborates with Business Systems Analysts, Web Services, and other stakeholders to enhance data accessibility within the institution, ensuring accurate and efficient delivery of information. The Research Data Analyst develops interactive data visualizations, dashboards, and reports, that translate complex datasets into actionable information for the institution.

To view the full job bulletin, and to apply, please visit: https://www.schooljobs.com/careers/piercedist/jobs/5051800/research-data-analyst-data-consultant-3?pagetype=transferJobs 

Requirements

Essential Functions:

Data Management and Visualization

• Query data in a complex, multi-table database using SQL.
• Assure data quality and integrity.
• Build, test, and fully implement clear and accessible data visualizations for the college.
• Create and maintain data dictionaries associated with the college’s data reporting and visualizations.

Data Governance and Data Integrity

• Assist in training on the use of data visualizations produced by the Institutional Research Department.
• Provide consultation and data support as directed by the Dean of Institutional Research and Effectiveness.  

Strategic Analysis and Collaboration

• Interpret data and offer recommendations to the Dean of Institutional Research and Effectiveness and other stakeholders.
• Collaborate with various departments to identify opportunities for process improvement and reporting.
• Report on institutional performance indicators and grant metrics.
• Foster a culture of inquiry, improvement, and evidence-based decision-making.

Required Education:

• Associates Degree from an accredited college or equivalent work experience in data analytics, data science, computer science, or information technology.
• Education to Experience Equivalences: Associates Degree = 2 years | Bachelors Degree = 4 years | Masters Degree = 5 years

Required Experience:

• Demonstrated experience with database software and analytical tools, such as SQL, Power BI or related program, and how to use these tools to manage, move and summarize data.
• Demonstrated experience with MS Office Suite (Word, Excel, etc.)
• Ability to communicate effectively with individuals and groups at various stages of data fluency.

Special Requirements:

• The successful candidate must consent to and pass a criminal background check after a conditional offer of employment. 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 Requirements:

To be considered for this position, applicants must:

• Meet the required qualifications as outlined in this announcement.
• Complete the online application profile at: https://www.schooljobs.com/careers/piercedist/jobs/5051800/research-data-analyst-data-consultant-3?pagetype=transferJobs.
• Apply for the specific job opening.
• Upload (attach) a cover letter that addresses how you meet the required qualifications as outlined in this announcement. (Cover Letter)
• Upload (attach) detailed résumé of all educational and professional experience. (Résumé)
• Transcripts are not required in order to apply for this position; however, if you are selected for an interview, you will be asked to bring copies of unofficial transcripts showing completion of the required level of education. Please upload current copies of your transcripts, if available. Unofficial copies of all college and university transcripts must include degree received and conferral date. International transcripts must include a foreign transcript evaluation. For a list of approved credential evaluation services visit: https://www.naces.org/members (Unofficial transcripts acceptable for application process; official transcripts required upon hire). (Transcripts)
• Upload (attach) a list of at least three (3) professional references with names, telephone numbers, and e-mail addresses. At least one reference must be your current or most recent supervisor. Letters of recommendation will not be accepted. (References)
• Provide a response to the following question as a supplemental attachment. Our recommendation is to create your code in a separate application, convert it to a .txt file, and then upload that .txt file as a supplemental attachment. (Supplemental Question):
  •  Scenario: You have two tables: Transcripts(StudentID, Term, CourseName, CourseID, CourseCreditsEarned) and Student_Groups(StudentID, Term, GroupCode). Each student belongs to one of three family status GroupCodes in a given term: 'SING' (single parent students), 'PART' (parenting students in a relationship) or 'NONE' (students with no dependents).
  • Task: Write a SQL query to identify if students have completed a total of 12 or more credits across the following three terms: 'Fall 2024', 'Winter 2025', and 'Spring 2025'. The output should include: StudentID, the student’s most current FamilyStatus (from Student_Groups), and the student’s CompletionStatus (indicating if the student completed 12-credits in three terms).

Special Note: To ensure consideration, application materials should be received no later than 5:00 p.m. on the closing date.