Senior Snowflake Architect: Cortex AI & Analytics

Veriipro; Milwaukee (WI); On-site; USD 140,000 - 190,000; Full time

Job summary

Veriipro in Milwaukee is seeking a Senior Snowflake Data Architect to lead enterprise data architecture and analytics initiatives. You will design scalable Snowflake architectures, develop dimensional data models, and onboard enterprise data sources into Snowflake.

You will collaborate with engineers, analysts, and business teams to enable BI on Power BI and Sigma, optimize ELT pipelines, and ensure governance and security.

Qualifications

• 7–10 years of experience in data engineering, data architecture, analytics, or related disciplines.
• 3+ years hands-on experience with Snowflake in enterprise environments.
• Strong expertise in Snowflake architecture, SQL, and cloud data warehousing.
• Relational data warehouse concepts and modern data architecture knowledge.
• 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/analytics platforms such as Power BI or Sigma.
• Understanding of data integration, transformation, data quality, and analytics enablement.
• Strong analytical, problem-solving, communication, and collaboration skills.

Responsibilities

• Serve as a senior technical SME for Snowflake data architecture and enterprise analytics platforms.
• Design scalable and secure Snowflake architectures aligned with enterprise data requirements.
• Lead onboarding and integration of enterprise systems and business domains into Snowflake.
• Design analytics-ready data models, dimensional models, semantic layers, and reusable structures.
• Develop and optimize SQL queries, data transformations, views, and processing workflows.
• Design and support ELT-based data pipelines for ingestion and transformation.
• Enable data consumption and reporting through BI platforms such as Power BI and Sigma.
• Develop semantic views and curated datasets to support analytics and self-service BI.
• Integrate data from enterprise SaaS apps and other operational data sources.
• Evaluate options, identify risks, and communicate trade-offs to senior stakeholders.
• Establish and promote data architecture, modeling, governance, and development standards.
• Collaborate with data engineers, BI developers, platform architects, and application teams.
• Evaluate Snowflake AI capabilities, including Snowflake Cortex, where applicable.
• Contribute to technical documentation, architecture diagrams, data models, standards, and guidelines.

Skills

Snowflake

SQL

Data Modeling

ELT Pipelines

Enterprise Data Architecture

BI Enablement

Data Integration

Cloud Data Warehousing

Snowflake Cortex

Tools

Power BI

Sigma

Job description

Veriipro in Milwaukee is seeking a Senior Snowflake Data Architect to lead enterprise data architecture and analytics initiatives. You will design scalable Snowflake architectures, develop dimensional data models, and onboard enterprise data sources into Snowflake.

You will collaborate with engineers, analysts, and business teams to enable BI on Power BI and Sigma, optimize ELT pipelines, and ensure governance and security.