BI & Data Architect - PMO, Retail / eCommerce experience - Hybrid role - ONLY W2

company: Cygnus Professionals Inc.
location: Brooklyn, NY, United States
posted: 18 May

**JD:**
**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

see more ecommerce jobs in united states →