Data Analyst
Salary undisclosed
Checking job availability...
Original
Simplified
- Position Type: Technology/Media Services/Data Systems Analyst
- Date Posted: 2/3/2025
- Location: Oak Park and River Forest High School
- Date Available: ASAP
- Closing Date: 02/14/2025
Reports to: Manager, Data Systems and Web Services
Terms and Conditions: Full-time, 12-month position.
FLSA Status: Exempt
Salary: Base salary $75,000 - $83,000 depending on qualification and experience; competitive benefits package, including participation in Illinois Municipal Retirement Fund (IMRF) pension system.
Please, no phone calls. Applications and all supplemental materials are only accepted through theDistrict’s online application system. Any application materials provided outside this system will not be acknowledged. 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 [email protected].
Oprf – Who We Are…
Oak Park and River Forest High School, or OPRF, is a comprehensive public high school located in Oak Park, Ill., 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, 75 clubs and activities, and 29 competitive sports. We prepare our students well for post-secondary success, with an average ACT composite score of 24 and a 94% 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 44% 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.
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 its representation of people of color.
Background
Oak Park and River Forest High School District 200 is a progressive district that is focused not only on our tradition of excellence but our future. The District prides itself in offering our students a comprehensive 9-12 college and career readiness curriculum and a rich arts education program. Our students are curious, creative, and they come ready to learn. More than 90 percent of our students go on to college.
Oak Park and River Forest High School District 200 believes that we can “become an ever-improving model of equity and excellence that will enable all students to achieve their full potential.” We can accomplish this through dedicated teachers, staff, and administration who build relationships with students and have high expectations for themselves and their students. We believe in planning for and providing the academic and developmental support students need to meet those expectations. We further believe that every student can learn through exposure to academically challenging content, feedback during learning, and the educator’s knowledge and skill.
Oak Park and River Forest High School District 200 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 where we enable all students to achieve their full potential every day.
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 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 data 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.
- 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 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.
This position description should not be considered to contain every function/responsibility that an individual may be asked to perform by his/her supervisor. Employees are expected to perform other related functions as assigned.
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.
Oak Park & River Forest High School District 200 (OPRF) is an Equal Opportunity Employer.
This position description should not be considered to contain every function/responsibility that an individual may be asked to perform by his/her supervisor. Employees are expected to perform other related functions as assigned.