RAA Data Analyst II or III
Portland Public Schools
Research, Assessment & Accountability Data Analyst II OR III
How To Apply: Please visit www.pps.net/jobs and use job number 26104 to apply.
RAA Data Analyst II Salary: $73,912 - $88,255
RAA Data Analyst III Salary: $99,055 - $107,530
Benefits inclusive of Medical, Dental, Vision, Prescription, EAP, Retirement, and more!
About the Role
Portland Public Schools is actively seeking a RAA Data Analyst II OR III to conduct complex small-to-large scale data, statistical and mathematical analysis and query or database program optimization, including query development and data validation, to provide meaningful data and information for use in a variety of district programs and reports; create queries, validate and audit data and use moderate to advanced statistical techniques and programs to synthesize, transform, combine and manipulate multifaceted and complex data sets from multiple sources into reports or other representations; provide training and assistance in support of assessment requirements, data collection and interpretation, reporting and analysis. With the District’s focus on eliminating systemic racism and its adverse impact on student learning, we seek to hire individuals who bring to our district a deep commitment to racial equity and social justice.
Bachelor’s degree in computer science, mathematics, business information, or other related field. Additional directly related, verifiable work experience may substitute for the Bachelor’s degree on a year-for year basis.
* MS SQL Server and SQL Server Reporting Services (SSRS)
* Microsoft Visual Studio (2019) & Power BI
* Git (Azure)
* Python (Intermediate to Expert)
* Google Workspace API
* Extract, Transform, and Load (ETL - Python, TSQL, etc…)
* Knowledge of Star Scheme Fundamentals
* Cloud experience (Ex: Azure & AWS or Lambda/Glue)
RAA Data Analyst II:
3 years of experience working with large data sets, generating reports, troubleshooting and resolving complex issues, and developing tables.
RAA Data Analyst III:
5 years of experience providing highly complex and difficult technical support, expertise analyzing and implementing data solutions related to data warehousing, validation, access, troubleshooting and resolving complex issues, developing sophisticated multi-level tables, models or reports and developing and presenting training is required.