logo inner

Staff Data Architecture Consultant

Ippon TechnologiesRichmond, Virginia, United States | Atlanta, Georgia, United States | Charlotte, North Carolina, United States | Washington D.c., New York, United StatesHybrid, Onsite

We’re hiring a Staff Data Architecture Consultant


Employment Type:

Full Time/Direct Hire (No Agencies)

Location:

Washington, DC, NYC, Richmond, VA, Charlotte, NC, and Atlanta, GA Metropolitan Regions 

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 currently seeking a Staff Data Architecture Consultant with significant expertise in Snowflake to lead complex data migrations and serve as an advisor to our clients who are facing data-related challenges. This person will need to seamlessly transition between pre-sales meetings, delivering complex technical architectures, and defining strategic goals and roadmaps for the business. We are looking for someone to help improve our data migration offerings, leveraging the capabilities of Snowflake, and position our organization for long-term success with our data-driven clients.

Roles and Responsibilities:


  • Client Advisory and Strategic Consulting:
  • Lead complex data migrations to Snowflake in highly regulated data environments.
  • Act as a trusted advisor to clients, understanding their business challenges and translating them into actionable data strategies.
  • Conduct thorough assessments of client data environments and identify opportunities for optimization using Snowflake.
  • Develop and present strategic data roadmaps, outlining key initiatives and timelines to achieve client business goals.
  • Lead pre-sales engagements, demonstrating the value of Snowflake and our data management services to prospective clients.
  • Effectively communicate technical concepts to both technical and non-technical audiences.
  • Snowflake Architecture and Implementation:
  • Design and implement scalable and efficient data architectures within the Snowflake Data Cloud.
  • Develop and optimize data pipelines for data ingestion, transformation, and loading (ETL/ELT) within Snowflake.
  • Configure and manage Snowflake features, including virtual warehouses, data sharing, and security.
  • Provide technical expertise on Snowflake best practices, such as performance tuning and cost optimization.
  • Data Management and Governance:
  • Establish and enforce data governance policies & procedures within highly-regulated environments.
  • Provide guidance on data security and compliance requirements within Snowflake.
  • Implement data quality checks and validation processes to ensure data accuracy.
  • Develop and maintain data documentation and metadata management best practices.
  • Collaboration and Thought-Leadership:
  • Collaborate cross-functionally with engineering, analytics, project management, and stakeholders to ensure projects are delivered on time and within budget.  
  • Mentor junior engineers, foster an environment of continuous learning, and leverage innovation to strengthen data consulting offerings.
  • Stay ahead of industry trends in the Snowflake portfolio, complementary ISVs, and cloud data platforms, driving innovation by sharing knowledge with clients and internal teams

Competencies we are looking for:


  • Minimum Requirements:
  • SnowPro Core Certification 
  • 10+ years of experience designing, implementing, and migrating cloud-based data architectures
  • 5+ years of experience with Snowflake data warehousing, advanced data modeling, performance optimization, security configurations, Snowpipe, and data sharing
  • 4+ years of experience consulting on complex data migration projects leveraging Snowflake
  • 4+ years of experience developing and managing ETL/ELT processes and data pipelines for Snowflake, using tools such as Airflow and DBT
  • The ability to understand client requirements, build relationships, and deliver tailored solutions that meet their specific data needs
  • Meticulous attention to detail, time management, and problem-solving skills when designing high-quality data models
  • Excellent verbal and written communication skills to convey complex technical concepts to both technical and non-technical team members and clients
  • Preferred Requirements:
  • Bachelor's degree in Computer Science or a related field, or equivalent experience
  • SnowPro Advanced: Data Engineering Certification preferred
  • Leadership qualities to guide and inspire team members and stakeholders in achieving goals

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, and 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

$150,000 - $170,000 a yearWe 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?Apply for this job

Life at Ippon Technologies

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.
Thrive Here & What We Value1. Innovation and Growth Mindset2. Personal Growth3. Sportsmanship as a Leitmotif (Depassement de Soi)4. Value-Driven Solutions5. Knowledge Sharing6. Collective Force and Community Building7. Performance and Excellence8. Progression Opportunities9. Work-Life Balance1e. Fun and Supportive Work Environment12. Innovation and Agility15. Proactive Client Engagement16. Agile Team Approach

Related Sub

This job belongs to these sub. Explore related roles here:
Your tracker settings

We use cookies and similar methods to recognize visitors and remember their preferences. We also use them to measure ad campaign effectiveness, target ads and analyze site traffic. To learn more about these methods, including how to disable them, view our Cookie Policy or Privacy Policy.

By tapping `Accept`, you consent to the use of these methods by us and third parties. You can always change your tracker preferences by visiting our Cookie Policy.

logo innerThatStartupJob
Discover the best startup and their job positions, all in one place.
Copyright © 2025