Snowflake Data Architect
MethodHub
Any Independent W2 contractors are fine, they must be okay for relocation from day one (if non-locals)
Lead Data Architect (Snowflake Optimization)
Location: 6 months with possibility of extension
Duration: Portland, OR (Hybrid 3 days)
Role Summary
The Senior Snowflake Optimization Engineer will lead the assessment, re‑architecture, and optimization of the Snowflake data platform. This role will act as the technical lead and primary onsite interface for Snowflake optimization initiatives, working closely with stakeholders, data engineering teams, and Matillion pipelines.
Key Responsibilities
Snowflake Cost & Performance Optimization
- Assess current Snowflake warehouse usage, sizing, auto‑scaling, and auto‑suspend configurations.
- Identify cost drivers across Matillion jobs, ad‑hoc analytics, and background workloads.
- Optimize warehouse strategies (multi‑cluster usage, workload isolation, resource monitors).
- Analyze query history and execution plans to reduce compute inefficiencies.
- Review existing Snowflake schemas, tables, tasks, and pipelines for architectural improvements.
- Recommend and implement Snowflake‑native optimizations (dynamic tables, tasks, result caching where appropriate).
- Evaluate opportunities for hybrid compute (external tables, Iceberg, Spark/EMR) where cost‑effective.
- Advise on data lifecycle, retention, and archival strategies to reduce storage footprint.
Matillion & Pipeline Optimization
- Improve pipeline execution efficiency and runtime SLAs.
- Define reusable optimization patterns and templates.
Governance & Cost Control
- Help establish cost governance, monitoring, and guardrails.
- Provide recommendations to ensure savings are sustainable post‑engagement.
Stakeholder & Delivery Leadership
- Act as the onsite technical lead, coordinating with architects, developers, and business users.
- Lead technical workshops, optimization reviews, and recommendations walkthroughs.
- Provide documentation, implementation guidelines, and knowledge transfer to teams.
- Support stabilization and post‑implementation tuning.
Required Skills & Experience
Technical Skills
- Strong hands‑on experience with Snowflake architecture, performance tuning, and cost optimization
- Deep understanding of:
- Snowflake warehouses, clustering, caching, tasks, dynamic tables
- Query profiling and execution plans
- Experience with Matillion ELT on Snowflake
- Solid knowledge of AWS (S3, security, cost considerations)
- SQL performance tuning and data modeling experience
Good to Have
- Experience with Iceberg / external tables / Spark or EMR
- Exposure to Snowflake Cortex or advanced Snowflake features
- CI/CD for data platforms (GitHub/GitLab/Jenkins)
- Data governance and cost management frameworks
Experience Level
- 8–12+ years in data engineering / cloud data platforms
- 3–5+ years of focused Snowflake optimization experience
- Prior experience in onsite consulting or lead roles preferred
Requirements added by the job poster
- 5+ years of work experience with Amazon Web Services (AWS)
- 5+ years of work experience with Snowflake
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Snowflake Data Architect in Portland, OR vacancy
- ...Position Title: Data Architect – Snowflake Optimization Location: Portland, OR ( Remote) Duration: 6 Months with possibility of extension Role Summary The Data Architect – Snowflake Optimization will lead the assessment, architecture modernization, and optimization...SuggestedRemote work
Xoriant
Portland, OR2 days ago $115k - $135k
...A leading tech consulting firm is seeking a Principal Consultant specializing in AWS and Snowflake to design scalable data solutions. The role involves building frameworks for analytics products, collaborating with stakeholders, and ensuring data quality. Candidates should...SuggestedFull timeStaffworthy
Beaverton, OR2 days ago- ...Xoriant US Staffing is seeking a Data Architect – Snowflake Optimization to lead the modernization and optimization of Snowflake data platform in Portland, OR, with remote work options available. This role involves enhancing performance and cost efficiency through strong...SuggestedRemote work
Xoriant
Portland, OR2 days ago - ...Job Title: Data Architect (Data Platform) As a Data Architect for healthcare applications, you are responsible for innovating, designing... ...vs. denormalization, dimensional modeling (star/snowflake schemas), and designing for scalability and performance. Database...SuggestedContract work
RevSpring
Portland, OR2 days ago $136.9k - $269.15k
...breakthroughs and cultural achievements. We are looking for a Data Architect to join our Corporate Planning Group Data and Analytics team,... ...(e.g., SQL) Experience in Python, Advanced SQL, Azure, Snowflake, and/or Microsoft Fabric Working with data used for demand planning...SuggestedFull timeWork experience placementInternshipLocal areaImmediate startShift work- ...Johnstone Supply, North Americas leading wholesale distributor of HVACR equipment, parts, and supplies has a great opportunity for a Data Architect to join our team. Over the last seven decades Johnstone has grown into the industry leader with over 450 distributor branches...Bi-weekly payTemporary workFor contractorsImmediate startWork from homeFlexible hours
Johnstone Supply
Portland, OR2 days ago - ...Data Architect Long term contract Milwaukie, OR - Locals required Hybrid Research and properly evaluate sources of information to determine possible limitations in reliability or usability, apply sampling techniques to effectively...Long term contractLocal area
GlobalPoint
Portland, OR3 days ago - CitiusTech is looking for an experienced Data Engineer in Portland, OR. You will design, develop, and maintain data pipelines, optimize... ...with cross-functional teams. A strong background in Snowflake and ETL tools is required. Ideal candidates should have over 10...
- ...RevSpring in Portland, Oregon is seeking a Data Architect to innovate and manage scalable data systems for healthcare applications. You will design cohesive architectures that support clinical and operational workflows, ensuring compliance with healthcare regulations...
RevSpring
Portland, OR2 days ago - A leading consulting firm is seeking a Senior Manager in Data Architecture to lead transformative projects in the automotive and aerospace sectors. The ideal candidate will have extensive experience in data architecture and engineering, having delivered business use cases...
- Ernst & Young Oman is looking for an AI Finance Senior in Portland, Oregon. This key role involves supporting the finance data management strategy, leveraging skills in data governance and Machine Learning. The ideal candidate must have a Bachelor's degree, 2+ years in...Flexible hours
- ...Job Title Job Duties: • Develop and support data solutions in support of Supply Chain Planning reporting and analytics requirements... ...preferences are: • Experience developing solutions in Snowflake • Experience with workload automation tools such as Airflow, Autosys...
BizTek People
Beaverton, OR23 hours ago - GoTo Meeting is seeking an experienced Data Architect to lead the design and management of scalable data systems for healthcare applications. This role involves innovating data architectures that ensure compliance with regulations, optimizing for performance, and transforming...
- ...Senior Data Analyst– NIKE, Inc.- Beaverton, OR. Design, develop, and implement new decision support solutions that help the business... ...requires: • Cloud Data Platforms such as Databricks and Snowflake • Database systems tools such as SQL Server and Teradata •...Remote work
NIKE
Beaverton, OR3 days ago - ...local government entity in Portland is seeking a Senior Database Administrator to lead exciting projects, including the migration of data systems to cloud technology. This role requires managing daily operations of databases while also ensuring data integrity and...Local area
- A leading energy nonprofit in Oregon is seeking an experienced Enterprise Data Architect to define and implement the organization's data architecture strategy. This role involves ensuring data governance practices and designing data integration patterns to enhance data...Remote jobFlexible hours
$144k - $329.1k
...go. Join EY and help to build a better working world. Role AI & Data - Data Architecture - Senior Manager - Power & Utilities Sector... ...quality solutions. Your responsibilities will include: As Data Architect - Senior Manager, you will have an expert understanding of data...Summer holidayFlexible hours$133.9k - $167.8k
Overview Position: Enterprise Data Architect Reports to: Data & Automation Manager Compensation: Competitive starting salary $133,900 - $167,800 commensurate with skills and experience. Full pay range: $133,900 - $184,700 Energy Trust is committed to pay equity . Energy...Full timeFor contractorsWork at officeImmediate startRemote workWork from home$102.2k - $160.6k
ZoomInfo is on the lookout for a Senior Data Systems Analyst in Vancouver, WA to master their data pipeline and contribute to architecture improvements. This position requires a strong background in data systems, ETL, and the ability to work closely with engineering and...- Energy Trust of Oregon is hiring an Enterprise Data Architect to lead data architecture strategy and governance. This role involves shaping data usage in support of business objectives and requires a solid background in data modeling and SQL proficiency. The ideal candidate...
- A professional IT services company is seeking a Senior Solutions Engineer focused on Data Center solutions. The role involves collaborating with the sales team for strategies, creating system designs during pre-sales, and implementing these solutions post-sale. The ideal...
- ...insights / metrics requirements, define business logic & analyze the data needed to build them ~ Query datasets from various data... ...adoption ~ Strong hands on experience with SQL, Python, AWS, Snowflake, Databricks, Tableau & related toolsets ~ A strong history of...
BizTek People
Beaverton, OR23 hours ago $130.7k - $205.2k
Sustainability Data Solutions Architect**Description -****Job Summary**Acting as the operational backbone and architectural steward of compliance and sustainability data solutions, this individual will ensure continuity of reporting, data quality, and stakeholder trust...Full timeTemporary workLocal areaRelocationFlexible hoursShift work$75k - $85k
...gain access to housing. Role Overview As a Revenue Operations Data Analyst at OneApp, you will play a key role in transforming data... ...Key Responsibilities Write and optimize SQL queries against Snowflake and MySQL databases to extract, transform, and analyze data. Build...Full timeLocal areaMonday to Friday- ...Quality Improvement Analyst II is responsible for performing comprehensive data analysis and visualization to support health care quality improvement initiatives using tools such as Tableau, SQL, SNOWFLAKE, and Databricks. This role involves synthesizing and analyzing health...Remote jobWork at officeLocal areaFlexible hours
- ...A leading technology company is seeking a Sustainability Data Solutions Architect in Vancouver, WA. This role will ensure continuity of compliance and sustainability data solutions, managing operational performance, architectural integrity, and stakeholder relationships...
HP
Vancouver, WA2 days ago - ...relevant experience, a strong understanding of geospatial concepts, and proficiency in software like ESRI. Responsibilities include data validation, managing workflows, and collaborating with technical teams. A hybrid working model is offered, along with a competitive...
- ...A leading distributor of HVACR equipment in Portland, Oregon, is seeking a Data Architect to own the enterprise data platform strategy. The role requires defining and evolving the data architecture, ensuring alignment with business objectives. Candidates should have over...
Johnstone Supply
Portland, OR2 days ago $94.7k
...candidate for a role focused on transportation demand forecasting. Responsibilities include developing travel demand models and conducting data analysis using tools such as ArcGIS and SQL. A Bachelor's degree in Civil or Transportation Engineering and two years of relevant...Local area$106.9k - $176.5k
...powerhouse of diverse teams and take your career wherever you want it to go. Join EY and help to build a better working world. AI & Data - Data Modeler - Senior We are seeking a highly skilled Senior Consultant Data Modeler with expertise in delivering data models that...Summer holidayFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Snowflake Data Architect. Be the first to apply!
Related searches