Trility Consulting · 1 month ago
Senior Data Consultant (Snowflake)
United States
Full-time
Remote
Senior Level
5+ years expTrility Consulting is a remote-work culture company known for its collaborative environment and commitment to client value. They are seeking a Senior Data Consultant specializing in Snowflake to lead the transformation of legacy data systems into modern data models, ensuring performance and scalability.
ConsultingProfessional ServicesManagement Consulting
No H1B
Responsibilities
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
Qualification
Required
5+ years of experience in data engineering or data consulting roles
Strong hands-on expertise with Oracle Data Integrator (ODI), including reading 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
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
Company
Trility Consulting
Trility simplifies, automates, and secures each iteration and has a proven history of reliable delivery results.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Matthew Edwards
Founder & CEO
Company data provided by crunchbase