Senior Snowflake Data Platform and Artificial Intelligence Architect

Posted 6 hours ago

This is a fully remote position, open to applicants in United States.

📋 Description

• Design and enhance Snowflake architecture encompassing ingestion, medallion layers, transformation, semantic, and consumption patterns.

• Create reusable dimensional models, such as star schemas, fact tables, conformed dimensions, surrogate keys, defined grain, and slowly changing dimension patterns.

• Develop governed semantic views and certified datasets that support consistent measures, business definitions, and relationships across BI, analytics, and AI channels.

• Lead the Snowflake-based dbt development, which includes project structure, model layering, reusable macros, tests, documentation, lineage, incremental models, and deployment standards.

• Integrate dbt workflows with Git-based version control, code review, CI/CD, release management, and collaboration among multiple developers.

• Design and operationalize Snowflake Cortex capabilities, which comprise Cortex Agents, Cortex Analyst, semantic models, search services, natural-language analytics, and agent skills.

• Implement security and governance controls, including RBAC, row-access policies, masking policies, secure views, data classification, and least-privilege access.

• Collaborate with data engineers, analytics teams, AI specialists, security, governance, and business stakeholders to create reusable models, trusted datasets, and Snowflake Cortex capabilities.


⛳️ Requirements

• Over 10 years of experience in data engineering, analytics engineering, data architecture, or AI-enabled data platforms utilizing enterprise data warehouse technologies.

• More than 3 years of experience in designing and implementing Snowflake architecture in production environments, focusing on workload isolation, warehouse sizing, performance tuning, observability, reliability, and cost optimization.

• Over 8 years of experience in creating relational data warehouse models using dimensional modeling, star schemas, semantic layers, and data-quality practices.

• At least 3 years of experience in developing dbt models in Snowflake, covering testing, documentation, lineage, incremental processing, snapshots, SCD patterns, and CI/CD integration.

• Minimum of 2 years of experience in designing secure ELT, ETL, or data-consumption patterns across diverse source systems and user communities.

• At least 1 year of experience with Snowflake Cortex or comparable AI-assisted analytics capabilities grounded in governed enterprise data and Fiserv systems.

• A Bachelor’s degree or higher in Computer Science, Data Engineering, Information Systems, Engineering, or a related field, or an equivalent combination of education, relevant experience, and/or military experience.

• SnowPro Core, SnowPro Advanced Architect, SnowPro Advanced Data Engineer, or an equivalent Snowflake credential.

• dbt Analytics Engineering certification or an equivalent analytics engineering credential.

• Familiarity with Power BI, Sigma, enterprise semantic-model patterns, or AI-enabled analytics platforms.

• Experience working in a large, regulated, multi-team enterprise environment.

• Must reside outside Colorado, California, District of Columbia, Hawaii, Illinois, Massachusetts, Maryland, Minnesota, New Jersey, New York, Nevada, Rhode Island, Vermont, Virginia, Maine, and Washington.


🏝️ Benefits

• Equal Opportunity Employer.

• Reasonable accommodation support for applicants with disabilities.

• Consideration without regard to protected characteristics.

• Protections for veteran status.

People also viewed

Trax Technologies6 hours ago

Data Architect

US flagUnited States OnlyFull-timeData Engineer
ApplyView job
Ontrac Solutions6 hours ago

Staff Data Engineer

US flagUnited States OnlyFreelanceData Engineer
ApplyView job
General Dynamics Information Technology6 hours ago

ICAM Identity Data Management Engineer – Radiant Logic

US flagUnited States OnlyFull-timeData Engineer$170k – $230k/year
ApplyView job
General Dynamics Information Technology6 hours ago

Identity Data Management Engineer – Radiant Logic

US flagUnited States OnlyFull-timeData Engineer$170k – $230k/year
ApplyView job
General Dynamics Information Technology6 hours ago

Senior Data Engineer

US flagUnited States OnlyFull-timeData Engineer$102k – $138k/year
ApplyView job
First Citizens Bank6 hours ago

Data Engineer I

US flagUnited States OnlyFull-timeData Engineer$86.6k – $100k/year
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers