SENIOR DATA ENGINEER – SNOWFLAKE (HYBRID OR REMOTE BRAZIL)
Brazilian company hires for hybrid or remote position
Location: Brazil — candidates from any region
Only candidates already based in Brazil will be considered
Work Model: Hybrid for candidates living in state capitals and Remote for candidates living in countryside/cities outside the state capitals
Seniority: Senior (6+ years)
Compensation: Please inform your salary expectations when applying.
About the Opportunity
Help deliver a secure and efficient Netezza-to-Snowflake migration, from strategy and execution to data validation and cloud optimization. You will collaborate with BI, development, data, and infrastructure teams, ensuring reliable data operations, strong performance, and clear documentation throughout the transition.
Main Responsibilities
- Plan and execute Netezza-to-Snowflake migrations, including migration strategy, waves, and cutover.
- Develop ETL/ELT scripts and batch integrations; convert DDL, procedures, and scripts, and rewrite queries for Snowflake.
- Validate migrated data through reconciliation, comparisons, data QA, and consistency and performance testing.
- Monitor and optimize Snowflake architecture, cloud resource usage, costs, and performance.
- Ensure data security and governance, and document migration processes and configurations.
- Collaborate with distributed technical and business teams throughout delivery.
Mandatory Requirements
- Degree in Computer Science, Data/Software Engineering, Information Systems, IT, or a related field.
- Experience in Data Engineering or Data Platforms.
- Proven expertise in Snowflake architecture, security, optimization, and performance tuning.
- Experience with Netezza administration, data modeling, and queries.
- Hands‑on experience planning and executing Netezza-to-Snowflake migrations, including strategy, waves, and cutover.
- Experience converting database objects and adapting queries for Snowflake.
- Strong SQL and ETL/ELT skills, using Snowflake with modern or native tools, with a primary focus on batch integration.
- Experience with post‑migration validation, reconciliation, data QA, and performance and consistency testing.
- Practical experience with AWS, Azure, or GCP, including ongoing Snowflake monitoring and cost/performance optimization.
- Knowledge of data security and governance.
- Experience in international or remote projects with teams across time zones.
- Experience with Scrum or Kanban and collaboration across BI, data, development, and infrastructure teams.
Nice to Have
- Specialization in Big Data, Data Engineering, or Cloud Computing focused on data platforms.
- Snowflake SnowPro Core/Advanced and data-focused AWS, Azure, or GCP certifications — strongly recommended.
- Experience with orchestration tools such as Airflow.
- Experience with large‑scale migrations, critical environments, or regulated sectors such as financial services.
- Strong migration documentation skills and communication with technical and business stakeholders.
Ideal Profile
A hands‑on data engineer with strong migration expertise who can manage the technical complexity of moving from Netezza to Snowflake. You combine rigorous data validation with performance and cost awareness, communicate effectively with distributed teams, and keep security and operational continuity central to delivery.
Questions for Candidates
- What experience do you have with Snowflake and Netezza, and have you delivered migrations between them?
- What was your role in migration planning, execution waves, and cutover?
- Have you converted DDL, procedures, and scripts and optimized queries for Snowflake?
- How have you validated data integrity, reconciliation, consistency, and performance after migration?
- Which ETL/ELT, batch integration, and orchestration tools have you used?
- What experience do you have with cloud platforms, Snowflake cost optimization, security, and governance?
- Have you worked on large‑scale or critical migrations, particularly in regulated sectors?
- Are you fluent in English and comfortable collaborating across time zones in Agile teams? Do you hold relevant certifications?
- Where in Brazil are you based, and are you available for remote or hybrid work?
- What are your current compensation, salary expectations, and availability to start?
CV Keywords — include only those that reflect your experience
Data Engineering, Snowflake, Netezza, Data Migration, Migration Strategy, Cutover, SQL, ETL, ELT, DDL, Data Reconciliation, Data Quality, Performance Tuning, Cost Optimization, Batch Integration, Airflow, AWS, Azure, GCP, Data Security, Data Governance, SnowPro
#EY BR