Snowflake Platform Architect & Senior Analytics Engineer

Crisis Prevention Institute; United States; Hybrid; USD 180,000 - 240,000; Full time

Benefits offered by this job

Comprehensive compensation package

Comprehensive benefits package

401k

PTO

Health & Wellness Days

Paid Volunteer Time Off

Continuing education and training

Hybrid / Remote work schedule

Paid Parental Leave

Job summary

Crisis Prevention Institute is seeking a Principal Analytics Engineer to serve as the senior data platform owner for the enterprise Snowflake environment. You will drive architecture, security, and governance across ingestion, transformation, and data-serving patterns while enabling AI-enabled analytics and scalable data access for stakeholders.

You will partner with security, analytics, BI, and business teams to design and implement reliable, cost-effective data solutions.

Qualifications

• Bachelor's degree in a related field.
• 10+ years of progressive experience in data/analytics engineering or cloud data architecture.
• Extensive hands-on experience architecting, administering, securing, and operating Snowflake in an enterprise environment.
• Experience designing and owning production ingestion, transformation, orchestration, and data-serving patterns across a modern cloud data stack.
• Proven senior technical authority, reviewing architecture, mentoring engineers, and leading complex platform issues.
• Experience partnering with security, infrastructure, applications, analytics, AI, and business teams to deliver secure, governed enterprise data capabilities.
• Expert-level Snowflake knowledge spanning warehouses, data sharing, security, monitoring, and governance.
• Expert SQL and data modeling, ingestion, orchestration, testing, observability, version control, and release automation.
• Understanding of enterprise security, governance patterns, least privilege, auditing, privacy, and data lifecycle management.
• Strong knowledge of AI-enabled data architectures, including MCP configurations and governed data access.

Responsibilities

• Design and govern the enterprise Snowflake platform and its data ecosystem.
• Oversee ingestion, transformation, orchestration, and data-serving patterns across Snowflake, Fivetran, and Power BI.
• Set platform standards for performance, reliability, observability, testing, DR, and cost optimization.
• Implement Snowflake security, including RBAC, network policies, data protection, auditing, and secure data sharing with InfoSec.
• Act as senior architecture authority, review major designs, and ensure alignment with enterprise goals.
• Enable AI use cases with MCP configurations, access controls, and pattern guidance for agents and tools.
• Establish reusable engineering patterns and reference architectures to improve quality and delivery.
• Collaborate with analytics engineers, BI, AI, applications, infra, security, and business partners to deliver trusted capabilities.
• Diagnose and resolve complex production, performance, integration, and security issues; lead root-cause analysis.
• Provide deep technical mentorship without people management responsibilities.
• Define and monitor platform health, adoption, SLAs, cost, and roadmap.

Skills

Snowflake

Data engineering

Cloud data architecture

Security & governance

AI enablement patterns

Stakeholder management

Mentorship

SQL

Data modeling

Observability

Communication

Architecture review

Education

Bachelor's Degree

Tools

Snowflake

Fivetran

Power BI

CI/CD

Job description

Crisis Prevention Institute is seeking a Principal Analytics Engineer to serve as the senior data platform owner for the enterprise Snowflake environment. You will drive architecture, security, and governance across ingestion, transformation, and data-serving patterns while enabling AI-enabled analytics and scalable data access for stakeholders.

You will partner with security, analytics, BI, and business teams to design and implement reliable, cost-effective data solutions.