PME Data Engineer

King County • Chinook Building 401 5th Avenue Seattle, WA

9d • Hybrid

About The Position

King County's Department of Community and Human Services (DCHS) provides equitable opportunities for people to be healthy, happy, and connected to community. The Performance Measurement and Evaluation (PME) Unit within the Department of Community and Human Services (DCHS) is seeking a savvy Data Engineer to join our team of analytic experts! DCHS is committed to leveraging data to inform program and investment decisions. We are investing heavily in data systems to collect robust client-level outcome data as well as in data infrastructure to support workflows that combine data across historically siloed service systems. This opens opportunities for more impactful analytics as well as introducing more complex requirements for data management. We are seeking a skilled and collaborative Data Engineer who is interested in working with a wide range of internal partners to expand and optimize our data and data pipeline architecture, as well as optimize data flow and collection for cross functional teams. This position supports department-wide systems within DCHS. This position is centrally located within the Performance Measurement and Evaluation (PME) unit of the DCHS Director's Office. PME is composed of a team of dedicated data scientists, engineers, evaluators, and analysts who work with partners within and outside of DCHS to provide insights for data-informed program and policy decisions and test innovative approaches to tackling a variety of system, policy, and service delivery challenges. This selection process will fill our current vacancy but may also establish a pool of qualified candidates should additional Data Engineer positions open up within the next 6 months.

Requirements

• A minimum of five (5) years of work experience, or an equivalent combination of education and work experience in data analytics, computer science, engineering, applied math, statistics, or a related field.
• A minimum of three (3) years of working experience building and optimizing complex administrative data pipelines, architectures and data sets, including experience extracting, manipulating, matching, cleaning, and validating data from large, disconnected data sets.
• Ability to develop a strong understanding of the key business processes and programmatic features reflected in the administrative data.
• Expert SQL knowledge and experience working with large relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Intermediate experience with data management, version control, and analysis.
• Intermediate experience with visualization tools, such as Tableau and Power BI.
• Strong knowledge management and organizational skills, with experience creating documentation and processes for team-wide management and awareness of data systems.
• Strong oral and written communication skills, including the ability to communicate well about technical topics with non-technical audiences.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Knowledge of equity and social justice principles and practices and/or lived experience or understanding of the effect of place, race, and policy & systems inequities on communities and populations.

Nice To Haves

• Expert skills in SQL and R, including experience authoring and maintaining R functions and packages and SQL stored procedures.
• Understanding of health and behavioral health measurement and management processes, indicators, and tools.

Responsibilities

• Create and Maintain Optimal Data Pipeline Architecture and Documentation
• Consult with partners to define the requirements for collecting, structuring, and organizing data ; translate into technical specifications to meet business needs and communicate effectively.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and R.
• Lead data cleaning, management, and validation efforts to ensure the completeness and accuracy of data used to support measurement and evaluation.
• Identify, design, and implement internal process improvements : automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Design and build large, complex data sets that meet business requirements.
• Create and maintain architecture diagrams, system documentation, data models, mapping documents, data dictionaries, business rules, data flow diagrams, and other related artifacts.
• Build Analytical Tools that Utilize the Data Pipeline
• Build tools that utilize data pipelines to streamline review and validation processes and provide actionable insights into key performance indicators.
• Develop various metrics and routine reports to support evaluation and measurement, for example those that monitor data submissions.
• Where relevant, coordinate and align products across different reporting streams.
• Develop dashboards, charts, reports, and presentations that visually represent key findings for non-technical audiences and communicate results in a way that is actionable.
• Respond to other data requests and perform other related duties as assigned.
• Provide Support and Subject Matter Expertise on Data Systems
• Provide consultation to internal partners to assist with technical issues and ensure data obtained through system transactions and other means meets the needs of data analysts and evaluators.
• Provide technical subject matter expertise about data structures, concepts, and interpretation via orientation to data systems, code review, participation in data standards discussions, and counseling on considerations for analytic use and interpretation.
• Monitor and communicate relevant data system changes and implications to technical staff.
• Manage team processes and tools for shared learning, improvement, and documentation of data systems.
• Review data use proposals for technical feasibility and compliance in support of cross-divisional or cross-departmental data collaborations.
• As needed, participate in team, work group, division, department, and cross-department meetings.

Benefits

• Employees will be provided with a County-issued laptop and must maintain a home workspace with an internet connection where they can reliably perform work and remain available and responsive during scheduled work hours.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed