Snowflake Architect

Aqua Finance, Inc.

Aqua Finance seeking a skilled Snowflake Architect to lead data platform design and implementation. Collaborating on solutions for business intelligence, analytics, and AI-driven initiatives.

Posted 6/26/2026full-timeRemote • Illinois, Minnesota, North Carolina • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

CloudETLInformaticaMatillionPythonSQL

About the role

Key responsibilities & impact

Lead the design, implementation, optimization, and governance of enterprise data platform
Ensure scalable, secure, and high-performing data solutions supporting business intelligence, reporting, analytics, data science, and AI-driven initiatives
Design, implement, and optimize high-performance data architectures on the Snowflake cloud data platform
Develop robust logical and physical data models, optimizing query performance and resource utilization
Design, build, and optimize scalable data ingestion and transformation pipelines utilizing Snowpipe, dbt, Matillion, Informatica, or similar technologies
Manage key Snowflake administration tasks, including user/role management, role-based access controls (RBAC), network policies, disaster recovery through account replication, and deployment pipelines
Optimize Snowflake performance through virtual warehouse sizing, query tuning, clustering keys, materialized views, resource monitors, Tasks, Time Travel, Zero-Copy Cloning, and Secure Data Sharing
Maintain comprehensive architecture documentation, data flow diagrams, and data lineage to support SOC2 compliance, governance standards, and audit requirements
Leverage Snowflake Cortex Analyst, Snowpark, and other advanced Snowflake capabilities to enable AI-driven analytics, self-service insights, and advanced use cases
Collaborate with Business Intelligence, Reporting, Data Science, and Engineering teams to develop scalable, secure, and cost-effective data solutions
Provide technical leadership, mentor team members, establish best practices, lead proof-of-concept initiatives, and support enterprise data strategy and architecture decisions
Monitor and optimize Snowflake workloads and spending to ensure efficient resource utilization and predictable costs

Requirements

What you’ll need

Bachelor's degree in Information Technology, Computer Science, Business, Data Analytics, or a related field, or commensurate work experience required
5 years of experience in Data Warehousing, Data Engineering, ETL/ELT, or Business Intelligence
3 years of hands-on experience designing, implementing, and administering Snowflake solutions
Strong knowledge of Snowflake architecture, performance optimization, security, governance, and disaster recovery best practices
Experience designing scalable data models and cloud-native data solutions
Experience with data integration and transformation tools such as dbt, Matillion, Informatica, or similar platforms
Experience integrating Snowflake with cloud storage platforms and BI/reporting tools
Advanced SQL skills and working knowledge of Python preferred
Knowledge of SOC2 compliance, data governance, and data architecture documentation practices
Snowflake SnowPro Advanced Administrator and/or Architect certifications preferred
Financial services industry experience preferred
Strong analytical, problem-solving, communication, and project leadership skills
Ability to thrive in a fast-paced environment with strong attention to detail.

Benefits

Comp & perks

Flexible and consumer-friendly financing programs
Commitment to employee success
Celebration of individual contributions

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data architecturedata modelingETLELTSQLPythondata ingestiondata transformationperformance optimizationdisaster recovery

Soft Skills

analytical skillsproblem-solvingcommunicationproject leadershipattention to detail

Certifications

Snowflake SnowPro Advanced AdministratorSnowflake SnowPro Advanced Architect