RemoteLeaf Logo
Log in Sign up

Snowflake Data Consultant

2 weeks, 6 days ago
United States
Contract
Senior
Data Engineer
Data Science and Analytics
dbt Oracle Snowflake SQL
Apply Now
Trility Consulting

Trility Consulting

Trility Consulting is a consulting firm that specializes in providing integrated AI solutions to mid-market and enterprise-sized businesses, helping them define, design, and implement comprehensive technology strategies that address significant challen...

Internet Software & Services
51-250
Founded 2017
View All Jobs 7

Description

  • Analyze and reverse-engineer Oracle Data Integrator (ODI) workflows and transformation logic.
  • Document current data flows, dependencies, and legacy data structures.
  • Design Snowflake-optimized data models and ELT patterns for performance and scalability.
  • Write performance-aware SQL and build ELT transformations in Snowflake.
  • Restructure legacy models into normalized, maintainable, and scalable architectures.
  • Clean up legacy artifacts such as redundant columns, inconsistent null handling, and outdated dependencies.
  • Design conformed and curated data objects for analytics and reporting needs.
  • Build modular, testable transformation pipelines using DBT or approved transformation tools.
  • Manage Snowflake development environments, including roles, access control, and governance.
  • Establish data validation, reconciliation, and data quality checks to compare Oracle and Snowflake results.
  • Collaborate with QA and review teams to validate transformation logic and performance outcomes.

Requirements

  • 5+ years of experience in data engineering or data consulting roles.
  • Strong hands-on experience with Oracle Data Integrator (ODI) and interpreting legacy transformation logic.
  • Deep experience building data pipelines and transformation logic in Snowflake.
  • Strong SQL skills with a focus on performance optimization.
  • Experience with DBT (Data Build Tool) or similar modern data transformation tooling.
  • Strong understanding of data modeling, normalization, and warehouse design patterns.
  • Experience validating data migrations between legacy and modern platforms.
  • Ability to work independently in complex migration environments while collaborating with cross-functional QA and review teams.
  • Excellent written and verbal communication skills.
  • Must reside within the United States.
  • Must be authorized to work in the United States without sponsorship now or in the future.
  • Must be able to pass a background check.

Benefits

  • Remote work anywhere in the United States.
  • Flexible work hours.
  • Sponsored and supported learning opportunities.
  • Independent contractor (1099) arrangement.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Marqeta

Senior Staff Software Engineer - Data Platform

Marqeta 251-1K Diversified Financial Services

Marqeta is hiring a software engineer to own the company’s data platform foundation, building the lakehouse and streaming ingestion systems that power its broader data and ML organization.

United States Full-time Lead Data Engineer
$200k-$275k
Apache Airflow Apache Spark AWS Go Java Kafka Python
10 hours, 41 minutes ago
Affirm

Software Engineer II, Machine Learning (Feature Platform)

Affirm 1K-5K Diversified Financial Services

Affirm is hiring a software engineer for its ML Feature Platform team to build the self-serve data and feature infrastructure that powers machine learning and decisioning across the company.

United States Full-time Junior Data Engineer Machine Learning Engineer
$146k-$225k
AWS Kotlin Kubernetes Machine Learning MySQL Python
10 hours, 56 minutes ago
Samsara

Senior Data Engineer

Samsara 1K-5K IT Services

Samsara is hiring a Senior Data Engineer in Canada to build and evolve its enterprise data platform, powering analytics, automation, and AI-enabled data workflows across the company.

Canada Full-time Lead Data Engineer
$89k-$105k
Agile Apache Spark API Gateway AWS Azure Databricks Datadog dbt GCP LLM MySQL PostgreSQL Python Serverless Snowflake Splunk SQL SQL Server
10 hours, 56 minutes ago
Penumbra

Clinical Data Analyst II

Penumbra 1K-5K Health Care Providers & Services

Penumbra, Inc. is hiring a Clinical Data Analyst II to support clinical study data analysis, reporting, and data management activities that improve operational processes.

United States Full-time Junior Data Analyst Data Engineer
C# MATLAB Python R SQL
11 hours, 11 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers