Overview
Skills
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.