Snowflake Data Architect I
Location - Remote - Occasional travel to Salisbury, Maryland
Duration: 6 to 12 months
Primary skill - Dataiku, data architecture (ECC to S/4HANA alignment) Strong SQL
Solution and pipeline architecture for the Snowflake foundation and the Dataiku transformation layer
Dimensional modelling strategy across the ~15 reusable data products, and metadata-driven design of transformation services
Historical data architecture (ECC to S/4HANA alignment)
Technical governance, design reviews, standards enforcement and code-review governance for the engineering squad
Support and mentoring to delivery squads, and Perdue stakeholder discussions
Strong experience with Snowflake architecture and Dataiku DSS platform design, across data warehousing and modern data platform patterns
Design of scalable facts, dimensions and reusable domain-aligned data products, and of Dataiku transformation flows across the Prepared and Consumed layers on Snowflake
Define data models, transformation patterns, dataset standards and semantic structures; establish automation frameworks, reusable components and AI-assisted (Copilot) engineering patterns
Strong SQL and Python; performance tuning, RBAC, cost optimization, scheduling and orchestration
Understanding of SAP BW, Essbase and reporting transformation concepts.