Senior Data Platform Engineer: HIPAA-Compliant Pipelines

Open Systems Technologies; Cincinnati (OH); Sur place; USD 140 000 - 210 000; Plein temps

Résumé du poste

Open Systems Technologies seeks a Data Engineer with 7+ years of experience to own multi-stage data pipelines that ingest from external sources into a governed lake/warehouse. You will deliver scaled, event-driven integrations and manage ETL for downstream services and API access for billions of data points.

Responsibilities include building ingestion connectors, implementing idempotent jobs, and standing up observability with SLOs and latency dashboards.

Qualifications

• 7–10+ years backend/data engineering with production ownership of large event-driven data systems.
• Proficient in Python, Node, and similar toolsets for ETL job implementation; strong testing and reliability toolset.
• Deep AWS experience and Terraform-based IaC; CI/CD for data and application deployments.
• Expert SQL and performance tuning on Redshift, Snowflake, or equivalent.
• Experience delivering idempotent pipelines, restaging/reconciliation, and parity validation against legacy systems.
• Experience in highly-governed environments (HIPAA, GLBA, PCI, etc.).
• Solid security and compliance practices, supporting internal and external audits (SOC 2 ISO 27001, etc.) and remediation.

Responsabilités

• Design and implement ingestion/connectors (BigQuery direct, CSV→JSON, REST) and normalization into standardized data models.
• Build event-driven jobs and services (Python/Node) that enrich, dedupe, and apply rules; ensure idempotency and safe replays.
• Define data contracts, schema evolution, backfill strategy, and cutover plans; partner with stakeholders on acceptance criteria.
• Operate AWS workloads (EC2, Lambda, AppRunner, RDS, Redshift) with Terraform; secure secrets, roles, and least-privilege access.
• Optimize SQL for MPP systems (Redshift, Snowflake, or similar); profile queries, partition/cluster, and tune materializations.
• Implement observability (logs, metrics, tracing, lineage) and incident response; drive postmortems and remediation.
• Maintain concise documentation of architecture, workflows, standards, and governance.

Connaissances

Python

Node.js

ETL pipelines

SQL

Outils

AWS

Terraform

Redshift

Snowflake

Description du poste

Open Systems Technologies seeks a Data Engineer with 7+ years of experience to own multi-stage data pipelines that ingest from external sources into a governed lake/warehouse. You will deliver scaled, event-driven integrations and manage ETL for downstream services and API access for billions of data points.

Responsibilities include building ingestion connectors, implementing idempotent jobs, and standing up observability with SLOs and latency dashboards.