Snowflake Data Consultant

2 hours, 38 minutes ago
Contract
Senior
Data Science and Analytics
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

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

Data Engineer (Azure) - Remote, Latin America

Bluelight Consulting 11-50 Internet Software & Services

Bluelight is hiring a remote ETL Data Engineer in Latin America to design, build, and maintain Azure-based data integration processes that deliver accurate analytical data for client decision-making.

Agile Apache Spark Azure Git Machine Learning Power BI Python REST API SQL Tableau
20 minutes ago

Data Engineer (Azure) - Remote, Latin America

Bluelight Consulting 11-50 Internet Software & Services

Bluelight is hiring a remote ETL Data Engineer in Latin America to design and maintain Azure-based data integration workflows that support accurate analytical data for client decision-making.

Agile Apache Spark Azure Git Machine Learning Power BI Python REST API SQL SQL Server Tableau
21 minutes ago

Data Engineer (Azure) - Remote, Latin America

Bluelight Consulting 11-50 Internet Software & Services

Bluelight is hiring a remote Data Engineer in Latin America to design, build, and maintain ETL and data integration solutions for a client’s growing analytics environment.

Agile Apache Spark Azure Git Machine Learning Power BI Python REST API SQL Tableau
1 hour, 12 minutes ago

Data Engineer (Azure) - Remote, Latin America

Bluelight Consulting 11-50 Internet Software & Services

Bluelight is hiring a remote ETL Data Engineer in Latin America to support a client’s growing data engineering team by building and maintaining Azure-based data pipelines and analytics-ready data structures.

Agile Apache Spark Azure Git Machine Learning Power BI Python REST API SQL SQL Server Tableau
1 hour, 19 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