Lead Data Architect (Snowflake)
We are looking for a Principal Data Architect to join one of our top tier investment banking clients in Seattle WA. In this role, you will report to the Head of Data Management and be responsible for the enterprise data architecture, governance, engineering, and analytics enablement across all lines of business. This role will also oversee the design, implementation, and modernization of our enterprise data and analytics architecture in a hybrid environment (on-premises + cloud). The Architect will bridge enterprise technology teams (DevOps, Production Support, Cloud Platform) and domain-aligned teams across multiple business verticals — driving excellence in data modeling, master data management, data warehouse design, and AI/ML-ready architecture patterns.
This is onsite 3-4 days
Salary: $190,000-$200,000k + discretionary bonus
Responsibilities
- Define and maintain the enterprise data architecture roadmap aligned with the firm’s technology strategy and business objectives.
- Develop reference architectures, design patterns, and reusable components for data ingestion, transformation, modeling, and analytics.
- Partner with domain engineering and analytics teams to design fit-for-purpose, interoperable data solutions that align with enterprise standards.
- Lead architectural review sessions and ensure governance alignment across all domains.
- Serve as an advisor to leadership on data strategy, modernization, and investment prioritization.
- Architect and optimize data warehouse and data lakehouse solutions leveraging modern cloud data platforms (Snowflake, Azure/AWS) integrated with on-prem databases.
- Lead enterprise-wide data modeling efforts (conceptual, logical, and physical) to ensure consistency, performance, and scalability across domains.
- Champion the use of canonical models and metadata standards to support semantic alignment and data product reuse.
- Design robust data warehouse architectures that support analytical, regulatory, and operational workloads, with a strong foundation in dimensional modeling and data vault methodologies.
- Collaborate with BI and Analytics teams to define semantic and business layers that enable self-service analytics.
- Integrate data quality, metadata, and lineage frameworks within all architectural designs.
- Partner with governance and stewardship teams to enforce data ownership, classification, and privacy controls.
- Promote the ‘data as a product’ mindset across business domains.
- Lead cloud migration initiatives for legacy data platforms (SQL Server, Oracle, and other on-prem systems) to modern cloud environments.
- Define migration patterns, cut-over strategies, and hybrid data access architectures.
- Partner with infrastructure and DevOps teams to implement CI/CD pipelines, Infrastructure-as-Code, and automated provisioning for data platforms.
- Ensure designs address scalability, security, cost optimization, and resiliency.
Qualifications
- Extensive experience in data architecture, data engineering, or enterprise data solution design.
- 10+ years of experience in SQL and advanced concepts
- Experience with dbt and familiarity with advanced concepts
- Experience designing cloud-based data platforms (Azure preferred).
- Proven expertise in data modeling and Snowflake data warehouse design (3NF, dimensional, Data Vault).
- Hands-on experience with Master Data Management (MDM) strategy and implementation.
- Demonstrated success leading cloud migration projects and designing hybrid architectures.
- Strong proficiency in SQL Server and relational database optimization.
- Knowledge of metadata management, data governance, data quality, and lineage.
- Excellent communication and stakeholder management across technical and business domains.
Lori Sklarski
Senior Technical Recruiter, PRI Technology
Lori.sklarski@pritechnology.com
Direct:(973)-354-2797
Office: 973.732.5454 x27
Cell: 973.432.9968
www.pritechnology.com
www.pritechnology.com