> Markdown version of [/jobs/ext/3080856-solution-architect](https://www.wearedevelopers.com/jobs/ext/3080856-solution-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Solution Architect

- **Company:** MILLENNIUM SOFTWARE SOLUTIONS
- **Location:** United States (Remote available)
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, ARM Architecture, Continuous Integration, Data Governance, Data Warehousing, Python (Programming Language), Power BI, Oracle Fusion Middleware, Data Streaming, Delivery Pipeline, Snowflake, Sap Business Objects, Workday
- **Published:** September 25, 2026
- **Apply:** https://www.dice.com/job-detail/1437a4e5-ff1b-49ed-978d-8a0554e1bbdd

## About the Role

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.

## Description

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/CDintegrates 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 CDcannot 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.


## Related Videos

- [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Destigmatizing the Workplace: Building Real Inclusion](https://www.wearedevelopers.com/videos/1492-destigmatizing-the-workplace-building-real-inclusion)
- [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)
- [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers)
- [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift)