Data Architect

Open Loop was co-founded by CEO, Dr. Jon Lensing, and COO, Christian Williams, with the vision to bring care anywhere. Our telehealth support solutions are thoughtfully designed to streamline and simplify go-to-market care delivery for companies offering meaningful virtual support to patients across an expansive array of specialties, in all 50 states.

Open Loop is looking for a Data Architect to join our Engineering – Platform team in Lima, Peru. This role owns the most foundational layer of our data ecosystem: the Snowflake platform that every team in the company depends on to make trusted, compliant, data-driven decisions.

The ideal candidate is a hands‑on technical leader with deep Snowflake expertise, strong AWS experience, and a track record of architecting data platforms from scratch in regulated environments. You won't be inheriting someone else's architecture — you'll be building the one Open Loop runs on for years.

• Snowflake Platform Ownership Architects, builds, and owns Open Loop's production Snowflake environment end-to-end — including multi-environment setups (dev/staging/prod), ingestion pipelines from AWS S3, scheduling, RBAC frameworks, and data masking policies. Ensures platform health through query performance optimization, warehouse cost management, and proactive monitoring as the environment scales.

• Data Governance & Compliance Designs and implements data governance architectures that satisfy HIPAA and security review requirements, including dynamic data masking policies, row-level security, and role-based access control. Translates regulatory constraints into durable, auditable Snowflake governance controls.

• Semantic & Dynamic View Layer Establishes a robust semantic and dynamic view layer that enables governed, self‑serve data access across engineering, BI, analytics, and data science teams. Ensures downstream consumers can trust and access the data they need with consistency.

• AWS‑to‑Snowflake Ingestion Engineering Designs and maintains scalable ingestion systems using S3‑to‑Snowflake integration patterns with AWS services (Event Bridge, SQS, SNS, Lambda, Athena, Glue). Builds resilient pipelines with retry logic, rate‑limit management, and idempotent processing for external API enrichment workflows.

• Technical Strategy & Standards Defines data architecture standards and best practices where none currently exist. Acts as the go-to Snowflake authority for Data Engineers, Analytics Engineers, and cross‑functional stakeholders. Drives architectural decisions that balance consistency, performance, cost efficiency, and security.

• Cross‑Functional Collaboration Partners closely with Engineering, Product, Security, Compliance, and SRE teams to ensure the data platform meets business requirements while maintaining strict security and performance standards. Communicates technical trade‑offs and architecture decisions clearly to both technical and non‑technical stakeholders.

• Other duties as assigned.

• 8+ years of experience in Data Engineering, Data Architecture, or equivalent platform ownership roles.

• 3–4 years of hands‑on experience as a Snowflake Solutions Architect, Senior Data Engineer, or in a role with full Snowflake platform ownership.

• Proven experience setting up Snowflake environments from scratch, including multi‑environment setups, Snowpipe, Tasks, Streams, RBAC, and dynamic data masking in production.

• Hands‑on AWS experience with S3‑to‑Snowflake integration patterns using Event Bridge, SQS, SNS, Lambda, Athena, and Glue.

• Experience designing and implementing data governance architectures that meet compliance requirements (HIPAA or equivalent regulated environment).

• Experience building scalable ingestion systems with external API dependencies, including handling throttling, partial failures, and replay mechanisms.

• Strong communicator, able to influence architecture decisions across teams and explain complex data concepts to non‑technical stakeholders.

• Advanced English (C1), with strong verbal and written communication skills.

• Experience in healthtech, fintech, or other highly regulated industries (HIPAA, SOC
  2).

• Snowflake Snow Pro Core…