Snowflake Data Consultant
Trility Consulting
contract
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
About the role
- 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
- 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
- Sponsored and supported learning opportunities
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 validationdata cleansingdata architecture
Soft Skills
collaborationdocumentationanalytical thinkingproblem-solvingattention to detail