Data Architect Consultant

- Senior

Vienna, VA

About the position

We are seeking an experienced Data Architect Consultant to provide expert guidance in designing and implementing scalable, secure, and commerce-driven data architectures for our clients. In this role, you will work with organizations across retail, e-commerce, and enterprise sectors to assess their data needs, define best practices, and lead product and transaction-driven data transformation initiatives. The ideal candidate will have deep technical expertise in data architecture, modeling, governance, and security, along with experience in commerce-related data solutions, including Product Information Management (PIM), Business Intelligence (BI), and analytics on product attributes, orders, transactions, and customer data. Additionally, experience with row-level and column-level security, data masking, and access control strategies will be crucial in ensuring data integrity and privacy. You will collaborate closely with client stakeholders, data engineers, and analysts to deliver tailored solutions that enhance product data management, sales insights, and supply chain analytics.

Responsibilities

• Design and implement scalable and secure data architectures using cloud and hybrid technologies (AWS, Azure, Google Cloud, on-premise).
• Develop and optimize data models for commerce-related datasets, including product catalogs, SKUs, pricing structures, and order management systems (OMS).
• Lead the architecture and governance of Product Information Management (PIM) systems, ensuring structured product attributes, taxonomy, and metadata alignment.
• Establish and enforce data security frameworks, including role-based access control (RBAC), row-level security (RLS), and column-level security (CLS) for commerce and customer data.
• Build and manage data pipelines and ETL/ELT processes to integrate multi-source product, inventory, and transactional data across e-commerce platforms, ERP, CRM, and analytics tools.

Requirements

• Strong experience in data architecture, data modeling, and database management (SQL, NoSQL, Graph databases).
• Hands-on expertise with cloud data platforms (AWS Redshift, Snowflake, Google BigQuery, Azure Synapse).
• Proficiency in ETL/ELT tools and data integration (dbt, Apache Airflow, Informatica, Talend, Fivetran).
• Deep understanding of data security, row-level and column-level security (RLS, CLS), access controls, and compliance frameworks.
• Experience architecting solutions for Product Information Management (PIM), Master Data Management (MDM), ERP, CRM, and Order Management Systems (OMS).

Nice-to-haves

• Experience with big data and streaming technologies (Hadoop, Spark, Kafka).
• Knowledge of BI and analytics tools (Power BI, Tableau, Looker, Google Analytics, Adobe Analytics) for commerce and sales insights.
• Experience working with AI/ML data pipelines for predictive commerce analytics is a plus.
• Strong communication and stakeholder management skills to influence decision-making.
• Hands-on knowledge of role-based access control (RBAC), dynamic data masking (DDM), encryption, and compliance frameworks (GDPR, CCPA, HIPAA, PCI-DSS).

Benefits

• A career with thought leaders who literally wrote the book on Marketplace Best Practices.
• A career in the fast-paced world of retail eCommerce, digital marketplaces, and platform businesses.
• A career with first movers who are deploying new business models and strategies worldwide.
• A career in a flat management structure without a rigid hierarchy and bureaucracy.
• A career in a culture that rewards creativity and innovation, risk-taking, and teamwork.