Senior Data Scientist 3
Job Description
The Washington State Health Care Authority’s Education Research and Data Center (ERDC) supports the ongoing operation of the ERDC P-20W longitudinal data environment, with a focus on research, reporting, and data provisioning. As a Senior Data Scientist 3, you will serve as a data steward for one or more P-20W data sources or domains and help translate education and workforce data into datasets, reports, and dashboards.
This hybrid role is based in Olympia, WA, with most work completed through telework, plus travel for in-person meetings, activities, and events as business needs require.
What you’ll do
- Support ERDC staff and external data requesters in using the P-20W longitudinal data environment.
- Identify new data sources aligned with ERDC research and analysis priorities, assess and coordinate feasibility for inclusion, and coordinate work that may include internal and external communication, data element identification, DSA amendments, and pre-delivery testing.
- Work with the databases, files, fields, and attributes that comprise the P-20W environment, including education and workforce data and additional sources used to augment analysis.
- Analyze data characteristics, attributes, trends, and data quality or completeness using tools such as SQL, SAS, Python, or R.
- Collaborate with the Forecasting and Research Systems team, contractors, and ERDC staff to build tools and processes that improve access and usability of P-20W data.
- Contribute to requirements for automated reports, analysis tools, interface designs, data marts, and research datasets tied to reporting needs.
- Gather and clarify stakeholder needs by developing detailed requirements with partners, stakeholders, and customers.
- Use SQL, SAS, Python, or R to compile data to meet requirements, and use SSRS, Tableau, or Power BI to produce reports and dashboards.
- Lead and maintain onboarding materials for external data requesters, data contributors, boards, and other entities through protocols, processes, trainings, workforce guides, and resource libraries to increase data literacy.
- Increase adoption of ERDC data products by producing the ERDC newsletter, maintaining the ERDC website, and presenting to communities including policymakers, state agencies, community-based organizations, and funders.
- Support correct data citations for ERDC data products and perform occasional environmental scans to understand how other entities use ERDC data.
- Support Data Governance activities such as data sharing, authorization, and documentation updates to support timely operations.
- Update, document, and manage ERDC’s disclosure avoidance approach, including technical and non-technical documentation and product review prior to release from the Education Data Enclave.
- Develop procedures to suppress, redact, recode, or blur data to prevent student identification.
- Monitor and evaluate emerging data science technologies and provide resources for adapting to new approaches.
- Serve as data steward for assigned sources, including organizational-level datasets (such as OSPI directory data), publicly available data (such as Census data), and postsecondary data (such as Private Career College data).
- Maintain knowledge of assigned data sources, including business context, collection rationale, intended uses, data files and elements, values, and business rules.
- Ensure data use aligns with data-sharing agreement terms and applicable privacy, disclosure, and confidentiality requirements.
- Maintain relationships with data owners and subject matter experts across state agencies to clarify definitions, resolve questions, and facilitate information exchange.
- Profile and process large datasets for statistical modeling and analysis.
- Collect, code, and classify data across multiple sources and formats, and perform data cleanup to improve quality for analysis and research aligned to models such as CEDS.
- Develop specifications and requirements for classifications and coding algorithms to identify items and data sources.
- Assess suitability of research methods and results, complete quality assurance, and generate data documentation describing data sources and elements.
- Facilitate appropriate data use by applying expertise of the data source or domain, including determining fit for different request types.
- Document and communicate metadata and program or policy details that can affect data use.
- Support the data custodian in loading data into the P20W environment by maintaining working knowledge of the system structure.
- Review and provide input into source-to-target (STM) mapping elements and business rules, and communicate changes to the data custodian to support loading schedules based on availability and business need.
- Create education research databases, files, and data systems for internal research and for external fulfillment, including reviewing requests and determining fulfillment approaches.
- Clean, aggregate, and manipulate data to extract selected elements and build analysis-ready files, including organizing, stacking, and converting files.
- Test and validate analytical files before release, complete required documentation, and support collaborative analysis work for education and workforce programs and services.
- Aid with ad hoc analysis and reporting for time-sensitive requests from the Governor’s budget and policy staff, legislators and legislative staff, and state education agency staff, and assist with presentation materials for legislative committees or hearings as needed.
- Communicate complex data and analysis clearly, including to audiences with limited knowledge of research and statistical methods.
Required skills and experience
- Extensive experience managing, preparing, and analyzing large, complex datasets in research, statistical, or other data-intensive environments.
- Extensive experience presenting complex data and concepts to varied audiences including legislative staff, community-based organizations, state agencies, and the public.
- Advanced skills with statistical software or programming languages including R, Python, SAS, or SQL, including extracting, cleaning, transforming, validating, and analyzing data from multiple sources.
- Advanced knowledge of data structures, database relationships, data elements, metadata, data definitions, and business rules, including how collection and quality influence research and analysis.
- Proficiency assessing data quality, completeness, consistency, and suitability for analysis, including identifying data limitations and recommending methods to address data quality issues.
- Experience serving as a data steward or subject matter resource, including documenting data definitions, business rules, permitted uses, and changes that affect interpretation.
- Ability to apply statistical and research methods to education, workforce, or related policy questions and determine appropriate approaches for preparing data and interpreting results.
- Experience developing interactive dashboards, data visualizations, or analytical products for research, policy, or public-sector decision-making.
- Proficiency developing and validating research datasets, reports, dashboards, spreadsheets, and other analytical products aligned to defined requirements.
- Experience working with sensitive administrative data subject to data-sharing agreements, privacy requirements, or disclosure-avoidance standards, including protecting confidential data to prevent identification of individuals.
- Proficiency documenting data sources, definitions, transformations, quality checks, analytical methods, and data-processing procedures to support transparency and reproducibility.
- Advanced communication skills for technical and nontechnical audiences, including researchers, agency staff, policymakers, and legislative staff.
- Ability to manage multiple research, data stewardship, and data-request priorities independently while meeting deadlines, maintaining accuracy, and coordinating with data owners and partners.
- Ability to learn and grow, take responsibility for strengths and weaknesses, and apply learning to improve government programs and processes.
- Ability to meet others’ needs with flexibility, adaptability, customer-service focus, and empathetic responses.
Technologies
- SQL, SAS, Python, R, SSRS, Tableau, Power BI, Excel
Compensation and benefits
Salary: USD 116,400 - 126,576 per year. The starting salary offer is based on the successful candidate’s qualifications within the budgeted salary range. There is potential for longevity, growth, and salary progression after employment.
- Medical, Dental, Vision, and Life Insurance
- 12 paid holidays, 14 paid vacation days (minimum), and 12 days of sick leave per year
- State retirement programs
- An environment of diversity, equity, inclusion, and belonging
- Medical flexible spending account
- Basic life and long-term disability insurance (option to purchase additional coverage amounts)
Work arrangement and location
- Office location: Olympia, WA
- Hybrid position where most work supports telework
- Travel required for in-person activities, meetings, and events as business needs require
How to apply
- Complete an online application to showcase your qualifications.
- No AI or other technology is used to screen applications or reject candidates.
- A real person will read applications, and top candidates will be contacted to schedule interviews.
- If you need a reasonable accommodation during the application process, call 7-1-1 or 1-800-833-6384.
Required application materials
- Cover letter describing qualifications for this position
- Resume detailing applicable experience and education
- At least three professional references with current contact information
Additional information
- This position is exempt from civil service rules (see WAC 357-19-195).
- OFM’s Staff ASL interpreter is available to deaf and hard-of-hearing applicants.
- For questions about recruitment or to request a reasonable accommodation in the application or interview process, email [email protected].