BI & DATA ARCHITECT (Retail or Ecommerce domain Experience must)

BI & DATA ARCHITECT

Location: New York (Brooklyn preferred) / Client-Facing (at least 3 days onsite)

Duration Contract to Hire

Role Summary

We are seeking a BI & Data Architect to lead data, analytics, and BI transformation initiatives for retail and eCommerce clients. This role will lead BI tool assessments, define data and reporting strategy, design scalable architectures, and drive end-to-end implementations.

Key Responsibilities

Lead BI tool assessments across ETL, Data Warehouse, and BI tools

Review current architecture and identify gaps

Define evaluation criteria and scoring models

Evaluate integration with Shopify, NetSuite, and POS systems

Design end-to-end BI architecture (ETL, DWH, Semantic Layer, Reporting)

Lead stakeholder workshops and KPI alignment

Drive implementation of BI solutions

Present recommendations to IT and business leadership

Required Experience

10 15+ years in BI / Data Architecture / Data Engineering

Experience in tool evaluation and platform selection

Retail / eCommerce experience preferred

Experience with Shopify, NetSuite, POS systems is a plus

Technical Skills

ETL / ELT tools (Alteryx, Informatica, Matillion, Fivetran)

Data Warehouses (Snowflake, Redshift, BigQuery, Synapse)

Data modeling (star schema, dimensional modeling)

BI tools (MicroStrategy, Tableau, Power BI, etc.)

Consulting & Communication Skills

Strong problem-solving and analytical thinking

Ability to translate business needs into technical solutions

Client-facing communication skills

Ability to present to senior leadership

Success Criteria

Deliver clear tool recommendations

Design scalable architecture

Drive business and IT alignment

Enable smooth transition from assessment to implementation

Why Join Us

Lead BI transformation initiatives

Work with CIOs and business leadership

Be part of a high-growth consulting firm

Build next-generation data and analytics solutions