Senior Snowflake Architect (Remote)

Jobright is an AI-powered career platform that helps job seekers discover the top opportunities in the US. We are NOT a staffing agency. Jobright does not hire directly for these positions. We connect you with verified openings from employers you can trust. Job Summary: Adastra Corporation is an international consulting company focused on data and analytic solutions. They are seeking an experienced Snowflake Architect to lead the design and governance of their Snowflake data platform, collaborating with various teams to optimize platform usage and align with organizational goals. Responsibilities:

• Define the overall architecture of Snowflake environments, including account structure, multi-cluster warehouses, data zones, and data sharing strategies.
• Develop platform standards and governance policies for databases, schemas, roles, and compute resource allocation.
• Lead capacity planning, cost optimization, and usage monitoring initiatives across all Snowflake environments.
• Establish security models including role-based access control (RBAC), row-level security (RLS), and column-level security (CLS), ensuring alignment with governance and compliance requirements.
• Guide the implementation of scalable DBT-based data transformation pipelines following modular, testable, and reusable patterns.
• Architect dimensional models (star and snowflake schemas) to support enterprise BI, semantic layers, and data products.
• Define standards for DBT project organization, testing coverage, naming conventions, and performance optimization.
• Provide architectural guidance for large-scale SQL query design, clustering strategies, and caching mechanisms.
• Partner with engineering teams to design compute-optimized solutions using workload-aware warehouse sizing and scheduling.
• Lead initiatives to monitor and optimize platform performance, query execution plans, and storage utilization.
• Collaborate with data governance teams to align architecture with metadata management, lineage tracking, and data quality frameworks.
• Design solutions that incorporate automated testing, validation, and anomaly detection using tools like DBT, Great Expectations, or custom frameworks.
• Ensure adherence to organizational standards for documentation, data stewardship, and access controls.
• Define best practices for exposing curated data models and semantic layers to BI platforms (e.g., Power BI).
• Support scalable data access strategies through optimized views, data marts, and materialized outputs.
• Provide architectural support for Power BI models, including DirectQuery, Import, and hybrid configurations.
• Serve as a technical advisor to data engineers, analysts, and business units on best practices and architectural decisions.
• Document data architecture, lineage, security design, and platform configurations for transparency and supportability.
• Lead design reviews, POCs, and architectural assessments for new data initiatives.

Qualifications: Required:

• 5+ years of experience architecting solutions on the Snowflake Data Cloud.
• Deep understanding of Snowflake account structure, compute management, cost optimization, and security.
• Expertise in dimensional modeling, DBT architecture, and ELT best practices.
• Strong command of SQL performance tuning, warehouse scaling, and data transformation strategies.
• Experience working with BI tools (especially Power BI) and their integration with Snowflake.
• Familiarity with modern data governance, metadata management, and data quality frameworks.
• Proven ability to collaborate with cross-functional teams and communicate technical concepts clearly.

Preferred:

• Experience with Snowflake Cortex, Snowpipe, and native integrations with third-party tools.
• Working knowledge of DevOps practices, CI/CD pipelines, and version control in DBT environments.
• Familiarity with enterprise data catalogs, data lineage tools, and policy-driven governance platforms.
• Prior experience in designing hybrid cloud or multi-region Snowflake architectures.

Company: Adastra provides smart Artificial Intelligence, Big Data, Cloud, Digital and Governance services & solutions. It is a sub-organization of Ataccama. Founded in 2000, the company is headquartered in Toronto, Ontario, CAN, with a team of 1001-5000 employees. The company is currently Late Stage. Apply tot his job Apply To this Job