Lead Consultant (Snowflake Architect)

Job#: 2080068

Job Description:

LEAD CONSULTANT (Snowflake Architect)

WHO WE ARE

Apex Systems is a leading global technology services firm that incorporates industry insights and experience to deliver solutions that fulfill our clients' digital visions. We provide a continuum of services, including strategy and enablement, innovation and productivity, and technology foundations to drive better results and bring more value to our clients.?Apex transforms our customers with modern enterprise solutions tailored to the industries we serve. Apex has a presence in over 70 markets across North America, Europe, and India. Apex is a part of the Commercial Segment of ASGN Incorporated (NYSE: ASGN). To learn more, visit

At Apex Systems, we prioritize professional development, work-life balance, and fostering a collaborative culture. We value our teams well-being and recognize the importance of building strong relationships. That is why we organize regular team-building events and philanthropic days to give back to the community - fostering a sense of purpose and fulfillment among our team.

Join us for career advancement, innovative solutions, and a supportive environment focused on your success.

JOB DESCRIPTION

Apex Systems is seeking a Lead Consultant to serve as a Snowflake Data Architect, leading data platform modernization initiatives, helping enterprise clients design and deliver Snowflake-based solutions from inception to production. This role is part of Apex Systems' Solutions Delivery Organization and will be responsible for building scalable, cloud-based data and analytics platforms that integrate seamlessly with enterprise environments.

As a technical leader, you will drive solution architecture, data migration, and integration strategies, ensuring flexibility, scalability, and adherence to best practices. Additionally, you will provide subject matter expertise to sales and account teams during the scoping of new opportunities.

RESPONSIBLITIES

• Serve as the technical lead for project teams, ensuring high-quality execution and alignment with best practices.
• Listen and seek to understand the client and meet their needs, providing consultative guidance.
• Perform assessments of client data ecosystems and develop scalable and robust solutions architectures to meet analytics and operational demands and forecasts.
• Stay attuned to the future needs of the client and work with internal resources to identify opportunities.
• Build and foster relationships with clients, stakeholders, and technical communities, representing Apex Systems at industry events.
• Stay current with technological trends, proactively identifying innovative solutions to improve client outcomes.
• Act as a mentor to junior engineers and technical team members, fostering skills development and knowledge sharing.
• Collaborate with internal and external stakeholders to ensure project alignment with business goals and success metrics.
• Contribute to the evaluation and recruitment of technical talent through professional networking and technical screenings.
• Lead the end-to-end development of greenfield Snowflake-based solutions, from architecture and design to implementation and delivery, ensuring alignment with business and technical requirements.
• Develop scalable solution architectures, including ELT frameworks, data pipelines, and integrations with enterprise applications and analytics platforms.
• Advise clients on best practices for Snowflake architecture, security, and cost optimization to ensure long-term flexibility and scalability.
• Define standards for data quality, metadata management, and master data usage.
• Translate business needs into scalable data models and analytics capabilities.
• Drive cloud data platform modernization, leveraging Azure, AWS, or Google Cloud Platform services alongside Snowflake.
• Architect and implement data pipelines that optimize performance, cost, and operational efficiency.
• Integrate Snowflake solutions with enterprise data sources and BI platforms (e.g., Power BI, Tableau).
• Implement enterprise-grade governance and security measures, including role-based access control (RBAC), data masking, and compliance frameworks.
• Optimize Snowflake environments, including storage and compute performance, partitioning strategies, and clustering configurations.
• Act as a trusted advisor to clients and internal teams, guiding them through technical decisions and trade-offs.
• Support pre-sales efforts, including solution scoping, architecture discussions, and client presentations.
• Mentor and guide teams of developers and data engineers working within Agile delivery frameworks.

JOB REQUIREMENTS

• 7+ years of experience in enterprise data engineering and analytics architecture, with at least 3+ years of hands-on experience designing and deploying Snowflake solutions.
• Proven experience leading greenfield Snowflake implementations, building platforms from the ground up in enterprise settings.
• Extensive experience designing and implementing ELT pipelines using SQL and cloud-native tools.
• Strong understanding of modern data architectures, including Medallion lakehouse models, data vault, and dimensional modeling (Inmon & Kimball).
• Proficiency in security best practices, including Snowflake RBAC, masking policies, and compliance controls.
• Deep understanding of data quality frameworks and enterprise governance.
• Familiarity with BI tools such as Power BI, Tableau, or Looker.
• Hands-on experience optimizing Snowflake environments, including clustering keys, materialized views, and query performance tuning.
• Familiarity with streaming architectures and real-time data processing (Kafka, Snowpipe Streaming, etc.) is a plus.
• Experience working in Agile delivery environments, leading teams through solution design, implementation, and deployment.
• Strong consultative skills, with the ability to engage with stakeholders, define technical roadmaps, and deliver high-impact solutions.
• BA/BS required, preferably in Management Information Systems, Computer Information Systems, Computer Science, or related fields (applicable education and experience may be substituted).
• Advanced degree (MS) in a quantitative or related discipline preferred (applicable experience may be substituted).

Preferred

• Prior experience at Snowflake or working directly with Snowflake professional services.
• Snowflake technical certifications (SnowPro Advanced Architect, SnowPro Core).
• Experience with DataOps concepts and CI/CD pipelines for Snowflake deployments.
• Knowledge of ML/AI pipelines leveraging Snowflake's Snowpark and external ML platforms.

OUR COMPREHENSIVE BENEFITS:

• Competitive Salary
• Health, Dental and Vision Insurance
• Health Savings Accounts (HSA) with Employer Contribution
• Flexible Spending Accounts
• Long and Short-Term Disability
• Life Insurance
• Voluntary Benefits
• Employee Assistance Program
• Paid Parental Leave
• Wellness Incentives
• Vacation and Holiday Pay
• 401(k) Retirement Plan with Employer Match
• Employee Stock Purchase
• Training and Advancement Opportunities
• Tuition Reimbursement
• Birthdays Off
• Philanthropic Opportunities
• Referral Program
• Partial Gym Membership Paid
• Team Building Events
• Discount Programs

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.