Data Warehouse Architect & AI Analytics Lead

Eliassen Group; Austin (TX); Remote; USD 140,000 - 150,000; Full time

Job summary

A leading strategic consulting company is seeking a Data Warehouse Architect & AI Analytics Lead with extensive experience in data warehousing and machine learning. The role focuses on evolving data infrastructure and enabling predictive analytics. Candidates should have strong SQL and Python skills, with a collaborative approach to working with business stakeholders. The position offers competitive compensation and a flexible work environment.

Benefits

Competitive compensation

Flexible work environment

Professional growth opportunities

Collaborative team culture

Qualifications

• 7+ years of experience in data warehouse design and implementation.
• Excellent SQL and Python skills with 5+ years of experience.
• Strong communication skills and ability to work directly with business users.

Responsibilities

• Lead the design and implementation of extensions to a Data Vault 2.0-modeled data warehouse.
• Architect and pilot predictive analytics initiatives, including machine learning and LLM-based solutions.
• Collaborate with business stakeholders to gather and refine data requirements.

Skills

SQL

Python

Data Warehouse Design

Data Vault 2.0

ETL/ELT

Machine Learning

Star Schema

Snowflake Schema

DBT

Communication

Tools

Snowflake

PowerBI

VaultSpeed

Job description

Overview

Data Warehouse Architect & AI Analytics Lead – Location: Flexible (Remote, Hybrid, or Onsite in Boston). Type: Direct-Hire. Category: IT. Workplace Type: Remote. Date Posted: 10/06/2025.

Shortcut: http://internalcareers.eliassen.com/BEVOVS

About Eliassen Group

Eliassen Group is a leading strategic consulting company that provides business, IT, and clinical services for clients as they seek to transform and execute strategies that will drive exceptional outcomes. Eliassen leverages over 30 years of success on behalf of their clients, with a focus in three main areas: technology solutions, clinical solutions, and financial, risk & compliance, and advisory solutions. We are committed to positively impacting the lives of our employees, clients, consultants, and the communities in which we operate. Most recently, Energage named Eliassen Group a winner of the Top Workplaces Award, and we have been recognized as a US Best Managed Company. To learn more about our award-winning culture, visit the Eliassen Experience.

The Role

Eliassen Group is seeking a Data Warehouse Architect & AI Analytics Lead to join our high-performing team. This is a strategic, hands-on role focused on evolving our data infrastructure and enabling predictive, AI-driven analytics. The ideal candidate will bring deep expertise in data warehousing, cloud-based solutions, and machine learning, and will collaborate across business and technical teams to deliver scalable, impactful data solutions.

Responsibilities

• Lead the design and implementation of extensions to a Data Vault 2.0-modeled data warehouse.
• Architect and pilot predictive analytics initiatives, including machine learning and LLM-based solutions.
• Design and implement Star and Snowflake schemas to support BI reporting.
• Maintain and enhance automated data loading routines.
• Collaborate with business stakeholders to gather and refine data requirements.
• Develop and maintain cloud-based data solutions.
• Apply best practices in data modeling, ETL/ELT processes, and data warehousing.

Requirements

• 7+ years of experience in data warehouse design and implementation.
• 3+ years of experience with Data Vault 2.0 modeling and ETL/ELT.
• 7+ years of experience with Star and Snowflake schema design.
• Excellent SQL and Python skills with 5+ years of experience.
• 2+ years of experience with DBT (data build tool).
• Strong communication skills and ability to work directly with business users.
• 10+ years of experience with cloud-based data solutions.

Preferred Skills

• Experience with Snowflake, VaultSpeed, PowerBI and DBT.
• Familiarity with staffing industry operations and Salesforce platform.
• Experience building machine learning and/or LLM-based predictive analytics solutions.

What We Offer

• Competitive compensation and benefits.
• Flexible work environment (remote, hybrid, or onsite).
• Opportunity to work on cutting-edge AI and data warehousing projects.
• Collaborative and supportive team culture.
• Professional growth and development opportunities

Base salary: $140,000 - $150,000

This position includes additional variable compensation in the form of an annual/quarterly bonus opportunity.

W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans, some with an Employer HSA contribution), dental, vision, pre-tax accounts, other voluntary benefits, basic life and disability insurance, 401(k) with match, and PTO consisting of 10 holidays, 5 sick days (or more if required by law in the state/locality where you work), 15+ days of vacation (based on tenure), bereavement leave, and 6-8 weeks paid maternity/disability leave and 2-4 weeks paid parental leave (based on tenure).