Data Engineer
About The Position
Comprehensive Healthcare provides innovative behavioral health and integrated healthcare services to clients of all ages. We take pride in our creative and collaborative work environment and in delivering clinically excellent, trauma-informed, recovery-oriented services. As part of our Information Services team, the Data Engineer/DBA is responsible for building and operating reliable data platforms and mission-critical databases. You will own the data pipelines end-to-end, ensure performance and resilience of OLTP and analytic systems, and collaborate across engineering, analytics, and business teams to deliver high-quality, governed data. This role blends data engineering (pipelines, orchestration, modeling) with some DBA responsibilities (performance tuning, backups, security, HA/DR, ideal for some who thrives on both building and operating robust data systems. This is an on-site position Monday to Friday 8am - 5pm in our Yakima office with no opportunity for remote work.
Requirements
- Bachelor’s degree in computer science or related field and 2+ years of Data Engineering and/or DBA roles (or equivalent skills), in healthcare preferred.
- In compliance with state and federal law, Comprehensive Healthcare requires all candidates to complete a post-offer, pre-employment drug screen and background check.
- Please refer to WAC 388-113-0020 through 388-113-0030 for information on criminal convictions and pending charges that automatically disqualify an individual from working for Comprehensive Healthcare.
- Please refer to RCW 49.44.240 for information on pre-employment drug screening.
Responsibilities
- Design, build, and maintain ETL/ELT pipelines ingesting batch and streaming data from varied sources (APIs, files, databases, event streams)
- Develop data models (3NF, star schema/snowflake schema, Dimensions and Fact tables) and curate datasets for analytics and BI
- Implement orchestration and job scheduling (e.g., Azure Data Factory, Fivetran, SSIS)
- Optimize Performance to support analytics, queries, storage, pipelines
- Enforce data quality via validation checks, unit tests, and anomaly detection
- Develop Success Metrics KPIs (Pipeline reliability, Data quality, Performance, Availability, Delivery, Cost efficiency)
- Monitor and tune query performance, indexing strategies, execution plans, memory/IO utilization
- Capacity planning, storage management, lifecycle policies, and cost governance
- Security and compliance: PII, PHI handling, HIPAA, auditing frameworks and experience with encryption. (Data at Rest and “Always Encrypted” technologies)
- Document data lineage, metadata, and semantic definitions; contribute to a data catalog
- Contribute to roadmap planning; propose architecture improvements and modernization initiatives
- Advocate for best practices for coding standards, version control, CI/CD, and testing within the IS Team and greater organization
- Partner with application teams on schema design and with analytics teams on semantic layers/BI
Benefits
- Training and Development
- A variety of career opportunities in a wide range of settings with room for mobility and promotion
- Regular training opportunities including support, supervision, and consultation
- Innovative Program & Services
- A strong reputation for providing quality, evidence-based services within a collaborative multi-disciplinary team environment
- Innovative, forward-looking leadership that seeks to thrive in an ever-changing healthcare environment
- Joint Commission-accredited organization committed to continuous quality improvement
- Established partnerships with major research universities and other community and healthcare providers to implement cutting-edge treatment programs and services
- Excellent Benefits
- Competitive salaries within our communities and industry
- Healthcare coverage for employee and qualified family members
- Generous vacation, paid holiday and sick leave policies
- Access to Employee Assistance Program services
- Agency-funded retirement plan with contributions equal to 5% of compensation
- Additional retirement investment opportunities with a 50% investment match of up to 4% of compensation
- Agency-funded life and disability insurance program
- Tuition reimbursement program to support employees pursuing additional education
- Employer-funded student loan repayment assistance
- Qualifications
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
