Snowflake Data Consultant at Jobgether – United States

This position is posted by Jobgether on behalf of a partner company. We are currently looking for a Snowflake Data Consultant in United States.

This role provides a unique opportunity to lead the modernization of complex data environments, transforming legacy Oracle BI and ODI workflows into optimized, scalable Snowflake solutions. You will work hands-on to redesign data models, implement ELT transformations, and ensure data quality, performance, and maintainability. The position requires deep technical expertise, analytical thinking, and the ability to untangle legacy structures while designing modern, future-proof architectures. You will collaborate closely with cross-functional teams to validate results and support analytics needs. This role is ideal for someone who thrives in complex migration projects, enjoys problem-solving at scale, and takes pride in delivering clean, efficient, and high-performing data systems. The position is fully remote and designed for self-driven professionals who can balance autonomy with collaborative teamwork.

• Analyze, interpret, and reverse-engineer existing Oracle Data Integrator (ODI) workflows and legacy data transformation logic
• Document and map current data flows, dependencies, and structures to guide modernization
• Design Snowflake-optimized data models and ELT patterns for scalable and high-performance solutions
• Write efficient SQL queries and implement ELT transformations within Snowflake
• Restructure legacy models into maintainable, normalized architectures, cleansing redundant or outdated artifacts
• Build modular, testable transformation pipelines using DBT or similar tools
• Manage Snowflake development environments, including roles, access control, and governance
• Establish validation, reconciliation, and data quality checks to ensure accuracy during migration

Requirements:

• 5+ years of experience in data engineering or data consulting roles
• Strong hands-on expertise with Oracle Data Integrator (ODI) and legacy transformation logic
• Deep experience in Snowflake development, including data modeling and performance optimization
• Proficiency with SQL and modern ELT/ETL frameworks, including DBT
• Strong understanding of data warehousing, normalization, and best practices for scalable architectures
• Experience validating data migrations between legacy and modern platforms
• Ability to work independently in complex technical environments while collaborating effectively with QA and review teams
• Excellent written and verbal communication skills
• Must reside in the United States and be authorized to work without sponsorship now or in the future

Benefits:

• Fully remote work with flexible schedules
• Opportunities for professional development and sponsored learning
• Hands-on experience modernizing large-scale, high-impact data environments
• Collaborative, supportive team culture with emphasis on growth and skill-building
• Exposure to cutting-edge data platforms and transformation methodologies
• Competitive compensation commensurate with experience