Data Warehouse Architect

Data Warehouse Architect & AI Analytics Lead

Anywhere

Type: Direct-Hire

Category: IT

Workplace Type: Remote

Date Posted: 11/05/2025

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

• Description

• Recommended Jobs

Data Warehouse Architect & AI Analytics Lead

Location: Flexible (Remote, Hybrid, or Onsite in Boston)

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 theTop Workplaces Award (https://www.eliassen.com/newsroom/energage-names-eliassen-group-a-winner-of-the-top-workplaces-2023-award) ,and we have been recognized as aUS Best Managed Company (https://www.eliassen.com/newsroom/eliassen-group-recognized-as-a-us-best-managed-company) . To learn more about our award-winning culture, visit theEliassen Experience (https://www.eliassen.com/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, ETL/ELT, Snowflake and DBT.

• 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 VaultSpeed and PowerBI.

• 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).