What are the responsibilities and job description for the Snowflake Data Architect position at United Software Group Inc?
Job Title: Snowflake Data Architect
Location : Remote - Occasional travel to Sailsbury, Maryland
Duration : 6 Months Contract with Possible Extension
Teams Meeting Interview
Job Description:
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.