Snowflake Solution Architect

Millennium Software and Staffing Inc; United States; Remote; USD 140,000 - 210,000; Full time

Job summary

Millennium Software and Staffing Inc is seeking a Snowflake Solution Architect for a remote role to own the end-to-end design of the EDW platform, translating Workday-to-Snowflake reporting needs into a scalable architecture for self-service analytics and production readiness.

The role defines data flows across RAW, REFINED, and CURATED layers, sets standards for Python-based ingestion, dbt modeling, and integration with Informatica IDMC/CDGC, Power BI, and SAP BusinessObjects, while enforcing

Qualifications

• Experience designing cloud data warehouses on Snowflake.
• Ability to make and defend architecture decisions.
• Knowledge of Informatica IDMC/CDGC tooling.

Responsibilities

• Own end-to-end technical design of the OneWA EDW platform and translate requirements into architecture.
• Define data flow across RAW, REFINED, and CURATED pipelines and establish ingestion standards.
• Design integration of Informatica IDMC/CDGC with Snowflake, Python/dbt, and BI tools.
• Define non-functional requirements for performance, scalability, monitoring, and recovery.
• Support multiple workstreams and collaborate with the Technical Lead, Data Governance Lead, and Delivery team.

Skills

Cloud data warehouse architecture

Data governance

Architecture decision making

Stakeholder collaboration

Tools

Snowflake

Informatica IDMC/CDGC

dbt

Power BI

Workday API

Job description

We require a Snowflake Solution Architect to work on remote basis.

Role Title: Solution Architect

Job Responsibilities:

• -The Solution Architect owns the end-to‑end technical design of the OneWA EDW platform, translating OFM's Workday-to-Snowflake reporting requirements into an architecture that supports self-service analytics and production go-live readiness.
• -Defines the overall data flow across the RAW ? REFINED ? CURATED pipeline,
• -Sets the architectural standards for Python-based Workday API ingestion (including CDC and incremental loading),
• -Establishes the dbt modeling approach across functional schemas (accounting, assets, budget, customers, FDM, payments, suppliers).
• -Designs how Informatica IDMC/CDGC integrates with Workday, Snowflake, Python/dbt, and Power BI/SAP BusinessObjects to support the Inventory ? Control ? Deliver ?
• -Observe governance maturity model, and defines the approach for capturing lineage on custom Python pipelines that CDGC cannot auto-discover.
• -Architects the PII masking approach and sets technical guardrails for DEV/QA/Pre-PROD/PROD environment design, working closely with the EDW CI/CD Engineer to ensure deployment pipelines and promotion paths are built to the intended architecture rather than dictating pipeline mechanics directly.
• -Supports all workstreams rather than a single track, partnering with the Technical Lead, Data Governance Lead, and Delivery team.
• -Defines non-functional requirements — performance, scalability, monitoring/alerting, and recovery/rollback design — that feed the Production Go-Live readiness milestone, and evaluates where AI-enabled capabilities (e.g., Snowflake Cortex AI for natural-language querying over the CURATED layer, automated anomaly detection during reconciliation testing) can be layered in without added infrastructure.

Required Skills and Experience:

Strong experience architecting cloud data warehouse solutions on Snowflake and enterprise data governance tooling (Informatica IDMC/CDGC) is required, along with the ability to make and defend architecture decisions.