Data Architect Consultant

We are seeking an experienced Data Architect Consultant to provide expert guidance in designing and implementing scalable secure and commercedriven data architectures for our clients. In this role you will work with organizations across retail ecommerce and enterprise sectors to assess their data needs define best practices and lead product and transactiondriven data transformation initiatives.

The ideal candidate will have deep technical expertise in data architecture modeling governance and security along with experience in commercerelated data solutions including Product Information Management (PIM) Business Intelligence (BI) and analytics on product attributes orders transactions and customer data. Additionally experience with rowlevel and columnlevel 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:

1. Design and implement scalable and secure data architectures using cloud and hybrid technologies (AWS Azure Google Cloud onpremise).
2. Develop and optimize data models for commercerelated datasets including product catalogs SKUs pricing structures and order management systems (OMS).
3. Lead the architecture and governance of Product Information Management (PIM) systems ensuring structured product attributes taxonomy and metadata alignment.
4. Establish and enforce data security frameworks including rolebased access control (RBAC) rowlevel security (RLS) and columnlevel security (CLS) for commerce and customer data.
5. Build and manage data pipelines and ETL/ELT processes to integrate multisource product inventory and transactional data across ecommerce platforms ERP CRM and analytics tools.

Additional Responsibilities:

• Implement data governance master data management (MDM) and cataloging for PIM and commerce analytics solutions.
• Provide realtime 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 commercerelated data solutions secure data management and analytics strategies.

Qualifications :

Top 5 Qualifications:

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

Additional Qualifications:

• 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 decisionmaking.
• Handson knowledge of rolebased access control (RBAC) dynamic data masking (DDM) encryption and compliance frameworks (GDPR CCPA HIPAA PCIDSS).

• Bachelors or Masters degree in Computer Science Data Science Information Systems or a related field.
• 7 years of experience in data architecture data engineering or data security consulting.
• Prior experience in a consulting firm technology advisory or as an independent consultant is preferred.
• Relevant cloud and data security certifications (AWS Certified Data Analytics Google Professional Data Engineer Snowflake Data Architect CISSP CISM) are a plus.

What We Can Offer You:

• A career with thought leaders who literally wrote the book on Marketplace Best Practices.
• A career in the fastpaced 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 risktaking and teamwork.

Additional Information :

Our Core Values: Client Focus Ownership Adaptability and Caring.

Keywords: Data Architecture Cloud Data Platforms PIM ETL BI Data Security Commerce Analytics RoleBased Access Control Data Governance eCommerce Data Solutions.

McFadyens goal is to ensure that our clients are able to maximize the return on their technology investment by providing better service to their clients partners and internal teams. At McFadyen we truly believe our employees are our most valuable asset. Across our locations in the US Brazil and India we offer a world class work culture that enables top notch delivery for some of the worlds most influential companies.  

McFadyen Solutions Digital is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color age religion sex sexual orientation gender identity / expression national origin disability protected veteran status or any other characteristic protected under federal state or local law where applicable. 

Remote Work :

Yes

Employment Type :

Fulltime