Advisor, Master Data Management - Data Architect

Job Summary

The MDM Data Architect will lead the design, management, and governance of Orgill’s data architecture to support strategic business objectives. This role ensures that data systems are scalable, secure, and aligned with business needs, focusing on optimizing data flow and analytics for wholesale distribution operations, including inventory, supply chain, sales, and customer data.

Key Responsibilities

Data Architecture Strategy and Design

• Develop and maintain the enterprise data architecture roadmap aligned with the company’s business goals and IT strategy.
• Design scalable and robust data models to support wholesale distribution systems, including ERP, WMS, and CRM platforms.
• Architect, plan, and implement data mastery strategy and tools.
• Ensure the integration of data sources across the organization, including on-premise and cloud-based systems.

Data Governance and Compliance

• Establish and enforce data governance policies, standards, and best practices to ensure data accuracy, consistency, and security.
• Ensure compliance with relevant regulations and standards (e.g., GDPR, CCPA).
• Implement data quality metrics and monitoring frameworks.

Systems Integration and Optimization

• Collaborate with business units to integrate data from key systems such as ERP, WMS, CRM, and eCommerce platforms.
• Evaluate and implement data warehousing solutions, data lakes, and real-time analytics tools.
• Optimize ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) processes to improve data flow efficiency and reliability.

Collaboration and Leadership

• Work closely with MDM Product Owner, technology, analytics, and business teams to understand data needs and deliver solutions that drive decision-making.
• Provide technical leadership and mentorship to data engineers, developers, and analysts.
• Act as the primary advocate for data-driven decision-making across the organization.

Technology and Tools

• Evaluate, select, and implement modern data technologies and platforms (e.g., Snowflake, AWS/Azure/GCP services, Power BI, Tableau).
• Oversee the design and implementation of APIs and microservices for data sharing.
• Manage the migration of legacy systems to modern data architectures.

Qualifications

Education

• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• Advanced degree (MBA, MSc) is a plus.

Experience

• 8+ years of experience in data architecture, data modeling, and database design.
• Industry experience in wholesale distribution, supply chain, or retail is highly preferred.
• Proven experience with ERP and WMS data integrations (e.g., NetSuite, SAP, Microsoft Dynamics).

Technical Skills

• Proficiency in data modeling tools (e.g., ER/Studio, ERwin, Lucidchart).
• Expertise in database technologies (e.g., SQL Server, Oracle, PostgreSQL).
• Experience with big data frameworks and cloud platforms (e.g., Hadoop, Spark, AWS, Azure, GCP).
• Strong understanding of API integrations and data transformation pipelines.

Soft Skills

• Excellent problem-solving and analytical skills.
• Strong communication and stakeholder management abilities.
• Ability to translate business needs into technical solutions.