About this opportunity
PB consulting lists this Snowflake Data Architect – Cortex AI opportunity in West Milwaukee, Wisconsin. Review the employer’s description below for duties, qualifications and application requirements.
Job description
We are seeking a highly experienced Senior Snowflake Data Architect with strong expertise in enterprise data architecture, analytics, data modeling, and modern cloud data platforms. The ideal candidate will have hands-on experience with Snowflake, advanced SQL, dimensional data modeling, ELT pipelines, BI enablement, and enterprise data integration.
Experience with Snowflake Cortex AI and modern AI/ML capabilities within the Snowflake platform is highly desirable. The architect will work closely with technical leaders and engineering teams to design scalable, analytics-ready data solutions and support the onboarding of enterprise data sources and business domains into Snowflake.
Primary Responsibilities
Serve as a senior technical subject matter expert for Snowflake data architecture and enterprise analytics platforms.
Design scalable and secure Snowflake architectures aligned with enterprise data and analytics requirements.
Lead the onboarding and integration of enterprise systems and business domains into Snowflake.
Design analytics-ready data models, dimensional models, semantic layers, and reusable data structures.
Develop and optimize SQL queries, data transformations, views, and data processing workflows.
Design and support ELT-based data pipelines for ingestion and transformation of enterprise data.
Enable data consumption and reporting through BI platforms such as Power BI and Sigma.
Develop semantic views and curated datasets to support analytics, reporting, and self-service BI.
Integrate data from enterprise SaaS applications and other operational data sources.
Evaluate architectural options, identify technical risks, and communicate key trade-offs to senior technical stakeholders.
Establish and promote data architecture, modeling, governance, and development standards.
Collaborate with data engineers, BI developers, platform architects, application teams, and other technical stakeholders.
Evaluate and support emerging Snowflake AI capabilities, including Snowflake Cortex, where applicable.
Contribute to technical documentation, architecture diagrams, data models, standards, and implementation guidelines.
Required Qualifications
7–10 years of experience in data engineering, data architecture, analytics, or related disciplines.
3+ years of hands-on experience working with Snowflake in enterprise environments.
Strong expertise in Snowflake architecture, SQL, and cloud data warehousing.
Strong understanding of relational data warehouse concepts and modern data architecture.
Proven experience designing dimensional data models and semantic data layers.
Experience designing and supporting ELT-based data pipelines.
Experience integrating enterprise applications and SaaS data sources into analytics platforms.
Experience enabling BI and analytics platforms such as Power BI or Sigma.
Strong understanding of data integration, transformation, data quality, and analytics enablement.
Strong analytical, problem-solving, communication, and collaboration skills.
Preferred Qualifications
Hands-on experience with Snowflake Cortex AI and related Snowflake AI/ML capabilities.
Experience with Salesforce Data Cloud / Data 360 and Salesforce data models.
Experience with enterprise-scale Snowflake implementations involving multiple teams and business domains.
Knowledge of modern data governance, data security, and data management practices.
Experience with Snowflake performance optimization and cost management.
Familiarity with modern data engineering and orchestration tools.
SnowPro Core, SnowPro Advanced Architect, or other relevant Snowflake certifications.
Who can apply
Review the original listing for work authorization, qualifications and employer requirements.