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