Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 24 Month(s)
Skills
Data Architect
Matillion ETL
Snowflake
AWS/Azure/GCP
Git
Job Details
Position: Data Architect
Location: South San Francisco, CA (ONLY LOCALS)
Duration: Long Term
Client: Twist Bioscience / GSPANN
Duration: Long Term
Client: Twist Bioscience / GSPANN
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/Google Cloud Platform), 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.