Quick overview
Job description
Hi Professionals,
Greetings from Vegaintellisoft
Role : Data Solution Architect
Location : Fort Collins, CO (Onsite)
Duration : Contract
Experience : 12+ years needed
Position overview
We seek an experienced Data & Solution Architect to work alongside existing architecture leadership and assess enterprise data, integration and decisioning capabilities across the four Data Strategy pillars. The Architect will validate existing architecture, identify shared dependencies and target-state options, and produce implementation-ready architecture recommendations grounded in technical evidence, current assets and operational constraints.
Key responsibilities
- Assess the existing Snowflake-centered data platform, ingestion and transformation paths, customer/partner identity, data products, operational interfaces and reporting consumption.
- Document current-state architecture and target-state options with context diagrams, source-to-consumption flows, integration inventory, nonfunctional requirements and interface contracts.
- Evaluate source-faithful acquisition, raw/curated layer separation, data classification, permitted-use metadata, data governance, lineage and retention requirements.
- Evaluate customer/entity resolution, master data patterns, cross-system identifiers, match confidence and controlled exception management.
- Assess batch versus event-driven integration, APIs, orchestration, observability, error handling, reconciliation, availability and recovery requirements.
- Identify dependencies and reusable services for partner activation, customer value, enterprise intelligence and governed AI applications.
- Coordinate architecture review with onsite Data Architect, security and business stakeholders; document trade-offs, ownership and decisions.
- Guide feasibility and effort considerations for execution plans without assuming that a specific new platform or vendor must be purchased.
Required technical competencies
- Snowflake: practical architecture knowledge of warehouses, data layers, secure sharing, transformations, access patterns and performance fundamentals.
- SQL and data modeling: strong SQL literacy; relational and analytical models; dimensional design, data contracts and enterprise entity models.
- Data integration: ETL/ELT, batch processing, REST APIs, JSON, orchestration, CDC concepts and event-driven integration patterns.
- Cloud solution architecture: security boundaries, IAM/access controls, encryption, monitoring, resilience, cost/performance trade-offs and integration with enterprise applications.
- Enterprise information architecture: master data/identity, catalog, metadata, data quality, lineage, source provenance, permissions and retention.
- BI and data products: Tableau or equivalent consumption/semantic -layer architecture, certified metrics, data products, trusted services and interoperability.
- Architecture deliverables: C4/solution context diagrams or equivalent, sequence/data-flow diagrams, design decision records and nonfunctional requirements.
Preferred experience and technologies
- Snowflake certification or comparable cloud data platform certification; substantial hands-on warehouse architecture experience.
- Experience with dbt, Airflow, Fivetran, Informatica, Kafka or analogous ingestion/orchestration/event technologies (examples only; no single product is mandatory).
- Salesforce integrations, enterprise payment ecosystems, receivables reconciliation, payment rails or regulated financial-services architecture
- Experience designing shared data/AI services, event observability, disaster recovery, API/data contracts or privacy-by-design architectures.
Expected deliverables
- Validated current-state and target-state architecture diagrams, system/interface inventories and nonfunctional requirements.
- Data lineage, identity, integration and technical-dependency map for prioritized workstreams.
- Architecture options, risks, trade-offs, decision log, technical acceptance criteria and implementation-readiness recommendations.
Similar jobs
- PO

Solutions EngineerRecently posted Auto Apply
Pointone · New York City · On-site · Posted 16 Nov 2026 🇺🇸
Customer SuccessTechnology$112k - $155k/yr - AW

Delivery Consultant - Application Architecture, WWPS ProServeRecently posted
Amazon Web Services, Inc. · Herndon, Virginia · Hybrid 🇺🇸
AWSGDPRHIPAA+1Technology$131.6k/yr - VI
Senior Cloud Solutions Architect - AI Agentic & Integration ArchitectureRecently posted
Visionaryz Inc. · New York · Hybrid · Posted 16 Nov 2026 🇺🇸
AWSLLMAzure+1TechnologySalary not listed - TR

NetSuite Solution Architect (Senior Manager)Recently posted
Tenth Revolution Group · Mundelein, Illinois · Hybrid · Posted 16 Nov 2026 🇺🇸
JiraAgileAsanaTechnologySalary not listed - TT
Solutions EngineerRecently posted Auto Apply
True Talent Solutions Partners · San Francisco · On-site · Posted 15 Nov 2026 🇺🇸
PythonMachine LearningTechnology$120k - $150k/yr - TW

Principal Solutions EngineerRecently posted Auto Apply
Twingate · Remote · Remote · Posted 9 Nov 2026 🇺🇸
OnboardingGoogle WorkspaceBash+11Technology$215k - $260k/yr - WI

Senior/Staff Forward Deployed Architect Auto Apply
Within.ai · San Francisco (HQ) · On-site · Posted 20 Oct 2026 🇺🇸
Customer SuccessProcurementServiceNow+2Salary not listed - VB

D365 F&O Techno-Functional Solution ArchitectRecently posted
VBeyond Corporation · West Palm Beach, Florida · On-site · Posted 16 Nov 2026 🇺🇸
AzureTechnologySalary not listed - DS
Agentic AI -Solution Architect (FDE)Recently posted
Delta System & Software, Inc. · Berkeley Heights, New Jersey · On-site · Posted 16 Nov 2026 🇺🇸
MicroservicesGitSelenium+5TechnologySalary not listed - FS
Solution Architect - Retail Applications & Digital SolutionsRecently posted
Falcon Smart IT (FalconSmartIT) · Niles, Illinois · On-site · Posted 16 Nov 2026 🇺🇸
SQLAngularC#+5TechnologySalary not listed - CO
SAP SuccessFactors Employee Central (EC) Solution ArchitectRecently posted
Connexions · Center Valley, Pennsylvania · Hybrid · Posted 16 Nov 2026 🇺🇸
TechnologySalary not listed - ME
Stibo STEP MDM Solution ArchitectRecently posted
MethodHub · Chicago, Illinois · Hybrid · Posted 16 Nov 2026 🇺🇸
KafkaRESTRAGTechnologySalary not listed