Note: The job is a remote job and is open to candidates in USA. Trility Consulting is a company that fosters a strong remote-work culture and is seeking a Snowflake Data Consultant. This role involves leading the transformation of legacy data models into modern Snowflake environments, focusing on performance and scalability while ensuring data quality during migration.

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 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

Skills

• 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
• 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 Overview