Data Architect

Long Finch Technologies

South San Francisco, CA

Posted On: Dec 03, 2025

Posted On: Dec 03, 2025

Job Overview

Job Type

Contract - W2, Contract - Corp-to-Corp, Contract - Independent

Experience

12 - 18 Years

Salary

Depends on Experience

Work Arrangement

On-Site

Travel Requirement

0%

Required Skills

  • architecture
  • Matillion ETL
  • Snowflake
  • SQL
  • Git
Job Description
Key Responsibilities
  • Design and architect end-to-end data solutions leveraging Snowflake as the primary data warehouse.
  • Build and optimise 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.
  • Optimise 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 modernisation 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, materialised views, performance tuning.
  • Proficiency in SQL, data modelling, and data warehouse concepts (Kimball/Inmon).
  • Experience with cloud platforms (AWS/Azure/GCP), especially AWS services like S3, Lambda, EC2, and 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.

Job ID: LF250165


Posted By

Mayank Rawat

Bilingual Recruiter


Related Jobs
  • Contract - W2
  • Contract - Corp-to-Corp
  • Contract - Independent

  • Company
  • COMPANY

    Long Finch Technologies

  • Company
  • experience

    12 - 18 Years

  • Travel Requirements
  • Work Arrangement

    On-Site

  • Wallet
  • SALARY

    Depends on Experience

  • Skills
  • SKILLS

    • architecture
    • Matillion ETL
    • Snowflake
    • SQL
    • +1 more

Posted On: Dec 03, 2025

  • Contract - W2
  • Contract - Corp-to-Corp
  • Contract - Independent

  • Company
  • COMPANY

    Long Finch Technologies

  • Company
  • experience

    10 - 16 Years

  • Travel Requirements
  • Work Arrangement

    Hybrid

  • Wallet
  • SALARY

    Depends on Experience

  • Skills
  • SKILLS

    • Data Engineer
    • AWS
    • Snowflake
    • DBT
    • +2 more

Posted On: Dec 03, 2025

  • Full-time

  • Company
  • COMPANY

    Techvilla Solutions

  • Company
  • experience

    10 - 15 Years

  • Travel Requirements
  • Work Arrangement

    Remote

  • Wallet
  • SALARY

    Depends on Experience

  • Skills
  • SKILLS

    • Data Modeling
    • SQL
    • NoSQL
    • Data Warehousing
    • +2 more

Posted On: Dec 02, 2025

  • Contract - W2
  • Contract - Independent
  • Contract - Corp-to-Corp

  • Company
  • COMPANY

    Techvilla Solutions

  • Company
  • experience

    10 - 18 Years

  • Travel Requirements
  • Work Arrangement

    Hybrid

  • Wallet
  • SALARY

    Depends on Experience

  • Skills
  • SKILLS

    • Snowflake
    • AWS
    • Data Integration
    • data architecture
    • +1 more

Posted On: Nov 04, 2025


  • Company
  • COMPANY

    LONG FINCH TECHNOLOGIES

  • Company
  • experience

    10 - 25 Years

  • Travel Requirements
  • Work Arrangement

    Hybrid

  • Wallet
  • SALARY

    Depends on Experience

  • Skills
  • SKILLS

    • azure
    • databricks
    • data architect
    • banking

Posted On: Oct 31, 2025