Cloud Data Architect: Snowflake, Fivetran & AI-Ready DW

Alto-Shaam, Inc.

Menomonee Falls (WI)

On-site

USD 120,000 - 180,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Alto-Shaam, Inc. is seeking a Data Architect to own and scale a cloud data platform (Snowflake, Fivetran, dbt). You will design data models, secure data access, and lead ingestion from Oracle Fusion Cloud and other sources. The role includes enabling analytics, dashboards, and AI-ready data for multiple business domains.

You will drive data quality, governance and migration of historical data, while partnering with integration teams to shape future MES and manufacturing data strategies.

Qualifications

  • 5–8 years in data engineering, analytics engineering or similar.
  • Experience owning the design of a production data warehouse across 3+ source systems.
  • Expert SQL and strong Python; hands-on dimensional modeling in production.
  • Production experience on a cloud data platform (Snowflake/Databricks/Fabric/BigQuery) and ELT tools (Fivetran/dbt).
  • Experience with version control, CI/CD and automated data testing.
  • Oracle Fusion Cloud data experience or deep ERP data modeling preferred.
  • Manufacturing/MES data familiarity; cloud services and data for AI/LLM desirable.
  • Strong communication skills to explain trade-offs to non-technical leaders.

Responsibilities

  • Designs and builds the platform's data model, including dimensional models and conformed dimensions.
  • Owns ingestion from Oracle Fusion Cloud, CRM, and connected-equipment data; monitors pipelines.
  • Implements role-based access, CI/CD, and data security; manages environments and costs.
  • Establishes data quality, governance, contracts and automated testing; lineage and master data.
  • Extends the semantic layer that dashboards and AI tools query directly.
  • Leads historical data migration and documents legacy rules and lineage.
  • Collaborates with integration teams on data movement between systems and future apps.
  • Mentors part-time data staff and defines onboarding materials.

Skills

SQL
Python
Dimensional modeling
Cloud data platforms
ETL/ELT
dbt
CI/CD
Data governance
Communication

Education

Bachelor's degree in Computer Science, Information Systems, Engineering or related

Tools

Snowflake
Databricks
Fabric
BigQuery
Oracle Fusion Cloud

Job description

Alto-Shaam, Inc. is seeking a Data Architect to own and scale a cloud data platform (Snowflake, Fivetran, dbt). You will design data models, secure data access, and lead ingestion from Oracle Fusion Cloud and other sources. The role includes enabling analytics, dashboards, and AI-ready data for multiple business domains.

You will drive data quality, governance and migration of historical data, while partnering with integration teams to shape future MES and manufacturing data strategies.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Cloud Data Architect — Snowflake & AI-ready Platform
Cloud Data Architect — Snowflake & AI-ready Platform

Alto Shaam • Menomonee Falls (WI)

On-site
USD 120,000 - 180,000
Data Architect
Data Architect

Alto-Shaam, Inc. • Menomonee Falls (WI)

On-site
USD 120,000 - 180,000
Senior Data Platform Architect — Snowflake, dbt & Tableau
Senior Data Platform Architect — Snowflake, dbt & Tableau

110 USA Wind River • Walnut Creek (CA)

On-site
USD 176,000 - 210,000
Healthcare and life insurance
401(k) plan eligibility
12 paid holidays
+1
Data Architect
Data Architect

Alto-Shaam • Menomonee Falls (WI)

On-site
USD 120,000 - 180,000
Senior Data Platform Architect — Snowflake, dbt & Tableau
Senior Data Platform Architect — Snowflake, dbt & Tableau

Aptiv • California

On-site
USD 176,000 - 210,000
Comprehensive benefits package
401(k) plan eligibility
12 paid holidays
+1
Cloud Data Architect: Snowflake, AWS & Lakehouse
Cloud Data Architect: Snowflake, AWS & Lakehouse

Intellectt Inc • Union Beach (NJ)

On-site
USD 120,000 - 150,000
Senior Data Architect: Snowflake & AI-Ready Data Platform
Senior Data Architect: Snowflake & AI-Ready Data Platform

Royal Cyber • United States

Remote
USD 22,000 - 37,000
Snowflake Data Architect — AI-Ready Enterprise Platforms
Snowflake Data Architect — AI-Ready Enterprise Platforms

BlueCloud • United States

On-site
USD 150,000 - 230,000
Senior Data Architect - Remote | Snowflake & AI Readiness
Senior Data Architect - Remote | Snowflake & AI Readiness

LG Energy Solution Vertech, Inc. • Westborough (MA)

Remote
USD 150,000 - 210,000
100% employer sponsored medical,Dental
Vision insurance
Life and disability insurance
Cloud Data Architect for Analytics & AI
Cloud Data Architect for Analytics & AI

Aligned Data Centers, LLC • Texas

Hybrid
USD 120,000 - 180,000
Health insurance
401(k) plan with company match
Paid time off and holidays
+1