Snowflake Data Architect Job at Momento USA, South San Francisco, CA

Z1hMVEtMQ0gvS0JJUlBHckttdnVaYlptRVE9PQ==
  • Momento USA
  • South San Francisco, CA

Job Description

Snowflake Data Architect
Location: South San Francisco, CA (3 Days Onsite / Hybrid) Only Local
Duration: Long Term


Key Responsibilities

  • Design and architect end-to-end data solutions leveraging Snowflake as the primary data warehouse.
  • Build and optimize ETL/ELT pipelines using Matillion, ensuring scalability, performance, and reliability.
  • Develop data models (conceptual, logical, and physical) addressing business and analytical requirements.
  • Define and enforce data governance, data quality, and metadata management standards.
  • Work closely with product, BI, analytics, and engineering teams to translate business needs into architectural blueprints.
  • Optimize Snowflake performance: clustering, micro-partitioning, caching, warehouse sizing, and cost governance.
  • Integrate data from various structured and unstructured sources.
  • Review existing data systems and recommend modernization opportunities.
  • Ensure security best practices including role-based access control, encryption, and compliance.
  • Create documentation, architectural diagrams, and data flow maps.
  • Drive best practices for CI/CD, data testing, and DevOps for data pipelines.

Required Skills

  • 10+ years of experience in data engineering or data architecture roles.
  • Strong hands-on expertise in Matillion ETL/ELT (jobs, orchestration, components, transformations).
  • Deep understanding of Snowflake-warehouses, schema design, streams, tasks, materialized views, performance tuning.
  • Proficiency in SQL, data modeling, and data warehouse concepts (Kimball/Inmon).
  • Experience with cloud platforms (AWS/Azure/GCP), especially AWS services like S3, Lambda, EC2, IAM.
  • Strong understanding of batch and real-time data processing patterns.
  • Knowledge of data governance, master data management, and metadata frameworks.
  • Experience with version control (Git) and CI/CD workflows.
  • Ability to create architecture diagrams using tools like Lucidchart, Draw.io, or Visio.

Note: Momento USA is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Job Tags

Local area,

Similar Jobs

NCH Corporation

Research Associate Job at NCH Corporation

 ...Entrepreneurial, EmpoweredExplore the Opportunities! Research Associate We are seeking a highly motivated, detail-...  ...conference room, planned activities) Community involvement(volunteering, fundraisers, charity events, school sponsorships and donations... 

Oracle

Senior Program Manager, Global Physical Security - Construction & Expansion (OCI) Job at Oracle

 ...Infrastructure (OCI) seeks a seasoned Senior Program Manager to lead the end-to-end delivery of physical security systems for new builds and site expansions across OCI's global footprint. This critical role is responsible for ensuring that every OCI facility meets the highest... 

Sync Staffing, Inc

Class C Driver- Ontario Job at Sync Staffing, Inc

WE'RE HIRING! CLASS C DRIVERS City: Ontario Schedule: Monday-Friday 7AM-3:30PM Pay rate : $22h/r ~ Must be 22 years or older ~ Must have no traffic violations in the past 1 year ~ Must be able to work overtime ~1 year of driving experience ~ Must be... 

InSync Healthcare Recruiters

Gastroenterologist Job at InSync Healthcare Recruiters

 ...Gastroenterologist opportunity in Braselton & Gainesville, GA Opportunity Overview: Great opportunity for a Board-Certified or Board-Eligible Gastroenterologist to join a growing practice in the beautiful and thriving communities of Braselton and Gainesville,... 

Gastro Health

Gastroenterologist Job at Gastro Health

Join a Respected GI Practice in Plantation Suburban Comfort Near Fort Lauderdale and Miami About the Opportunity: This is an excellent opportunity to join a well-established private practice and replace a retiring physician in a desirable South Florida community...