Practices Approach Client Stories Blog Brief a Mandate
Case Study · Technology Leadership

Hiring a Snowflake Data Architect for a US-Based IT Services Firm

IT Services · Data Engineering 500+ employees Enterprise / Fortune 500 clients

A US-based IT services firm with a large India delivery center — serving Fortune 500 clients including Lockheed Martin, Macy's, and AT&T — had a Snowflake Data Architect seat sitting vacant for six months. Zifcare closed it in 15 days, with a candidate whose direct Snowflake experience was thinner than the brief called for, but whose fundamentals made the case.

Mandate Vitals
15 daysTime to hire
₹30L + incentivesSalary offered
500+Company size at hiring
4Profiles shared
2Candidates interviewed

Client overview

The client is a US-based IT services firm with a large development center in India, serving Fortune 500 accounts including Lockheed Martin, Macy's, and AT&T. They needed an experienced Snowflake Data Architect to lead their data-engineering initiatives and keep data solutions scalable and efficient for enterprise clients.

The brief

The role called for a specific, hard-to-find combination:

  • Strong hands-on Snowflake expertise, ideally 3+ years
  • Experience across cloud platforms (AWS/Azure) and ETL tooling
  • Leadership capability to manage technical teams
  • A stable career history with exposure to large-scale enterprise projects

Given how niche the skill set was, the process had to move fast without cutting corners on rigor.

Shortlisting

The team reviewed a wide pool and narrowed it to four candidates, screened on Snowflake depth, cloud/ETL exposure, leadership experience, and notice-period flexibility.

CandidateExperienceSnowflake exp.Key skillsNotice period
Candidate A14 yrs3 yrs Snowflake, Matillion, led a 12-person team45 days (neg. to 30)
Candidate B13 yrs5 yrs Snowflake, AWS/Azure, ETL (NiFi, Talend)Immediate
Candidate C19 yrs3–4 yrs Snowflake, Snowpark, AI chatbots15 days
Candidate DSelected16 yrs1 yr SQL, data architecture, led a 7-person teamImmediate

Why Candidate D, with the least Snowflake experience, won

On paper, Candidate D had the thinnest Snowflake background of the four — one year, against a brief that asked for three or more. The client backed them anyway, on the strength of:

  • Strong SQL and data-architecture fundamentals
  • Proven leadership managing a 7-member analyst team
  • Extensive experience with Fortune 500 clients, including Nordea Bank and HP
  • A long tenure at Capgemini that signalled real job stability

The client's read was that a candidate this strong on data-engineering fundamentals and client-facing leadership would ramp up on Snowflake specifically far faster than someone with narrower, checkbox-matched experience.

Outcome and impact

  • Successful hire within 4 weeks of the shortlist being presented
  • Smooth onboarding paired with structured Snowflake upskilling
  • Stronger team leadership and client engagement from day one

Have a niche technical seat sitting open?

We're comfortable trading a checkbox skill for the right fundamentals — when the data backs it.

Brief us on a mandate