Data Architect

OpenLoop

. 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.

Posted 5/5/2026full-timeLima • 🇵🇪 PeruSeniorLeadWebsite

Tech Stack

Tools & technologies

AWS

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SnowflakeData EngineeringData ArchitectureRBACDynamic Data MaskingIngestion PipelinesData GovernanceAWSS3API Integration

Soft Skills

CommunicationCollaborationInfluencingTechnical Trade-offsProblem SolvingStakeholder EngagementCross-Functional TeamworkAdaptabilityLeadershipStrategic Thinking