Data Engineer

Overview

Data Engineer

Cayuse Civil Services, LLC

Remote

$93,600 - $119,800

The Data Engineer is responsible for designing, developing, and maintaining saleable data pipelines and architecture to support the client’s business intelligence, analytics, and operational data needs. This position performs all duties and responsibilities in accordance with the Mission, Vision, and Core Values of Cayuse.

• Assess feasibility and technical requirements for LINKS→Data Lake integration.
• Collaborate with OPH Immunization Program, OPH Bureau of Health Informatics and STChealth on data specifications and recurring ingestion pipelines.
• Build and optimize ETL workflows for LINKS and complementary datasets (Vital Records, labs, registries).
• Design scalable data workflows to improve data quality, integrity, and identity resolution.
• Implement data governance, observability, and lineage tracking across all pipelines.
• Mentor engineers, support testing, and enforce best practices in orchestration and architecture.
• Document and communicate technical solutions to technical and non-technical stakeholders.
• Other duties as assigned.

• 3 years of experience in data engineering and/or data architecture
• 2 years of experience with Python for ETL and automation (pandas, requests, API integration).
• 2 years hands‑on experience with SQL queries, stored procedures, performance tuning (preferable Oracle, SQL Server, MySQL)
• 1 year experience with ETL orchestration tools (Prefect, Airflow or equivalent).
• Must be able to pass a background check. May require additional background checks as required by projects and/or clients at any time during employment.

• Exceptional interpersonal skills with the ability to communicate in a clear, professional, and articulate manner.
• Exceptional verbal and written communication skills.
• Excellent organizational, analytical, and problem‑solving skills with high‑level attention to detail.
• Proven ability to multitask and prioritize in a fast‑paced environment with changing priorities; adaptable to change and a quick learner.
• Must be self‑motivated and able to work well independently as well as on a multi‑functional team.
• Ability to handle sensitive and confidential information appropriately.
• Proficient in MS Office, Word, Outlook, PowerPoint, and Excel.

• 5 years of experience in data engineering roles
• Experience integrating or developing REST/JSON or XML APIs
• Familiarity with CI/CD pipelines (Git Hub Actions, Azure Dev Ops, etc.).
• Exposure to Infrastructure as Code experience (Terraform, Cloud Formation).
• Experience with data governance and metadata tools (Atlan, Open Metadata, Collibra).
• Public health/healthcare dataset or similar experience, including PHI/PII handling.
• Familiarity with SAS and R workflows to support epidemiologists and analysts.
• Experience with additional SQL platforms (Postgres, Snowflake, Redshift, Big Query).
• Familiarity with data quality frameworks (Great Expectations, Deequ).
• Experience with real‑time/streaming tools (Kafka, Spark Streaming).
• Familiarity with big data frameworks for large‑scale transformations (Spark, Hadoop).
• Knowledge of data security and compliance frameworks (HIPAA, SOC 2, etc.).
• Agile/SCRUM team experience.

• Medical, Dental and Vision Insurance;
  Wellness Program
• Flexible Spending Accounts (Healthcare, Dependent Care, Commuter)
• Short‑Term and Long‑Term Disability options
• Basic Life and AD&D Insurance (Company Provided)
• Voluntary Life and AD&D options
• 401(k) Retirement Savings Plan with matching after one year
• Paid Time Off

Program Manager

• Professional office environment.
• Must be physically and mentally able to perform duties extended periods of time.
• Ability to use a computer and other office productivity tools with sufficient speed to meet the demands of this position.
• Must be able to establish a productive and professional workspace.
• Must be able to sit for long periods of time looking at computer screen.
• May be asked to work a flexible schedule which may include holidays.
• May be asked to travel for business or professional development purposes.
• May be asked to work hours outside of normal business hours.

Please note this job description is not designed to cover or contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

Cayuse is an Equal Opportunity Employer. All employment decisions are based on merit, qualifications, skills, and abilities. All qualified applicants will receive consideration for employment in accordance with any applicable federal, state, or local law.

USD $93,600.00 – USD $ /Yr.