Junior Data Engineer – Snowflake, Oracle

This is a fully remote position, open to applicants in Brazil.

📋 Description

• Participate in a project focused on migrating an Oracle Data Warehouse to Snowflake.

• Collaborate with a diverse and multidisciplinary team.

• Assist in the development, validation, and documentation of migration workflows.

• Construct and enhance ingestion pipelines and transformations across the Bronze, Silver, and Gold tiers.

• Evaluate and test generated code, including the conversion of PL/SQL procedures to SQL and Snowflake Scripting.

• Reconcile the Oracle and Snowflake environments through counts, totals, and sampling, while thoroughly documenting supporting evidence.

• Set up and monitor Tasks, loads, and alerts, addressing failures with guidance from senior team members.

• Maintain technical documentation such as table catalogs, data lineage, and runbooks.

• Manage version control in Git and submit pull requests for review.

• Assist in preparing change management packages (GMUD), as well as go-live and hypercare activities.

• Document tool errors and gaps to aid in the development of the internal platform.

⛳️ Requirements

• Proficient in SQL at an intermediate level, including joins, aggregations, CTEs, and window functions.

• Basic understanding of relational databases and data modeling principles.

• Experience with or exposure to Snowflake or Oracle through projects, internships, courses, or hands-on study.

• Fundamental skills in Git, including commits, branches, and pull requests.

• Familiarity with AI coding assistants like Claude, Copilot, and ChatGPT, along with a critical approach to reviewing their output.

• Strong organizational abilities, attention to detail, and clear communication skills for questions and status updates.

• Excellent communication skills adaptable to both technical and non-technical audiences.

• Capability to translate business requirements into practical and scalable solutions.

• Ability to influence decision-making and foster trusted relationships with stakeholders.

• Analytical and problem-solving mindset.

• Focused on delivering value and results for clients and the business.

• Collaborative mindset with a commitment to knowledge sharing and continuous improvement.

• Nice to have: Python skills, ideally with Snowpark or pandas.

• Familiarity with PL/SQL.

• Exposure to dbt, pipeline orchestration, or CI/CD processes.

• Interest in or experience with MCP, AI agents, or development automation.

• SnowPro Associate/Core certification or currently pursuing one.

• Degree or ongoing studies in Computer Science, Information Systems, Engineering, or a related field.

🏝️ Benefits

• Emphasis on diversity and multiculturalism as integral to the Keyrus experience.

• Opportunities to enhance skills, judgment, and expertise.

• Flexibility for remote work.