The Snowflake Data Consultant will transform legacy Oracle BI and ODI data models into Snowflake, analyze data flows, and ensure performance optimization.
Who We Are
At Trility Consulting®, we’ve built a strong, remote-work culture where people thrive, grow, and support each other – earning us Great Place to Work® Certification. Headquartered in Central Iowa, we embrace flexible schedules and collaboration across geographically distributed teams serving clients from all corners of the United States and globally.
We seek team members with the grit necessary to forge paths where none previously existed, to get back up when circumstances knock them down, to adapt to the changing needs of the client even when it is uncomfortable, and to deliver on our commitments. Candidates must respect and value people, recognize that over-communication is barely good enough, thrive on solving complex problems, have a passion for building teams, and know that delivering what a client actually values is more important than their own predispositions. They understand value proposition, love delivering value, and take pride in learning the expansive and ever-changing business of clients. Candidates are self-motivated and relentlessly working to become more today than they were yesterday.
Who We Are
At Trility Consulting®, we’ve built a strong, remote-work culture where people thrive, grow, and support each other – earning us Great Place to Work® Certification. Headquartered in Central Iowa, we embrace flexible schedules and collaboration across geographically distributed teams serving clients from all corners of the United States and globally.
We seek team members with the grit necessary to forge paths where none previously existed, to get back up when circumstances knock them down, to adapt to the changing needs of the client even when it is uncomfortable, and to deliver on our commitments. Candidates must respect and value people, recognize that over-communication is barely good enough, thrive on solving complex problems, have a passion for building teams, and know that delivering what a client actually values is more important than their own predispositions. They understand value proposition, love delivering value, and take pride in learning the expansive and ever-changing business of clients. Candidates are self-motivated and relentlessly working to become more today than they were yesterday.
What You Will Do
Trility Consulting is seeking a Snowflake Data Consultant who is a powerhouse on the keyboard and thrives in complex data migration environments. In this role, you will lead the technical transformation of legacy Oracle BI and ODI logic into modern, performant Snowflake data models.
You’ll reverse-engineer existing data flows, untangle legacy structures, and redesign them using scalable Snowflake-optimized patterns. This is a hands-on role focused on thoughtful modernization — not just lift-and-shift — ensuring the new Snowflake environment is clean, performant, and built for long-term growth.
This is a remote W2 or 1099 position.
At this time, Trility is only able to hire W2 employees who reside in the following states: Alabama, Colorado, Delaware, Florida, Georgia, Iowa, Kansas, Kentucky, Louisiana, Minnesota, Missouri, Montana, Nebraska, Nevada, North Carolina, Ohio, South Carolina, Tennessee, Texas, Virginia, and Wisconsin.
Key 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
Qualifications
- 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
How We Put You First
Trility’s culture is built upon the journey, character, and work ethic of our team members. We are a team of honorable and professional lifelong learners who work together to solve problems proactively.
• 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
Job 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
Similar Jobs
.png)
Greentech • Hardware • Internet of Things • Machine Learning • Software • Business Intelligence • Agriculture
Lead and coach a regional field sales team of Territory Managers with ~60% travel. Own regional revenue, pipeline hygiene, forecasting in Salesforce, recruit and develop talent, surface customer insights to cross-functional teams, and translate national strategy into regional execution.
Top Skills:
Salesforce
Greentech • Hardware • Internet of Things • Machine Learning • Software • Business Intelligence • Agriculture
Lead and coach Territory Managers across the Desert Southwest through frequent fieldwork (~60% travel). Drive regional revenue, maintain Salesforce pipeline and forecasting rigor, support deal execution, localize national strategy, recruit and scale the team, and surface customer insights to cross-functional teams. Focus on hands-on sales leadership, consistent execution, and building high-performing culture in a fast-growth hardware+software environment.
Top Skills:
CRMSalesforce
Greentech • Hardware • Internet of Things • Machine Learning • Software • Business Intelligence • Agriculture
Lead and coach Territory Managers through frequent field work (~60% travel), drive regional revenue and pipeline hygiene, maintain Salesforce forecasting, localize national strategy, recruit and develop talent, and surface customer insights to cross-functional teams.
Top Skills:
Salesforce
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
