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