The Role
The role involves designing, developing, and implementing cloud data solutions with Snowflake, translating business needs into technical specifications, and executing data migrations while ensuring data quality and security.
Summary Generated by Built In
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
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?
Top Skills
AWS
Azure
Dynamic Tables
Elt
ETL
GCP
Python
Snowflake
Snowpark
Snowpipe
SQL
Time Travel
Zero-Copy Cloning
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
USING OUR COLLECTIVE ENERGY FOR POSITIVE TECHNOLOGY
Ippon is a consulting and expertise firm, who is convinced that technology is a source of progress for society. We help our clients leverage their digital assets to design an appropriate strategy and deploy their transformation roadmap at scale.
Product ⦿ Data ⦿ Cloud & DevOps ⦿ Software Engineering
STRATEGY
Design your organization's strategy and deploy your roadmap at scale to deliver value expected by the market.
TECHNOLOGY
We rely on powerful technology platforms to drive innovation and modernization.
TRANSFORMATION
Accelerating digital transformation for your organization by applying adapted support methodologies
