Snowflake Data Consultant

Trility Consulting

Snowflake Data Consultant leading the transformation of legacy Oracle BI to Snowflake data models. Responsible for modernizing data systems in a remote setting.

Posted 6/3/2026contractRemote • 🇺🇸 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 resultsImplement 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

Benefits

Comp & perks

Work remotely anywhere in the United States with flexible work hours
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 IntegratorSQLSnowflakeELTDBTdata modelingdata transformationdata cleansingdata validationdata reconciliation

Soft Skills

collaborationdocumentationanalytical thinkingproblem-solvingattention to detail