Skip to Main Content

Snowflake Architect

Infinitive Inc
Ashburn, VA
  • Posted: over a month ago
  • Full-Time
Job Description

Infinitive is a transformation and technology consultancy that enables global brands to deliver results through insights, innovation, and efficiency. We possess deep industry and technology expertise to drive and sustain adoption of new capabilities. We match our people and personalities to our clients' culture while bringing the right mix of talent and skills to enable high return on investment.

Infinitive has been named “Best Small Firms to Work For” by Consulting Magazine 6 times. Infinitive has also been named a Washington Post “Top Workplace”, Washington Business Journal “Best Places to Work”, and Virginia Business “Best Places to Work.”

About this Role:

We are currently seeking a skilled Snowflake Architect to join our growing technology team. This person will architect and implement Snowflake following industry best practices to ensure clients are enabled to leverage the full capabilities of Snowflake.

We are looking for candidates who are accountable, passionate, assertive, proactive, open & honest, results oriented, and adaptable. Each project engagement represents a new challenge that will give you exposure to new clients, business issues, technologies, and people.

What You'll Do:

  • Be a technical expert on all aspects of Snowflake.
  • Deploy Snowflake following best practices, including ensuring knowledge transfer so that customers are properly enabled and are able to extend the capabilities of Snowflake on their own.
  • Lead and Architect migration of data analytics environment from Teradata to Snowflake with performance and reliability.
  • Assess and understand the ETL jobs, workflows, BI tools and reports.
  • Based on the findings from the assessment, define a high level roadmap for migration to Snowflake on Azure along with a future state reference architecture on Azure cloud.
  • Responsible for end-to-end data analytics design and architecture for Snowflake in Azure.
  • Improve existing data pipelines in cloud for data transformation and aggregation.
  • Address a majority of technical inquiries concerning customization, integration, enterprise architecture and general feature / functionality of Snowflake.

What We're Looking For:

  • Expertise in Snowflake data modeling, ELT using Snowflake SQL, implementing complex stored procedures and standard DWH and ETL concepts.
  • Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features.
  • Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe and Big Data model techniques using Python.
  • Experience in Data Migration from RDBMS to Snowflake cloud data warehouse.
  • Provide direction on adoption of Cloud technologies (Snowflake) and industry best practices in the field of data warehouse architecture and modelling.
  • Technical degree in computer science or related field (preferred)
  • Experience working in an Agile environment
  • Background in management consulting (preferred)
  • Excellent leadership, peer management, and communication skills
  • Have a Kick-Ass Attitude
  • Desire to Be Great and strive for continual growth
  • Strong analytical, conceptual, organizational, and problem-solving skills.
  • Ability to effectively interface with all levels of personnel and management.

Applicants for employment in the U.S. must possess work authorization which does not require sponsorship by the employer for a visa.

Infinitive is an Equal Opportunity Employer.

Powered by JazzHR


Infinitive Inc


Ashburn, VA



View all jobs at Infinitive Inc

What email should the hiring manager reach you at?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.