Junior Data Engineer – Snowflake, Oracle
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Engineer Jr apoiando a migração de Data Warehouse Oracle para Snowflake na Keyrus, grupo internacional de dados e IA. Desenvolvendo pipelines, validando código e documentando processos.
Responsibilities:
- Work on a project to migrate an Oracle Data Warehouse to Snowflake
- Collaborate with a multidisciplinary team
- Support the development, validation, and documentation of migration processes
- Build and refine ingestion pipelines and transformations across the Bronze, Silver, and Gold layers
- Review and test generated code, including the conversion of PL/SQL procedures to SQL and Snowflake Scripting
- Reconcile Oracle and Snowflake environments using counts, totals, and sampling, while documenting supporting evidence
- Configure and monitor Tasks, loads, and alerts, investigating failures with support from senior team members
- Maintain technical documentation, including table catalogs, data lineage, and runbooks
- Version code in Git and open pull requests for review
- Support the preparation of change management packages (GMUD), go-live, and hypercare activities
- Log tool errors and gaps to contribute to the evolution of the internal platform
Requirements:
- Intermediate SQL skills, including joins, aggregations, CTEs, and window functions
- Basic knowledge of relational databases and data modeling
- Experience with or exposure to Snowflake or Oracle through a project, internship, course, or hands-on study
- Basic Git skills, including commits, branches, and pull requests
- Familiarity with AI assistants such as Claude, Copilot, and ChatGPT for coding, along with the ability and willingness to critically review their output
- Strong organizational skills, attention to detail, and the ability to communicate questions and status updates clearly
- Excellent communication skills with both technical and non-technical audiences
- Ability to translate business needs into practical, scalable solutions
- Ability to influence decisions and build trusted relationships with stakeholders
- Analytical, problem-solving mindset
- Focus on delivering value and results for clients and the business
- Collaborative approach, knowledge sharing, and commitment to continuous improvement
- Nice to have: Python, preferably with Snowpark or pandas
- Familiarity with PL/SQL
- Exposure to dbt, pipeline orchestration, or CI/CD
- 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:
- Diversity and multiculturalism as part of the Keyrus experience
- Opportunities to develop skills, judgment, and expertise
- Remote work
Similar Jobs
Snowflake Data Architect
Senior Snowflake Data Architect designing Snowflake healthcare data platforms for Datavail. Leading patient identity, dimensional modeling, quality controls, and engineering delivery.
Data Architect – VA OCDAO Data and Analytics
Data Architect designing enterprise data models, taxonomies, and metadata standards for the Department of Veterans Affairs. Leading business architecture content and aligning data governance structures.
Data Engineer – VA OCDAO Data and Analytics
Data Engineer building pipelines and integrations for the Department of Veterans Affairs OCDAO enterprise data catalog. Applying data quality and security controls remotely across the United States.
SQL Developer, Data Migration Specialist
SQL Developer and Data Migration Specialist configuring Momentive Software’s cloud platform for nonprofits and associations. Developing client solutions, supporting data conversion, testing deployments, and training users.
Senior Data Architect – North America
Senior Data Architect shaping Snowflake architecture, financial data models, and integrations for a real estate investment firm. Improving governance, performance, quality, and reporting reliability.
Data Engineer, Pharmacy Data, SQL Server
Remote Data Engineer building SQL Server pharmacy data pipelines for Chiri’s AI operating platform. Ensuring reliable ingestion, quality, observability, and high availability.
Middle Data Engineer
Data Engineer owning analytics infrastructure for Boosters’ JustDone AI research assistant. Building reliable event, ETL/ELT, BigQuery, Airflow, and Milvus pipelines.
Senior Data Engineer – Square, APAC
Senior Data Engineer building scalable data pipelines and feature platforms for Binance’s global cryptocurrency ecosystem. Supporting machine learning and recommendation systems across APAC.
Senior FHIR Data Platform Engineer
Senior engineer optimizing HAPI FHIR and PostgreSQL platforms for federal healthcare modernization. Delivering quality reporting, MDM, performance, and reliable data exchange.
Data Engineer – Level III
Data Architect / Engineering Lead guiding AWS modernization, enterprise data platforms, and AI/ML enablement. Supporting AttainX’s federal NRCS technology programs under the USDA OMNI contract.
Staff Data Engineer – Databricks
Staff Data Engineer designing scalable Azure and Databricks data platforms for CVS Health’s connected healthcare services. Leading architecture, pipeline optimization, data quality, and engineering mentorship.
Short-Term Membership Data Migration Consultant
Remote consultant migrating Together for Girls’ contact data from Airtable into EveryAction CRM. Cleansing, mapping, validating and documenting sensitive records for advocacy, fundraising and reporting.
Data Engineer
Senior Data Engineer designing scalable data pipelines and high-value products. Bridging data architecture with business applications in Study Patient projects.
Data Architect
Data Architect designing scalable data models, ETL pipelines, and SQL Server environments. Supporting Corpay’s global commercial payments solutions through migrations, warehousing, and data governance.
Senior Data Engineer – Cybersecurity
Senior Data Engineer modernizing Snowflake, DBT, SQL, and Python data infrastructure. Improving pipelines and security analytics for a global cybersecurity company.
Data Engineer – Databricks, PySpark
Data Engineer building Databricks and PySpark lakehouse solutions for Sigma Software’s AdTech analytics client. Developing scalable batch and near-real-time marketing data pipelines.
Data Engineer II – Data Platform
Data Engineer II building scalable AWS, Snowflake, and dbt data platforms for First Citizens Bank. Developing reliable pipelines, data quality controls, and analytics solutions.
Senior Data Engineer, Developer
Senior Data Engineer owning Azure data pipelines, integrations, and backend development. Supporting Smart Working’s global teams with financial analysis, automation, and business visibility.
Data Platform Engineer – Clearance Required
Data Platform Engineer building Palantir Foundry, Databricks, and Power Platform solutions for LMI’s Army and federal government clients. Leading data pipelines, AI/ML integration, and technical mentorship.
CRM/Data Platform Consultant
iGaming CRM consultant shaping an advanced player data platform for a MarTech company. Advising on strategy, architecture, vendor selection, retention, and multi-brand data.