Data Consultant – Snowflake

Trility Consulting

Snowflake Data Consultant at Trility Consulting leading technical transformation of legacy data models to modern Snowflake. Engaging in complex data migrations and designing optimized data flows.

Posted 6/25/2026full-timeRemote • Alabama, Colorado, Florida, Iowa, Kansas, Kentucky, Louisiana, Minnesota, Montana, Nevada, New York, North Carolina, Ohio, South Carolina, Tennessee, Texas, Virginia, Wisconsin • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

OracleSQL

About the role

Key responsibilities & impact

Analyze, interpret, and reverse-engineer existing Oracle Data Integrator (ODI) workflows and data transformation logic
Document and understand current data flows, dependencies, and legacy data structures
Design Snowflake-optimized data models and ELT patterns that improve performance and scalability
Write performance-aware SQL and implement ELT transformations within Snowflake
Restructure inefficient or “stair-step” legacy models into normalized, maintainable, and scalable architectures
Cleanse legacy artifacts, including redundant columns, null-handling inconsistencies, and outdated dependencies
Design conformed and curated data objects to support 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 for development work
Establish data validation and reconciliation patterns to compare Oracle vs. Snowflake results
Implement data quality checks to ensure accuracy and consistency during migration
Collaborate closely with QA and review teams to validate transformation logic and performance outcomes

Requirements

What you’ll need

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
5+ years of experience in data engineering or data consulting roles
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

Benefits

Comp & perks

Work remotely anywhere in the United States with flexible work hours
Paid time-off, company holidays, and floating holidays
Comprehensive benefits with contributions toward premiums
401(k) plan
Sponsored and supported learning opportunities

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Oracle Data IntegratorSnowflakeSQLDBTdata modelingdata transformationdata validationdata migrationdata cleansingperformance optimization

Soft Skills

collaborationcommunicationindependenceproblem-solvingattention to detail