• Extract data from large relational databases to create user-friendly reports with tools such as SQL reporting services and Tableau dashboards
• Develop reporting solutions (data tools) that are automated, sustainable, and can be shared with a broad range of constituents
• Design, build, maintain, and update relational database structures in support of the policy research department analysis needs
• Maintain documentation of procedures and data tool parameters
• Work collaboratively with the State Research and Planning commission members on system-wide reports and data analysis
• Support the data needs for system initiatives and grant projects (including Guided Pathways, Student Achievement Initiative reporting, enrollment monitoring, etc.)
• Develop, deploy, and maintain web-based reporting systems and dashboards using Tableau
• Assist in ensuring data integrity, consistency, and security through systems design and data reconciliation
• Assist research staff with programming and technical issues as appropriate
• Respond to ad hoc information requests from internal and external partners
• Maintain department website(s)
• Participate in SBCTC agency and Washington community and technical college system research commissions and committees as appropriate.

 The Policy Research Analyst may perform other related work as required; other special projects and duties may be assigned.

• Bachelor’s degree from an accredited college or university in one or more areas of study related to the principal responsibilities, or a combination of education and experience equivalent to a bachelor’s degree.
• Advanced knowledge of SQL Server Management Studio (SSMS) and Microsoft Excel
• Advanced Structured Query Language (SQL) experience (Microsoft Access working knowledge an advantage)
• Experience working with large relational databases, data warehouses, and data marts
• Experience using Tableau to design interactive web-based dashboards.
• Ability to design effective solutions to problems
• Excellent written and oral communication skills
• Commitment to working with and in support of individuals with diverse identities and backgrounds.

The Washington State Board for Community and Technical Colleges — led by a nine-member governor-appointed board — advocates, coordinates and directs Washington state’s system of 34 public community and technical colleges.

Each year, about 278,000 students train for the workforce, prepare to transfer to a university, gain basic math and English skills, or pursue continuing education. Our students, graduates and community partners increase the state’s quality of life and economic vitality as entrepreneurs, employees, consumers and taxpayers.

Washington State has a generous benefit package including health, dental, life insurance, long-term disability, retirement, and two optional deferred compensation programs.  For health benefit information go to Washington Health Care Authority. The position is eligible to participate in the State Board Retirement Plan (SBRP) and Department of Retirement Systems (DRS).