Snowflake Engineering Consultant

Ippon Technologies-posted 2 months ago
$115,000 - $135,000/Yr
Full-time • Mid Level
Richmond, VA
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
Snowflake Data Engineer Resume Examples
•
Snowflake Data Engineer Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service