Data Architect Consultant at McFadyen Digital – Vienna, VA,

Data Architect Consultant at McFadyen Digital – Vienna, VA, United States Company Description

McFadyen Digital is the leading advisor and implementer of eCommerce Marketplace solutions. During 15 years of implementing marketplaces, we’ve built dozens of platforms that cumulatively generate billions of dollars of gross merchandise value (GMV). We’re honored to have supported 10% of the Fortune 500 with their digital marketplace initiatives. Over 250 global brands like ABB, AB InBev, ACCO, Albertsons, American Red Cross, American Eagle Outfitters, US Army, US Agriculture Dept, (and many more) have entrusted their digital transformations to McFadyen.

We operate global offices across the US, Brazil, and India. McFadyen Digital has been a trusted employer for 37 years and believes that people are the most important part of our company. We’re proud of our Great Place to Work certification.

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

Top 5 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.

Additional Responsibilities:

• Implement data governance, master data management (MDM), and cataloging for PIM and commerce analytics solutions.
• Provide real‑time and batch data analytics to support BI dashboards, sales performance tracking, inventory forecasting, and personalized customer insights.
• Optimize customer order data storage and transaction processing architectures for scalability and compliance.
• Implement data masking, encryption, and anonymization techniques to protect sensitive customer and transaction data while ensuring GDPR, CCPA, HIPAA, and SOC 2 compliance.
• Conduct technical assessments, proof of concepts (POCs), and architecture reviews to drive innovation and efficiency.
• Provide client training, documentation, and advisory support on commerce‑related data solutions, secure data management, and analytics strategies.

Top 5

Qualifications:

• Strong experience in data architecture, data modeling, and database management (SQL, No
  
  SQL, Graph databases).
• Hands‑on expertise with cloud data platforms (AWS Redshift, Snowflake, Google Big Query, 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…