Snowflake Engineering Consultant

We’re hiring a Snowflake Data Engineering Consultant!Employment Type: Full Time/Direct Hire (No Agencies, No C2C)Location: Atlanta, GA, Washington, DC, NYC, Richmond, VA & Charlotte, NC Metro AreasLocation Type: Hybrid (1-2 days onsite per week) - Home Office/Local Ippon office 
About Ippon:The Ippon story started in 2002 in Paris, France - cue in the accordion. Our founder and CEO Stéphane Nomis used his unique experience as an international Judo champion to create a culture based on the sports values of ambition and excellence. Our USA Headquarters office is located in Richmond, VA, with additional offices in New York, NY,  Washington DC, and Atlanta, GA. We are a technology consulting firm that specializes in helping accelerate our client’s digital roadmap in the areas of Product Management, Cloud, Data, and Software Engineering. 
About the position:We are seeking a Snowflake Data Engineering Consultant to play a pivotal, hands-on role in the design, development, and execution of cloud data solutions for our enterprise clients. This position is ideal for an experienced data consulting professional ready to bridge the gap between high-level architectural strategy and technical implementation. You will be responsible for translating business requirements into secure, cost-effective Snowflake architectures, participating directly in the execution of complex data migration projects, and ensuring best practices are followed across all data pipelines and modeling efforts. If you are passionate about the technical mastery of the Snowflake Data Cloud, skilled in performance optimization, and ready to collaborate closely with both engineering teams and client stakeholders to deliver value, this role is for you.

Roles And Responsibilities:

• Client Advisory and Consulting:
• Act as a trusted advisor to clients, helping them define and execute on their data strategy.
• Translate business challenges into secure, scalable, cost-effective data solutions.
• Support data discovery sessions and maturity assessments to identify gaps and opportunities.
• Serve as a technical contributor in client discussions, translating business requirements into technical specifications.
• Advise clients on best practices around insight quality


• Complex Project Delivery:
• Execute key phases of end-to-end data migrations from legacy platforms (e.g., Teradata, Oracle, Redshift) to Snowflake.
• Contribute to the design of migration strategies and assist in developing implementation roadmaps.
• Implement advanced Snowflake features in client environments: Snowpipe, Snowpark, Dynamic Tables, Time Travel, and Zero-Copy Cloning.
• Support the designing and building of secure, efficient Snowflake architectures for specific data domains, ensuring alignment with business objectives.
• Create and maintain detailed technical documentation, data models, and implementation guides.
• Ensure data quality and security standards are met within the implemented solutions. (GDPR, HIPAA, SOX)
• Follow agile delivery methodologies and ensure timely completion of assigned technical deliverables.


• Thought-Leadership and Innovation:
• Stay current on market-leading data offerings and platforms (e.g., Snowflake, Databricks, Redshift, PowerBI, Tableau, Looker, etc).
• Contribute to the evolution of internal offerings around data, decision intelligence, and AI/ML readiness.
• Lead internal and external workshops, demos, and enablement sessions to foster data literacy.
• Share industry insights, trends, and new technologies with both clients and internal teams.


• Collaboration and Communication:
• Collaborate with internal and external stakeholders, architects, tech leads, business analysts, engineers, and data scientists to align data engineering contributions with business priorities.
• Present findings and recommendations to both technical and executive audiences.
• Provide support and knowledge-sharing to junior engineers and team members on best practices.

Competencies We Are Looking For:

• Minimum Qualifications:
• Bachelor's degree in Computer Science or a related field, or equivalent experience
• 4+ years of experience in data engineering, warehousing, or architecture across modern data cloud platforms
• 3+ years of proven expertise with the Snowflake platform and advanced features
• 1+ year experience with data migration projects from on-premises to cloud solutions
• Experience optimizing Snowflake architecture, queries, and warehouse usage to ensure maximum efficiency and minimize costs.
• Strong proficiency in SQL, Python, and cloud platforms (AWS/Azure/GCP)
• Deep understanding of ETL/ELT processes, data modeling, and warehouse design
• Experience with migration tools  such as SnowConvert, Matillion, Informatica, Talend, and dbt
• Excellent verbal and written communication skills to support presentations, client discussions, technical documentation, and conveying complex technical concepts to non-technical stakeholders and team members
• Strong analytical and problem-solving skills with an outcomes-oriented mindset


• Preferred Qualifications:
• SnowPro Core Certification (Advanced certifications a plus)
• Working experience in highly regulated industries such as Financial Services, Insurance, Healthcare, Logistics, and Education
• Skilled in collaborating with multidisciplinary teams to achieve shared goals efficiently and effectively.
• Enterprise-scale data consulting experience with the ability to understand client requirements, build relationships, and deliver successful solutions
• Demonstrated project leadership skills with the ability to guide, motivate, and inspire team members and stakeholders toward achieving shared objectives.
• Cloud Certifications in AWS, Azure, or GCP
• Knowledge of CI/CD pipelines and DevOps best practices
• Experience with Infrastructure as Code (Terraform, CloudFormation)
• Effective time management and organizational skills

What We Offer:

• Great salary and benefits - Health (HDHP & PPO Plans), dental, and vision insurance, HSA, EAP, as well as a 401k with company match
• Work/life balance - Ippon offers generous PTO, parental leave, medical leave, and flexible schedules
• A fun, creative, and healthy work environment, focused on teamwork, knowledge-sharing, and exceptional delivery
• Opportunities to expand your portfolio and work with different companies and industries
• Career growth, upskilling, cross-training, and leadership opportunities

We value the diversity and different perspectives each of our employees bring to Ippon Technologies.
Ippon Technologies is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, age, national origin, veteran, or disability status.
Visit us on LinkedIn or at https://ipponusa.com/ to learn more.
So, do YOU speak Ippon?