Senior Data Architect

We are seeking an experiencedData Warehouse Architectto design, build, and evolve our enterprise data platform. This role is central to unifying data across our organization's critical business domains including Order to Cash (O2C), Procure to Pay (P2P), and Finance Record to Report (R2R) — into a scalable, governed, and performant data warehouse. The ideal candidate brings deep expertise in enterprise data modeling, modern cloud data platforms, and hands-on experience integrating data from both large-scale ERP systems and niche industry platforms.

Key Responsibilities

Data Architecture & Modeling

• Design and own enterprise-grade dimensional and relational data models across core business domains:Order to Cash (O2C),Procure to Pay (P2P), andFinance Record to Report (R2R)
• Develop and maintain conceptual, logical, and physical data models aligned to business process frameworks (e.g., APQC, SAP reference models)
• Establish and enforce data modeling standards, naming conventions, and architectural best practices across the organization
• Define and manage data domains, subject areas, and data products to support self-service analytics and enterprise reporting

Data Pipeline & Integration

• Architect and oversee end-to-end data pipelines — ingestion, transformation, orchestration, and delivery — for batch and near-real-time workloads
• Lead the integration of structured and semi-structured data from ERP and operational systems into the data warehouse
• Evaluate, select, and implement ETL/ELT tools and frameworks appropriate to the platform stack
• Ensure pipeline reliability, observability, and scalability through monitoring, alerting, and automated testing practices

Cloud Platform Engineering

• Architect and manage cloud-based data warehouse environments onMicrosoft Fabricand/orAWS(Redshift, Glue, S3, Lake Formation, or equivalent)
• Design lakehouse and medallion architectures (Bronze / Silver / Gold) where appropriate
• Optimize platform performance, cost, and security in alignment with enterprise cloud governance standards

ERP & Source System Integration

• Lead data extraction and mapping from enterprise ERP platforms, likeSAPincluding complex financial, procurement, and sales modules
• Integrate data from niche and industry-specific ERP platforms includingClipboard K8andStone Profit System
• Collaborate with ERP functional teams to understand business processes, data flows, and source-system data quality characteristics
• Document source-to-target mappings and maintain data lineage across all integrated systems

Governance & Quality

• Define and implement data governance frameworks, including data ownership, stewardship, and quality rules across integrated domains
• Partner with data governance and compliance teams to ensure data accuracy, completeness, and auditability — especially for financial reporting (R2R)
• Implement and maintain master data management (MDM) principles for key entities such as customers, vendors, and chart of accounts

Leadership & Collaboration

• Serve as the technical lead and subject matter expert for all data warehouse and data modeling initiatives
• Mentor and guide data engineers and analysts on architecture standards and best practices
• Partner with business stakeholders across Finance, Supply Chain, and Operations to translate requirements into scalable data solutions
• Engage with vendors, consultants, and third-party data providers as needed

Required Qualifications

• Progressive experience in data warehousing, data architecture, or data engineering roles
• Proven expertise designing enterprise data models forOrder to Cash,Procure to Pay, and/orFinance Record to Reportbusiness domains
• Strong proficiency inSQLand experience with dimensional modeling (Kimball, Inmon) and modern data vault methodologies
• Hands-on experience building and managingdata pipelinesusing tools such as dbt, Azure Data Factory, AWS Glue, Apache Airflow, or similar
• Demonstrated experience with cloud data platforms —Microsoft Fabricand/orAWS(Redshift, S3, Glue, Athena, etc.)
• Meaningful experience integrating data fromSAPincluding financial, logistics, and procurement modules
• Solid understanding of data governance, data quality frameworks, and metadata management