
Senior Snowflake Data Platform and Artificial Intelligence Architect
Posted 6 hours ago

Posted 6 hours ago
This is a fully remote position, open to applicants in United States.
• 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.
• 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.
• Equal Opportunity Employer.
• Reasonable accommodation support for applicants with disabilities.
• Consideration without regard to protected characteristics.
• Protections for veteran status.
Trax Technologies
Ontrac Solutions
General Dynamics Information Technology
General Dynamics Information Technology
Get handpicked remote jobs straight to your inbox weekly.