Data Consultant – Snowflake

🔥 12 hours ago

🏈 Alabama, Colorado, +17 more states – Remote

🏈 Alabama – Remote ⛰️ Colorado – Remote 🐊 Florida – Remote 🌾 Iowa – Remote 🌪️ Kansas – Remote 🐎 Kentucky – Remote ⚜️ Louisiana – Remote 🦬 Montana – Remote 🌾 Nebraska – Remote 🎰 Nevada – Remote 🌲 North Carolina – Remote 🏈 Ohio – Remote ❄️ Minnesota – Remote 🏰 Missouri – Remote 🌴 South Carolina – Remote 🎸 Tennessee – Remote 🤠 Texas – Remote ⚔️ Virginia – Remote 🧀 Wisconsin – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

💼 Consultant

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Trility Consulting

WebsiteLinkedInAll Job Openings

51 - 200 employees

🤖 Artificial Intelligence

🤝 B2B

☁️ SaaS

Artificial Intelligence • B2B • SaaS

Trility Consulting is a business-driven technology consulting firm focused on AI & Data, software design and development, cloud engineering, and DevOps. Known for its values of trust, partnership, and excellence, Trility offers a collaborative approach to tackle important business challenges with clarity and confidence. The company emphasizes continuous delivery and security by design, employing a proven, scalable methodology to achieve modern solutions. Recognized as Technology Company of the Year in Iowa, Trility is owned by its senior executives, ensuring investment and outcome-driven project management. With a focus on predictability, repeatability, and auditability, Trility serves clients across various industries, offering both full-stack solutions and strategic consulting expertise.

📋 Description

• 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

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

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