Data Architect

Requirements

• 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 EventBridge, 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.

Projects

OpenLoop 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 OpenLoop runs on for years.

Responsibilities

Snowflake Platform Ownership Architects, builds, and owns OpenLoop'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 (EventBridge, 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.

Our Benefits

In addition to competitive salaries, this role includes:

• Formal employment (“Planilla”) under a Peruvian entity — all legal benefits in soles (CTS, Gratificaciones, etc.).
• Full-time schedule: Monday–Friday, 9am–6pm.
• Unlimited vacation days 🏖️ — yes, we mean it!
• EPS healthcare (Rimac) covered 100%.
• Oncology insurance (Rimac) covered 100%.
• AFP retirement plan.
• Coworking access in Miraflores, Lima — with free beverages, talks, bicycle parking, and amazing city views.
• Company laptop and tools provided.

Preferred Qualifications (desired)

• Experience in healthtech, fintech, or other highly regulated industries (HIPAA, SOC 2).
• Snowflake SnowPro Core or Advanced certification.
• Experience with dbt, Snowpark, Python, or Airflow.
• Experience with data streaming and near-real-time ingestion patterns (e.g., Kinesis, Snowpipe Streaming).
• AWS certifications (e.g., Solutions Architect).