Job Title: Data Analyst
Reports to: Data Systems and Web Services Manager
Terms and Conditions: Full-time, 8 hours per day, 12 month position.
FLSA Status: Exempt
Salary: $75,000.00 - $83,000.00 annual salary, depending on qualifications
and experience. Full benefits package including medical dental, life
and retirement plan. Please click here for more information regarding
salary and benefits.

OPRF – WHO WE ARE…

Oak Park and River Forest High School, or OPRF, is a comprehensive public high school located in Oak Park, IL, a suburb eight miles due west of downtown Chicago. We are a one-school district, with the majority of our students coming from two sender districts, River Forest Public Schools District 90 and Oak Park Elementary School District 97. We offer more than 200 courses, a variety of programs for students with special needs, 103 clubs and activities, and 34 competitive sports. We prepare our students well for post-secondary success, with an average ACT composite score of 24 and a 96% graduation rate.

Oak Park and River Forest are communities that highly value diversity. OPRF is a founding member of the national Minority Student Achievement Network, and our school is racially and economically diverse, with about 48% of our 3,300 students identifying as African-American, Hispanic, multiracial, or Asian. Our villages have long embraced the LGBTQ community, and we have a significant mix of homeowners and renters.

We seek faculty and staff who have high expectations for all students, and who value student voice in education. As a school, we are particularly focused on closing opportunity gaps for our students of color and other under-represented groups. OPRF is an equal opportunity employer that provides equal employment opportunities to all without regard to race, color, religion, sex, national origin, age, disability or genetics. OPRF’s goal is to increase the diversity of its workforce.

OPRF is a great place for those who are interested in an environment that supports creativity, leadership at all levels, innovation, a focus on professional and curriculum development, and the best practices of instruction. We are currently seeking individuals to join our team that all students are capable of high levels of academic and social success.

Position Summary:

We are seeking a highly motivated Data Analyst to join our team. The ideal candidate will have a strong foundation in data analysis and visualization, with expertise in SQL. The position will be focused on extracting meaningful insights from large datasets, implementing reports and dashboards in tableau, and administering the tableau server software. Additionally, the role will assist with daily operations and support tickets for the Data Systems team. These tasks will occur within an educational setting and will service the faculty, staff, Administration, the Board of Education, students, and parents.

Responsibilities:

Data Extraction & Transformation:
- Write and execute complex SQL queries to extract, clean, and transform data from various sources (databases, Google Sheets, SFTP transfers, etc).
- Perform data quality checks and identify/resolve data inconsistencies.
- Assist the Database Administrator in creating and maintaining data pipelines and ETL processes.
Data Analysis & Visualization:
- Develop interactive dashboards and reports using Tableau to effectively communicate data insights.
- Conduct in-depth data analysis, identifying trends, patterns, and anomalies.
Business Intelligence for Education:
- Work with the Director of Assessment and Research to translate educational performance questions into actionable data analysis and reporting requirements.
- Collaborate with educators to understand their data needs and provide data-driven solutions.
- Proactively identify areas for data improvement and process optimization.
Data Governance:
- Ensure data integrity and compliance with data quality standards.
- Contribute to the development and maintenance of documentation and best practices.
Additional Duties:
- Provide Tableau server administration.
- Support end user interaction with the Student Information System (similar to an ERP but for education).
- Perform other duties as assigned by the Manager of Data Systems.

Qualifications:

Required:
- Bachelor's degree in Computer Science, Statistics, Mathematics, Economics, Data Science, or a related field.
- 2+ years of experience as a Data Analyst or in a similar role.
- Strong proficiency in SQL and data manipulation techniques.
- Experience with data visualization best practices and techniques.
- Strong analytical and problem-solving skills.

Preferred

- Familiarity with Tableau or similar BI software such as Power BI is a plus but not required.
- Familiarity with Tableau Prep is a plus but not required.
- Experience with data warehousing concepts and methodologies (preferred).
- Proficiency in scripting languages like Python or R (preferred).

Physical/Visual Skills and Demands:
Physical and visual demands of the position are consistent with standard office conditions. No non-standard lifting or visual acuity expected.

Environmental Conditions:
School building and facilities and computer office environment are the standard environmental conditions.

The information contained in this job description is for compliance with the Americans with Disabilities Act (ADA) and is not an exhaustive listing of the duties performed in this position. The individuals currently holding this position perform additional duties and additional duties may be assigned.

Please, no phone calls. The respective hiring manager will review candidates once the job posting closes. If selected to move forward, you will be contacted by phone or email. After reviewing the job posting, if you have any questions, please send an email to hr@oprfhs.org.

Oak Park & River Forest High School District 200 (OPRF) is an Equal Opportunity Employer