Were 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 clients 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:
Bachelors 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
$115000 - $135000 a year
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.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.