| The University of Washington (UW) is proud to be one of the nation's premier educational and research institutions. Our people are the most important asset in our pursuit of achieving excellence in education, research, and community service. Our staff not only enjoys outstanding benefits and professional growth opportunities, but also an environment noted for diversity, community involvement, intellectual excitement, artistic pursuits, and natural beauty. |
The UW School of Social Work has an outstanding opportunity for a Data Engineer.
Partners for Our Children (POC) at the University of Washington School of Social Work has an outstanding opportunity for a Data Engineer. The Data Engineer will work closely with data scientists, software engineers, and other stakeholders to design and maintain generalizable data models for the social service business sector, and support these models with cross-platform ETL processes and an EDW with a well-documented API to serve data to data scientists and other data users. The Data Engineer interacts and collaborates with POC Leadership, Data Scientists, Domain Experts, Business Analysts, Engineering, Customer Support and other Social Service Stakeholders.
The Data Engineer will need to understand the complex social services landscape including the child welfare and runaway and homeless youth systems, the legacy case management software integrations and data analytics and visualization applications, as well as the legal, privacy, and security requirements as it pertains to the use and evaluation of PHI/PII data. The successful candidate will need to use this understanding to meet the competing and intersecting business/technical requirements from POC's Data Science and Informatics Group (DSIG) and the POC Oliver Team - a group of technologists charged with creating a cutting edge service management solution for key domains in the Washington social service system.
The ability of the individual in this position to successfully support and advance the POC Oliver solution will impact the ability of POC to continue their work in policy, practice, data, research/evaluation and improve the outcomes for vulnerable children and families. Successful individuals will have a direct impact on the reputation of POC, the School of Social Work, and the University of Washington in general.
Work closely with data scientists, software engineers, and other stakeholders to design and maintain generalizable data models for the social service business sector.
Develop and maintain cross-platform ETL processes to support an EDW with a well-documented API to support the calculation of social service business metrics as developed by the DSIG and Oliver teams.
Develop and maintain a robust data search and discovery platform using an Alation-style interface for data scientists and other data users.
Review all technical designs, source, test, and automation code.
Bachelor of Science in Computer Science or related field or equivalent experience and at least 3 years of relevant work experience.
Strong interpersonal, collaboration and communication skills
Expert-level proficiency in MS SQL, PostgreSQL, MySQL, and Amazon Redshift
Ability to develop and maintain ETL procedures across these platforms
Experience with Amazon Web Services (AWS) virtual private cloud and containers
Ability to develop procedures to implement user stories, use cases, and functional requirements
Ability to identify and understand as-is/to-be business processes, business rules, and events/triggers
Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.
Experience with Aptible Secure Database Container Platform for HIPAA compliance
Experience with R, Shiny, and the full functionality of the RStudio IDE
Experience with Github source code control
Experience with Tableau Desktop and Google Analytics for business intelligence and data discovery
Experience with Alation or similar products for the management of diverse data sets
| Appointment to this position is contingent upon obtaining satisfactory results from a criminal background check |
The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Criminal Conviction History, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select Apply to this position. Once you begin an assessment, it must be completed at that time; if you do not complete the assessment you will be prompted to do so the next time you access your My Jobs page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.