Jobs
>
Portland

    Data Analyst II - Portland, United States - Portland Public Schools

    Default job background
    Full time
    Description

    Posting Timeline

    PPS strongly encourages and recommends everyone who is able, to be vaccinated and remain current on the COVID-19 vaccine.

    This job is open until filled. Applications will be reviewed as received. Portland Public Schools reserves the right to make a hiring decision at any point during the posting period.

    Position Details

    Portland Public Schools (PPS) is seeking talented people from diverse backgrounds and experiences to lead change and inspire PPS students. At PPS, every employee, despite having different roles, is an educator. We hope to attract talented educators who model the core PPS Educator Essentials. 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. To learn more about Portland Public Schools, please visit the District website.

    BASIC FUNCTION:

    Under general direction, 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.

    REPRESENTATIVE DUTIES:

    The classification specification does not describe all duties performed by all incumbents within the class. This summary provides examples of typical tasks performed in this classification.

  • Responsible for all aspects of assigned small-to-large scale data analysis and reporting, including query and report design, programming and development, gathering and combining data from multiple sources and data manipulations and validation; extract, review, analyze, validate and maintain data sets and queries to compute statistical operations, disaggregate data and identify trends, patterns and abnormalities within data sets; respond to requests for a variety of ad-hoc data requests, queries and reports and conduct and monitor projects including those involving the data warehouse.
  • Organize and optimize data into user friendly formats, such as tabular, graphical or narrative representations, for clarity and use in analysis, evaluation and presentations; use web tools to create data reporting interfaces; develop customized reports, infographics and other data manipulations and assure reports meet standardized criteria, federal, state or other set requirements.
  • Develop and implement procedures, priorities and timelines for data cleanup to assure data is available to meet reporting timelines and other annual reporting processes and requirements; maintain and distribute reoccurring reports, ensure that reports meet requirements and are submitted in timely manner to remain in compliance with District, local, state, Federal and other reporting agencies.
  • Oversee the compilation, input, and/or loading of data from multiple sources, such as district testing programs, school sites, District offices and outside agencies and the optimization of these processes; provide detailed analysis of data collection structures and systems such as enrollment procedures, student attendance categories, transcripts and program components.
  • Review, validate, audit, correct, update, and analyze student information including demographics, attendance, grades, assessment requirements and results, discipline and similar information in district data warehouse and other databases and maintain separate databases as necessary for use in, or preparation of, a variety of specialized district, federal and state required reports.
  • Assure compliance with laws related to data collection, test security, student confidentiality and ensure student data is maintained and reported in accordance with local, state and Federal laws, codes, policies, guidelines; assist with, develop and revise processes, procedures, standards and guidelines related to data collection, queries, schools' student information databases and district integration of information.
  • Work with stakeholders to create new, or modify existing reports for program evaluations, grant applications, public information requests and other related needs; provide status updates and findings throughout projects, analysis or reporting cycle to key stakeholders.
  • Review and analyze system files and field functionality to determine the integrity of data; assess how files and included fields, tables and values can best be used by district users to serve students' and district's needs; develop new data related tools and reports to support effective data utilization; recommend and implement system enhancements and data solutions such as data warehousing, validation, access, security and integrity of student information; assist with system testing and the implementation of patches, system updates, form revisions, and software upgrades.
  • Utilizing best practices, participate in the creation, automation and standardization of queries and reports; prepare and present recommendations and implement solutions for the elimination, consolidation or addition of reports, or reporting standards that support the reduction of manual report generation or distribution.
  • Collaborate with colleagues and serve on cross-functional district teams to solve problems and improve data analysis, querying and reporting techniques; participate in, coordinate, plan, implement and maintain databases such as the district data warehouse and computerized student information systems.
  • Provide support, participate in, develop and present materials, trainings and other professional development opportunities to a wide variety of audiences including teachers, principals, district leadership and community stakeholders on a variety of data literacy topics including, data analysis, interpretation of assessment data or other data reports, reporting requirements, dashboard access and overall system use.
  • Keep current on research design, and statistical methodologies in education, psychology and social sciences; attend and participate in meetings, conferences, and seminars relevant to new developments in assessment, reporting requirements, compliance, data collection, analysis and distribution; lead, attend and participate in a variety of meetings, in-service trainings, workshops, conferences and seminars relevant to data analysis and reporting.
  • Demonstrate a commitment to the Portland Public Schools Equity Initiative by developing a thorough knowledge and application of the district Racial Educational Equity Policy, Equity in Public Purchasing and Contracting and other board policies; participate in staff development, in-services and trainings related to diversity, equity and inclusion in the workplace and in K – 12 education; model appropriate behaviors; develop, recommend and implement improvements to educational and business practices with awareness and understanding of their impact in a racially and culturally diverse community.
  • May serve on District's Institutional Review Board (IRB) to review and evaluate research proposals from internal staff and/or external researchers.
  • May serve in a lead capacity and provide work direction and guidance to designated staff.
  • Perform related duties as assigned.
  • DISTINGUISHING CHARACTERISTICS OF THE CLASS:

    All classifications in this series are responsible for the analysis and reporting of data and assuring that data entered into District Information Systems is accurate and complete. All levels within this series collect and review site-generated data, create, run and validate a variety of reports, conduct statistical correlations and disaggregate data, for internal use and external reporting; all levels contribute to and participate in the development and delivery of user training. The levels are differentiated by the scope of work performed, the levels of complexity in developing and generating data sets, leadership over processes and staff and input into cross-functional teams and activities related to system support and functionality.

    This classification series differs from other analyst classifications in that the Research, Assessment & Accountability Analysts gather and combine data from multiple sources and work with multiple databases as well as "big data". Data analysis processes performed by this series require working knowledge of and expertise in both computer programming and complex mathematical and/or statistical analysis.

    The Research, Assessment & Accountability Analyst II is the professional-level classification in the series. Employees in this classification perform the full scope of duties related to the collection, analysis, validation and dissemination of data and data reporting, requiring a comprehensive knowledge of multiple database systems and coding techniques. Employees develop and analyze complex queries, reports and big data sets, serving as a technical resource and subject matter expert in the field. The Research, Assessment & Accountability Analyst II participates in the mentoring, training and development of division staff.

    EMPLOYMENT STANDARDS:

    Knowledge of:

  • Data warehousing techniques, best practices, and management including data collection, maintenance, ETL (extract, transform, load) code/architecture, data profiling, data integration, and data cleansing.
  • Programming tools used for ETL automation such as Microsoft SSIS or Informatica.
  • Microsoft Office Suite or similar, presentation, word processing, publishing and spreadsheet software.
  • High level mathematics including complex statistics Statistical packages for analyzing large datasets such as SPSS, R, SAS or similar processes.
  • Record keeping techniques.
  • Effective customer service skills using tact, patience and courtesy.
  • Oral and written communication skills.
  • Data visualization software (example: Cognos, SSRS, Tableau or Power BI & Quicksight) their applications and uses.
  • Programming languages for data analysis and visualization and managing data in relational databases such as visual basic, SQL, Python or Julia.
  • Ability to:

  • Develop tables, databases, queries and spreadsheets.
  • Accurately collect, generate, validate and report on data; extract data from multiple sources, combine and manipulate data as needed.
  • Prioritize work and meet schedules and timelines; assure data reporting is completed in an accurate and timely manner.
  • Use a variety of databases and student information systems; learn and use a variety of student and employee software systems.
  • Troubleshoot and problem-solve data issues.
  • Maintain current knowledge of software or system upgrades, usage, and data manipulation techniques.
  • Use techniques and methodologies to analyze, manipulate and present data.
  • Access multiple complex data sets to perform statistical analyses and generate variety of reports Advocate, model, learn and implement Portland Public School's Racial Equity Initiative.
  • Participate in, develop and provide user training; communicate concepts and procedures to audiences with a broad range of data-literacy skills.
  • Read, understand and apply detailed information concerning district, state and federal data collection and reporting policies and procedures.
  • Serve as resource and provide procedural assistance related to data literacy and reporting. Communicate technical research or data concepts and procedures to a variety of audiences.
  • Ensure security of sensitive data.
  • Work under pressure and tight deadlines.
  • Establish and maintain cooperative and effective working relationships with others.
  • Operate a variety of technologies, computer equipment and various software programs relevant to educational assessment and research; input and retrieve data.
  • Education, Training and Experience:

    The Research, Assessment & Accountability Analyst II requires a bachelor's degree in computer science, mathematics, business information or other related field and a minimum of three (3) years of experience working with large data sets, generating reports, troubleshooting and resolving complex issues, developing tables, or two (2) years of experience as an Research, Assessment & Accountability Analyst I with Portland Public Schools is required.

    Experience working in a public K-12 school district or public agency serving and supporting a richly diverse community is highly desirable.

    Additional directly related, verifiable work experience may substitute for the Bachelor's degree on a year-for year basis. A Master's degree in one of the identified disciplines may substitute for two years of the required experience.

    Any other combination of education, training and experience which demonstrates the candidate is likely to possess the skill, knowledge, ability and trait characteristics essential for this classification may be considered.

    Candidate Preferences:

  • Structured Query Language (SQL)
  • SQL Server Reporting Services (SSRS)
  • Power BI
  • Git
  • Full featured IDE
  • Star schema fundamentals
  • Amazon Web Services (AWS)
  • Microsoft SQL Server
  • Data pipelines (ETL)
  • Python
  • Special Requirements:

    Some positions in these classifications require the use of a personal automobile and possession of a valid driver's license.

    WORKING CONDITIONS:

    The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Persons with certain disabilities may be capable of performing the essential duties of this class with or without reasonable accommodation, depending on the nature of the disability.

    Work Environment: Work is performed primarily in a standard office environment and on school campuses with public contact and frequent interruptions.

    Hazards: None.

    Physical Demands: Primary functions require sufficient physical ability and mobility to work in an office and school setting and to routinely drive to and from District facilities; dexterity of hands and fingers to operate a computer keyboard and office equipment; sitting, standing and walking for extended periods of time; occasional kneeling, bending at the waist; lifting, pushing, pulling and carrying office equipment, computers, laptops and peripheral equipment, supplies and materials weighing up to 10 pounds; repetitive hand movement and fine coordination to use a computer keyboard; hearing and speaking to exchange information in person and on the telephone; seeing to read, prepare and assure the accuracy of documents.

    CLASSIFICATION AND SALARY:

    This position is classified as RAA Data Analyst II , Pay Grade 25 on the Non-Represented, Confidential, Professional and Management Employees salary schedule FLSA Non-Exempt.

    The Non-Represented Confidential Professional Management and Employees Salary Schedule for 260 day employees can be found .

    This position is a 260 day work year.

    Salary Range: RAA Data Analyst II: $76,869 - $91,785

    Benefits Information

    Portland Public Schools (PPS) offers several competitive and comprehensive benefit packages to employees. Fringe benefits include medical, dental, vision, prescription, life and disability insurance, employee assistance program, 403(b) retirement savings plan and various leave and professional development programs. Depending on the insurance option selected by the employee, there may be an employee contribution toward insurance.

    Portland Public Schools is a public employer and participates in the Public Employees Retirement System (PERS/OPSRP). Eligible employees are required by statute to contribute 6% of salary on a pre-tax basis to OPSRP/IAP, after serving six months under a PERS employer.


  • azad technology partners

    Data Analyst

    2 weeks ago


    azad technology partners Portland, United States

    Join AZAD Technology Partners as a Data Analyst and be an impactful contributor that will draft Extract, Transformation and Loading (ETL) procedures for implementing data integration and data migration tasks in support of Data Warehousing and other data integration projects withi ...

  • Currie & Brown

    Data Analyst

    2 days ago


    Currie & Brown Portland, United States

    Currie & Brown is currently looking for an experienced Data Analyst to join our team in Portland. The successful candidate will have a strong background in SQL, Python, and PowerBI, with a proven track record of leveraging these tools to deliver quality data management and report ...

  • New Relic

    Data Analyst

    6 days ago


    New Relic Portland, United States

    Data Analyst · Data Analyst · Data Analyst Your opportunity We are seeking a dedicated Data Analyst to join our GTM Analytics team and play a vital role in uncovering valuable insights about our customers and user engagement across our product portfolio. Your main focus will be ...

  • Native American Rehabilitation Association

    Data Analyst

    6 days ago


    Native American Rehabilitation Association Portland, United States

    Title: Data Analyst · Location: Oyate SW Madison St, Portland, OR 97205 · Schedule: This is a hybrid position, Monday through Friday 8:30am-5pm. · Wage Range: $25-$35, non-exempt · If you are a motivated and dedicated Data Analyst looking for an opportunity to contribute to a ...

  • Currie & Brown

    Data Analyst

    6 days ago


    Currie & Brown Portland, United States

    Currie & Brown is currently looking for an experienced Data Analyst to join our team in Portland. The successful candidate will have a strong background in SQL, Python, and PowerBI, with a proven track record of leveraging these tools to deliver quality data management and report ...

  • TotalMed Staffing

    Data Analyst

    3 days ago


    TotalMed Staffing Portland, United States

    We are seeking a Health Plan Data Analyst for an assignment in Portland Oregon. A data analyst collects and stores data on sales numbers, market research, logistics, linguistics, or other behaviors. They bring technical expertise to ensure the quality and accuracy of that data, t ...

  • Precoa

    Data Analyst

    1 week ago


    Precoa Portland, United States

    · Position at Precoa · Data Analyst · Enable enhanced decision-making in a dynamic company · You're a master of creatively communicating with data and numbers. You pride yourself on your "figure it out" mentality and ability to collaborate in a fast-paced environment with a d ...

  • PSRTEK Inc

    Data Analyst

    6 days ago


    PSRTEK Inc Portland, United States

    Job Description: Data Analyst / Product Owner: Provider Data · Location: US Location (PST Time Zone) · REQUIREMENTS (hard requirements, candidates need each of these. Please clearly call out in submittal notes) · 8 + years min. · Data Warehousing Technical Solutions: Understa ...

  • INSPYR Solutions

    Data Analyst

    6 days ago


    INSPYR Solutions Portland, United States

    Title: Data Analyst · Location: Remote, US · Duration: 5 months+ · Compensation: $54/hr - $57/hr · Work Requirements: US Citizen, GC Holders or Authorized to Work in the US · If you're interested, please send your resume to Sydney Tekstra at · FULLY REMOTE POSITION - NO LO ...

  • Precoa

    Data Analyst

    4 days ago


    Precoa Portland, United States

    Job Description · Job Description · Data Analyst · Enable enhanced decision-making in a dynamic · company · You're a master of creatively communicating with data and numbers. You pride yourself on your "figure it out" mentality and ability to collaborate in a fast-paced enviro ...


  • Astrix Technology Portland, United States

    Data & Reporting Analyst · Clinical Data Management · Portland, OR, US · Pay Rate Low: 19 | Pay Rate High: 20 · Added - 12/06/2024 · Apply for Job · A growing client in medical device manufacturing is hiring a DATA & REPORTING ANALYST I on a remote contract assignment With their ...


  • CareOregon Portland, United States

    Career Opportunities: IS Data Quality Analyst Requisition ID · 24186 · - Posted · 06/07/2024 · - · CareOregon · - · Full Time - Permanent · - · Portland · - Multi Location (16) · Job Description Print Preview · Candidates hired for remote positions must reside in Orego ...


  • CareOregon Portland, United States

    Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin. · Job Title · IS Data Quality Analyst · Exemption Status · Exempt · Department · Business Intelligence · Manager Title · IS Development Man ...


  • CareOregon Portland, United States

    Career Opportunities: IS Data Quality Analyst · Requisition ID · 23783 · - Posted · 01/02/2024 · - · CareOregon · - · Full Time - Permanent · - · Portland · - · Multi Location (1) · Job Title · IS Data Quality Analyst · Exemption Status · Exempt · Department · B ...

  • Portland Public Schools

    Data Analyst I

    6 days ago


    Portland Public Schools Portland, United States

    Posting Timeline · PPS strongly encourages and recommends everyone who is able, to be vaccinated and remain current on the COVID-19 vaccine. · This job is open until filled. Applications will be reviewed as received. Portland Public Schools reserves the right to make a hiring ...

  • Mediavine

    Data Analyst II

    1 day ago


    Mediavine Portland, United States

    Mediavine is seeking a Data Analyst II to join our Engineering team. We are looking for someone who enjoys solving interesting problems and wants to work with a small team of talented engineers on a product used by thousands of publishers. · About Mediavine · Mediavine is a fas ...

  • SHINE Career Collective, LLC

    Energy Data Analyst

    6 days ago


    SHINE Career Collective, LLC Portland, United States

    AESC is an energy consulting firm that drives solutions towards a clean energy future and with a collaborative and professional work environment. We are passionate about what we do and are looking for talented people who share our passion to effect change and better our society a ...

  • Workoo Technologies

    Remote Data Analyst

    3 days ago


    Workoo Technologies Portland, United States

    About the job Remote Data Analyst · Position Guide · The Information Entry Driver is in charge of processing child help settlements in the SDU (Condition Dispensation Unit) body based on Standard procedure. Additionally, the Data Entry Driver are going to be responsible for var ...

  • Powin Corporation

    Data Analyst, Sr

    6 days ago


    Powin Corporation Portland, United States

    We're Building the Future Ever want to do hard work that will make a REAL difference in the world? Do you want to solve some of the most difficult problems with a team of exceptional players at a company that does not believe in impossible? · About Powin: · Powin Energy is a l ...


  • Sevita Portland, United States Full time

    · OUR MISSION AND PERFORMANCE EXPECTATIONS · At Sevita, we believe that everyone deserves to live well. For more than 50 years, our team members have provided home and community-based health care for adults, children, and their families across the United States. Our extraordina ...