Data Warehouse Lead/Arch Snowflake

Vaco; Charlotte (NC); On-site; USD 140,000 - 200,000; Full time

Benefits offered by this job

Discretionary bonuses

Medical, dental, and vision benefits

401(k) retirement plan

Job summary

Vaco seeks a Data Warehouse Lead / Snowflake Architect to drive the design and evolution of the enterprise data platform. You will own Snowflake architecture and collaborate with business and technology teams to deliver scalable analytics for operational reporting, financial analysis, and executive decision-making.

Responsibilities include leading Snowflake development, designing scalable ETL/ELT pipelines, building dimensional models, governance, and data quality, and optimizing performance,

Qualifications

• 8+ years in data warehousing, data architecture, or data engineering.
• Snowflake administration, architecture, and optimization experience.
• Experience building cloud-based ETL/ELT solutions with dbt, Matillion, Fivetran, or similar.
• Strong SQL development and data modeling skills.
• Knowledge of data governance, data quality, security, and master data management.
• Experience integrating data from ERP, financial, and operational systems.

Responsibilities

• Lead the architecture and development of the Snowflake data warehouse and enterprise data platform.
• Design and implement scalable ETL/ELT pipelines from ERP, financial, project management, and operational systems.
• Develop and maintain dimensional models, governance standards, and data quality processes.
• Partner with business stakeholders, analysts, and engineering to define reporting requirements.
• Optimize Snowflake performance, security, scalability, and cost management.
• Support enterprise reporting initiatives and enable self-service analytics.
• Troubleshoot data issues and provide technical leadership for data platform initiatives.
• Create architecture documentation and data lineage to support long-term growth.

Skills

Snowflake architecture

Advanced SQL

Data modeling

Data governance

Data quality

Master data management

ERP/financial systems integration

Tools

dbt

Matillion

Fivetran

Azure Data Factory

Informatica

Job description

W2 only- Full Time Placement - No C2C, Third Party Vendors or Sponsorship for this role

Must be located in the United States to even be considered

We are seeking a Data Warehouse Lead / Snowflake Architect to lead the design, implementation, and evolution of our enterprise data platform. This individual will own the architecture of our Snowflake environment and help drive data strategy across multiple operating companies. You'll partner with business and technology teams to deliver scalable, high-performing analytics solutions that support operational reporting, financial analysis, and executive decision-making.

What You'll Do

• Lead the architecture and development of our Snowflake data warehouse and enterprise data platform.
• Design and implement scalable ETL/ELT pipelines to integrate data from ERP, financial, project management, and operational systems.
• Develop and maintain dimensional data models, data governance standards, and data quality processes.
• Partner with business stakeholders, analysts, and engineering teams to define reporting and analytics requirements.
• Optimize Snowflake performance, security, scalability, and cost management.
• Support enterprise reporting initiatives and enable self-service analytics through modern BI solutions.
• Troubleshoot complex data issues and serve as the technical lead for data platform initiatives.
• Create architecture documentation, data lineage, and best practices to support long-term platform growth.

What We're Looking For

• 8+ years of experience in data warehousing, data architecture, or data engineering.
• Strong expertise with Snowflake architecture, administration, and optimization.
• Experience building cloud-based ETL/ELT solutions using tools such as dbt, Matillion, Fivetran, Azure Data Factory, Informatica, or similar.
• Advanced SQL development and data modeling experience.
• Strong understanding of data governance, data quality, security, and master data management.
• Experience integrating data from ERP, financial, and operational business systems.
• Ability to communicate effectively with both technical and business stakeholders.

Preferred Qualifications

• SnowPro or other Snowflake certifications.
• Experience with Power BI, Tableau, or similar analytics platforms.
• Background supporting enterprise data modernization or ERP transformation initiatives.
• Experience working in multi-company or acquisition-driven environments.

Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to the individual's skill sets, experience and training, licensure and certification requirements, office location and other geographic considerations, as well as other business and organizational needs. With that said, as required by local law in geographies that require salary range disclosure, Vaco/Highspring notes the salary range for the role is noted in this job posting. The individual may also be eligible for discretionary bonuses, and can participate in medical, dental, and vision benefits as well as the company's 401(k) retirement plan. Additional disclaimer: Unless otherwise noted in the job description, the position Vaco/Highspring is filing for is occupied. Please note, however, that Vaco/Highspring is regularly asked to provide talent to other organizations. By submitting to this position, you are agreeing to be included in our talent pool for future hiring for similarly qualified positions. Submissions to this position are subject to the use of AI to perform preliminary candidate screenings, focused on ensuring minimum job requirements noted in the position are satisfied. Further assessment of candidates beyond this initial phase within Vaco/Highspring will be otherwise assessed by recruiters and hiring managers. Vaco/Highspring does not have knowledge of the tools used by its clients in making final hiring decisions and cannot opine on their use of AI products.

EEO Notice

Vaco by Highspring is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race (including but not limited to traits historically associated with race such as hair texture and hair style), color, sex (includes pregnancy or related conditions), religion or creed, national origin, citizenship, age, disability, status as a veteran, union membership, ethnicity, gender, gender identity, gender expression, sexual orientation, marital status, political affiliation, or any other protected characteristics as required by federal, state or local law.

Vaco by Highspring and its parents, affiliates, and subsidiaries are committed to the full inclusion of all qualified individuals. As part of this commitment, Vaco by Highspring and its parents, affiliates, and subsidiaries will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact [e-mail].

Vaco by Highspring also wants all applicants to know their rights that workplace discrimination is illegal.

Representation Notice

By submitting to this position, you agree that you will be giving Vaco by Highspring the exclusive right to present your as a candidate for the foregoing employment opportunity. You further agree that you have represented information about yourself accurately and have not affirmatively misrepresented your qualifications. You also agree to maintain as confidential, to the fullest extent permitted by law, any information you learn from Vaco by Highspring about the position and you will limit disclosure of information about the position only to the extent necessary to perform any obligations in furtherance of your application. In exchange, Vaco by Highspring agrees to exercise reasonable efforts to represent you through all solicitation, job screening and resume dispersal.

For residents of Ontario, Canada: Based on Highspring's discussions with its Client, Highspring's understanding is that this position for employment is a current vacancy (either through Highspring as a contractor or with the client directly).

Privacy Notice

Vaco by Highspring and its parents, affiliates, and subsidiaries ("we," "our," or "Vaco by Highspring") respects your privacy and are committed to providing transparent notice of our policies.

• California residents may access Vaco by Highspring HR Notice at Collection for California Applicants and Employees here.
• Virginia residents may access our state specific policies here.
• Residents of all other states may access our policies here.
• Canadian residents may access our policies in English here and in French here.
• Residents of countries governed by GDPR may access our policies here.

Additionally, submissions to this position are subject to the use of AI to perform preliminary candidate screenings, focused on ensuring minimum job requirements noted in the position are satisfied. More details about Vaco by Highspring's use of AI can be found here (https://www.highspring.com/ai-use-notices/). Further assessment of candidates beyond this initial phase will be conducted by recruiters and hiring managers. Vaco by Highspring does not know and cannot opine on if its client's use of AI products in hiring.

Pay Transparency Notice

Determining compensation for this role (and others) at Vaco/Highspring depends upon a wide array of factors including but not limited to:

• the individual's skill sets, experience and training;
• licensure and certification requirements;
• office location and other geographic considerations;
• other business and organizational needs.

With that said, as required by local law, Vaco by Highspring believes that the following salary range referenced above reasonably estimates the base compensation for an individual hired into this position in geographies that require salary range disclosure. The individual may also be eligible for discretionary bonuses.