Descrição da vaga
Job Title: Snowflake Data Engineer
Location: Remote LATAM-based (EST/CST)
Type: Contract
Duration: 6-12 months (extendable)
Role Overview
We are seeking an experienced Snowflake Data Engineer to lead and execute the migration of critical data platforms from Oracle and SQL Server environments to Snowflake. This role will design the target architecture, build robust ETL/ELT pipelines, perform data conversion and reconciliation, and ensure a high-quality, performant, and well-governed Snowflake environment.
The ideal candidate has deep hands-on experience with complex database migrations into Snowflake and strong data engineering practices. Experience working with regulated healthcare or life sciences data (including HIPAA) is highly advantageous.
Key Responsibilities
- Assess existing Oracle and SQL Server schemas, data models, stored procedures, and workloads to define a clear migration strategy and target Snowflake architecture.
- Design and implement scalable data models optimized for Snowflake (including appropriate use of clustering, micro-partitioning considerations, and semi-structured data handling).
- Build and optimize ETL/ELT pipelines to migrate historical and incremental data with minimal downtime, including handling of complex transformations, data type conversions, and performance tuning.
- Perform thorough data validation, reconciliation, and quality checks to ensure completeness, accuracy, and integrity between source and target systems.
- Convert or re-implement stored procedures, views, and business logic into Snowflake-compatible SQL, Snowpark, or modern orchestration patterns.
- Implement data governance and security controls in Snowflake, including role-based access control (RBAC), object tagging, Dynamic Data Masking, and Row Access Policies.
- Collaborate with source system owners, analysts, and stakeholders to understand business requirements, resolve data issues, and support cutover and post-migration stabilization.
- Document migration approaches, data lineage, validation results, and operational runbooks.
- Optimize cost, performance, and resource usage in the Snowflake environment.
Required Qualifications
- 4+ years of hands-on data engineering experience with Snowflake in production environments.
- Proven experience migrating large or complex data platforms from Oracle and/or SQL Server to Snowflake.
- Strong expertise in Snowflake SQL, data modeling, and performance optimization.
- Experience building reliable data pipelines using tools such as dbt, Airflow, Fivetran, Matillion, Informatica, or custom Python/Snowpark solutions.
- Solid understanding of relational database concepts, ETL/ELT patterns, data quality, and reconciliation techniques.
- Ability to work independently and drive migration deliverables from assessment through cutover.
- Strong communication skills and experience collaborating with cross-functional teams.
Highly Advantageous
- Experience implementing or supporting HIPAA-compliant data environments, including proper handling of Protected Health Information (PHI), data classification, least-privilege access design, and auditability.
- Familiarity with Snowflake security and governance features in regulated settings (Dynamic Data Masking, Row Access Policies, tagging, access history, Business Critical edition considerations).
- Background in healthcare, life sciences, biotech, or other regulated industries.
- Experience with Oracle-specific migration challenges (PL/SQL conversion, partitioning, data types) or SQL Server specifics (T-SQL, SSIS, etc.).
- Knowledge of additional compliance frameworks common in life sciences (e.g., GxP considerations).
Nice to Have
- Snowflake certifications (SnowPro Core, SnowPro Advanced: Data Engineer, or equivalent).
- Experience with CI/CD for data pipelines and infrastructure-as-code approaches.
- Familiarity with cloud platforms (AWS, Azure, or GCP) and private connectivity options.
This role offers the opportunity to drive a significant modernization effort and establish a modern, scalable data platform. Candidates with strong migration experience and an understanding of regulated data environments will be strongly preferred.