University of Washington School of Public Health
Statistical Programmer / Database Architect - WA Department of Social and Health Services
Closing Date: April 24, 2017
Posted: April 11, 2017
Statistical Programmer for CORE Research Data System
The Department of Social and Health Services (DSHS), Research and Data Analysis Division (RDA) has a permanent opening for a highly motivated and qualified Database Administrator/Architect (ITS/AS6) with experience and interest in public health, epidemiology, social geography, human services, or related fields.
You will be the highest level technical authority for RDA on community needs assessment data which enable community-specific approaches to planning and delivery of behavioral health and other human services. You will provide technical and organizational leadership on the conceptualization, design, development, and enhancement of the Community Outcome and Risk Evaluation (CORE) information system, a statewide analytical dataset used by DSHS and partner agencies. RDA is a recognized leader in the use of complex cross-system databases for policy-relevant research and program evaluation; you will work in the Program Research and Evaluation Section (PRES) of RDA.
- Centrally positioned within DSHS to provide data, analytics, and decision support tools to improve the delivery of services to transform lives.
- Provides policy makers and program managers with relevant data, analyses, and information to support innovations that improve the effectiveness of services for clients.
- Provides DSHS program staff and contracted service providers with access to data-driven decision support applications to improve decisions about client care.
- A national leader in the use of administrative data for policy-relevant research and performance measurement.
You will have the opportunity to:
- Independently design, develop, and manage CORE - a highly complex analytical database drawing from over 50 different source systems.
- Independently set standards, develop requirements, design and test complex applications, manage processes, provide quality assurance and complete analyses using these data.
- Plan, design, and implement cutting-edge approaches to information dissemination.
- Serve as an authority for the creation and development of this integrated dataset and associated analytical tables for use in research and evaluation.
- Conduct sophisticated statistical analyses to support CORE development and high priority research and program evaluations pertaining to DSHS and partner agencies.
- Represent DSHS with external agencies in negotiating new and changing data sources.
What we’re looking for
If you have a high degree of expertise and extensive experience in
- gathering user and business requirements
- managing complex databases using SAS
- the application of database design principles
- advanced analytical and/or statistical programming
we encourage you to apply!
Required Education, Experience, and Competencies:
- A Bachelor’s degree in computer science, mathematics, statistics, or a related field and five years of progressively more responsible consultative, administrative or supervisory experience in information technology including programming, data management, and data analysis
- OR a Master’s degree (MA/MS) in computer science, mathematics, statistics, or a related field and four years of progressively more responsible consultative, administrative or supervisory experience in information technology including programming, data management, and data analysis
- OR Eight years of progressively more responsible consultative, administrative or supervisory experience in information technology including programming, data management, and data analysis
- Three years of experience using SAS Version 9 or higher for programming, data management, data analysis and report production
- Advanced skills using Visual Basic macros in Excel
- Experience using Microsoft Access database software
- Excellent written and verbal communication skills
Preferred Education and Experience include:
- A Master’s degree (MA/MS) or higher in computer science, mathematics, social sciences, statistics, epidemiology, public health, geography, or a related field
- Proven capacity for innovative technological solutions
- Documented expertise in database design and data integration
- Three years of experience using ArcGIS or other Geographic Information System applications
- Python and SQL programming skills
- Excellent communication skills
- Two years of experience with social and health service data or other large administrative databases
- Experience with Tableau or similar interactive query tool/business intelligence expertise
- Two years working in substance abuse prevention planning
In addition to the state application, applicants must provide a résumé or curriculum vitae, a cover letter describing applicant’s interest and ability to perform position duties, and contact information for three references.