Technical Architect (Snowflake)

Overview

Remote
Depends on Experience
Full Time
10% Travel

Skills

Snowflake
Medallion Architecture (Bronze
Silver
Gold)
Schema Design
Role-Based Access Control (RBAC)
DevOps/DataOps Frameworks
Data Ingestion
Data Transformation
Data Orchestration
Fivetran
dbt
Astronomer
Apache Airflow
Naming Conventions
Data Catalog Integration
Metadata Management
Pipeline Modularity
Code Reusability
Performance Optimization
Scalability Planning
Cost Optimization
Healthcare Insurance Domain Knowledge.

Job Details

Technical Architect
Location: Remote (Preference for candidates based in Chicago, IL)

Role Summary:
Design and lead the implementation of Snowflake s Medallion Architecture (Bronze, Silver, Gold) for the RPS migration within the healthcare insurance domain. This role will establish scalable, maintainable patterns for data ingestion, transformation, and certification, ensuring they align with governance, security, and tooling standards. The Technical Architect will provide the technical blueprint that enables engineering teams to deliver high-quality, high-performance data solutions.

Key Responsibilities:

  • Architectural Design: Develop schema models, implement Role-Based Access Control (RBAC), and define DevOps frameworks within Snowflake to support secure and efficient operations.

  • Pipeline Frameworks: Define ingestion, orchestration, and transformation patterns leveraging tools such as Fivetran, dbt, and Astronomer to ensure repeatable and scalable workflows.

  • Standards Compliance: Ensure all structures adhere to established naming conventions and integrate seamlessly with the data catalog for improved discoverability and governance.

  • Best Practices & Guardrails: Establish architectural guardrails that promote pipeline modularity, code reusability, and long-term maintainability.

  • Performance Validation: Review and validate the end-to-end architecture to meet cost efficiency, performance optimization, and scalability requirements.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Blue.Cloud