Data Consultant 4 - Educator Data, Research and Development

Description

• We support a healthy work/life balance by offering flexible/alternative work schedules and mobile and telework options. (Depending on job duties and work location.)
• We have an Infant at Work Program that is based on long-term values of newborns and infant-parent bonding. Eligible employees who are new parents or legal guardians can bring their infant (six weeks to six months) when returning to work. (Depending on job duties and work location.)
• We value and are actively involved in promoting diversity, equity and inclusion within OSPI by way of cross-divisional, collaborative committee. The focus of the committee includes employee engagement and education; reinforcing OSPI values; and maximizing the value of diversity and identifying strategies for inclusion.

• Goes beyond equality; it requires education leaders to examine the ways current policies and practices result in disparate outcomes for our students of color, students living in poverty, students receiving special education and English Learner services, students who identify as LGBTQ , and highly mobile student populations.
• Requires education leaders to develop an understanding of historical contexts; engage students, families, and community representatives as partners in decision-making; and actively dismantle systemic barriers, replacing them with policies and practices that ensure all students have access to the instruction and support they need to succeed in our schools.

Key Responsibilities

• Build new Structured Query Language (SQL) codes, including views and functions to compute counts and percent using source tables; rebuild and modify existing SQL codes and maintain, analyze, and report on all aspects of electronic educator records, including but not limited to teaching assignments, educator demographics, transcripts and educator performance, certifications, and endorsement.
• Build and modify database, database objects, and business rules to increase data accuracy and optimize data process system and computation; Research and advocate for improved data practices, especially as they pertain to educator workforce (strategic goal 3) and other OSPI strategic goals; Create innovative solutions to improve data processes.
• Integrate data from various sources (educator, student, financial, etc.) to develop meaningful and accurate reports and reporting tools for diverse audiences.
• Verify accuracy and integrity of data, including educator data files and reports.
• Design, develop, and ensure proper implementation of processes and procedures for maintaining educator data and records; Ensure confidentiality and privacy of educator and student information.
• Perform complex data management functions and statistical analyses for internal and external reports and reporting tools.
• Build and modify Tableau workbooks and create new ones to display educator measures coherently and understandably using a global filter, tooltips, precedence, and other functions.
• Communicate clearly and consult with other data analysts and program offices to deepen understanding of the scope of the Tableau workbooks, audience, and linkage between data display/analysis and program offices’ vision/priority/goal, tasks, and state and federal mandates.
• Collaborate with team members, departments, and stakeholders to develop real-time standard data reports and interactive dashboards.
• A basic level of knowledge and skills of the agency's Tableau server system and process to test and publish the Tableau workbook to the district secure portal, test site, and public site; Knowledge and skill of changing and modifying languages for publicly any available Tableau Workbooks on the Data Display site.
• Develop strategies and implement solutions to improve data quality, reporting, dissemination, and analysis; Identify opportunities for process improvement and strategize, propose, and implement technological solutions as appropriate.
• Accurately estimate and track timelines and develop procedures to accomplish data requests, analysis, reports, and projects; Manage multiple projects by accurately tracking progress and status and identifying uncertainty and barriers; Generate solutions for identified obstacles and challenges to accomplish projects and tasks within timeline; Able to consult to change the timeline to produce accurate and practical output or products.
• Assist in organizing the Educator Data, Research and Development data governance process and monitor data requests and the agency's data collection and system updates to provide responsive services; build and share tables and functions that contribute to systematic data structure and improve data quality and consistency in all data domains, including educator, student, and finance.
• Prepare and facilitate data discussion to raise the level of data display and report for our data end user.
• Develop research and data analysis to present in data conferences, including the National Center for Education Statistics (NCES) Stats-DC Data Conference, Washington Education Research Association, and American Education Research Association.
• Build and maintain centralized table(s) for educator growth and development research using the educator career continuum under the direction of the Director of Educator Data, Research, and Development; collaborate with other data analysts in the department to build systematic table structure, including response variables and predictor variables; and build views, functions, and stored procedures to optimize table building and maintenance.

Required Qualifications:

• Bachelor's degree in education, statistics, computer information science, business, accounting, economics, social services, or related fields.
• Have three years of experience in data management, data analysis, research/evaluation, data governance, or experience in a related field.

• Skilled in writing SQL queries or other program languages for data verification and quality assurance purposes and creating analysis-ready data tables.
• Experienced or proficient with computer database software, analytical tools, and other programming languages, including SQL, R or Python, HTML, C#, ArcGIS, and/or other IT-related languages or applications.
• Skilled in performing descriptive statistical calculations and data manipulations.
• Able to identify key facts in a range of data; Notices when data is inaccurate, incomplete, or needs verification; Distinguishes information not pertinent to a decision or solution.
• Breaks down complex information into parts. Sorts and groups data and applies relationships. Sees underlying principles, patterns, or themes in various related information.
• Detailed-oriented, strong organizational skills, and ability to multi-task in a fast-paced environment.
• Strong initiative-taker with a positive, can-do attitude, with the ability to work independently and as a team member in a fast-paced environment under tight deadlines.
• Strong commitment to trust, teamwork, and collaboration principles by demonstrating transparent communication.
• Excellent written and verbal communication skills.
• Ability to establish and maintain effective working relationships with various people in a multicultural, diverse socioeconomic setting; Participate and conduct work as a team member.
• Ability to maintain the highest degree of confidentiality; Knowledge and experience of educator confidentiality and related state statutes, as well as public record requests.

• Knowledge of the public K–12 data system.
• Experience in the public K–12 education system.
• Experienced in designing, building, and maintaining data dashboards; proficiency and experience in Tableau preferred.
• Ability to establish and maintain effective working relationships with people in a multi-cultural, diverse socioeconomic setting.
• Experience conducting longitudinal and multivariate analysis.
• Experience synthesizing research results.
• Skill in obtaining, exchanging, and clarifying information.
• Skilled in computer database software and other analytical tools.
• Skill in assessing problems, interpreting/clarifying needs, and developing solutions.
• Ability to accurately perform arithmetical and statistical calculations.
• Ability to effectively communicate technical information to non-technical personnel.
• Ability to write clear, concise, and valuable technical documentation.
• Ability to work under pressure and meet established deadlines.
• Ability to organize, prioritize, multi-task, and meet deadlines.
• Effective communication, collaboration, and leadership skills.
• Ability to maintain the highest degree of confidentiality.
• Ability to participate as a team member.

• A letter of interest specifically addressing the qualifications listed in this announcement;
• A current résumé, and;
• A list of three or more professional references.