Our client is seeking a Senior Data Architect to enhance and evolve its enterprise analytics platform by integrating new data sources, designing scalable Snowflake data warehouse solutions, and translating business requirements into technical solutions.

This individual will serve as the bridge between business stakeholders and development teams, ensuring enterprise data architectures support reporting, analytics, and strategic decision-making.

The ideal candidate combines deep expertise in Snowflake data warehousing, enterprise data modeling, cloud analytics platforms, ERP integrations, and business-facing requirements gathering.

---

Key Responsibilities

Data Architecture & Modeling

• Design, enhance, and optimize enterprise Snowflake data warehouse architectures.
• Develop scalable dimensional models utilizing star and snowflake schemas.
• Define semantic data layers that enable trusted reporting and self-service analytics.
• Create and maintain logical and physical data models, source-to-target mappings, and data dictionaries.
• Establish standards for metadata management, naming conventions, and data governance.

---

Data Integration & Engineering

• Design and oversee ELT/ETL pipelines utilizing:
  • Snowflake
  • dbt
  • Matillion
  • Fivetran
• Integrate data from complex enterprise applications including:
  • Oracle EBS
  • SAP
  • Salesforce
  • Other enterprise systems
• Design scalable ingestion patterns using APIs, cloud storage, and modern integration frameworks.
• Ensure data quality, consistency, scalability, and performance across the enterprise analytics platform.

---

Azure Cloud & Enterprise Analytics

Architect solutions utilizing:

• Snowflake
• Azure Data Lake
• Azure Synapse Analytics
• Microsoft Fabric
• Azure SQL
• Power BI
• Fivetran

Develop best practices for cloud analytics architecture, security, scalability, and performance optimization.

---

Required Qualifications

10+ years of experience in enterprise data architecture and analytics.

Required Technical Expertise

Strong expertise in:

• Snowflake Data Warehousing (Required)
• dbt
• Matillion
• Fivetran
• Power BI
• Advanced SQL
• Azure Data Platform

---

Deep experience with:

• Enterprise data warehouse architecture
• Dimensional modeling
• Star and snowflake schema design
• Semantic layer development
• Data governance
• Metadata management

---

ERP Integration Experience

Hands-on experience integrating enterprise data from:

• Oracle EBS (highly preferred)
• SAP
• Salesforce
• Other enterprise applications

---

Success Profile

The ideal candidate is:

• A Snowflake data warehouse expert capable of enhancing mature enterprise analytics environments.
• Comfortable translating business requirements into scalable technical architecture.
• Experienced integrating Oracle EBS and other ERP platforms into enterprise data warehouses.
• Equally effective collaborating with executives, business stakeholders, and technical engineering teams.
• Able to drive architectural direction while remaining hands-on with solution design and implementation.
• Focused on enabling enterprise analytics, trusted reporting, and self-service BI.