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 Areas

Location Type: Hybrid (1-2 days onsite per week) - Home Office/Local Ippon office

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.

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.

• 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, Power
    
    BI, 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.

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