Solutions Architect

Job Description

Role : Data & Solution Architect

Location: Fort Collins (Colorado) Onsite

Contract Position .

Must : Minimum 6 years in data/platform engineering or solution design, including at least 3 years in architecture responsibilities

Education : Bachelor’s degree in Computer Science, Information Systems, Software Engineering, Information Technology, or related engineering discipline. A master’s degree is preferred but not essential.

Technical Required Info

• 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.

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.

Thank you,

Bharath M

Account Manager

Astir IT Solutions, Inc - An E-Verified Company

Email: View email address on ziprecruiter.com

Direct : View phone number on ziprecruiter.com*806

50 Cragwood Rd. Suite # 219, South Plainfield, NJ 07080