Data Architect

San Francisco, CA, US • Posted 6 hours ago • Updated 6 hours ago
Full Time
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • ADF
  • Amazon Redshift
  • Artificial Intelligence
  • Amazon Web Services
  • Data Engineering
  • Data Architecture
  • Data Modeling
  • Extract, Transform, Load
  • Generative Artificial Intelligence (AI)
  • Python
  • SQL
  • Machine Learning (ML)

Summary

Role: Data Architect

Location: SFO, CA (Onsite)
Employment Type: Full-Time with CriticalRiver
Experience: 15+ Years

 About the Role

CriticalRiver is seeking a highly experienced Data Architect to lead the design and delivery of enterprise-scale data platforms, cloud data ecosystems, analytics solutions, and modern data engineering architectures. The ideal candidate will possess deep expertise in Data Architecture, Data Engineering, Snowflake and/or Databricks, with exposure to AI/ML and Generative AI technologies.

 Key Responsibilities

  • Design and own enterprise data architectures across Data Lakes, Lakehouses, Data Warehouses, and Analytics Platforms.
  • Architect scalable cloud data solutions using Snowflake, Databricks, Microsoft Fabric, BigQuery, Redshift, and Azure Synapse.
  • Build modern ETL/ELT, CDC, batch, real-time, and streaming data pipelines using Python, SQL, Spark, Kafka, dbt, Airflow, and related technologies.
  • Define data modeling standards including Dimensional Modeling, Data Vault, and Semantic Models.
  • Lead cloud modernization and large-scale data migration initiatives across AWS, Azure, and Google Cloud Platform.
  • Implement data governance, metadata management, data quality, lineage, security, and compliance frameworks.
  • Enable enterprise BI and analytics using Power BI, Tableau, Looker, ThoughtSpot, and other modern analytics platforms.
  • Collaborate with AI/ML teams to integrate LLMs, RAG, Vector Databases, AI Agents, and Generative AI capabilities into enterprise data platforms.
  • Provide architecture leadership, client consulting, solution design, technical governance, presales support, and team mentoring.

 Required Skills

  • 15+ years in Data Engineering, Data Architecture, Cloud Data Platforms, and Analytics.
  • Strong hands-on expertise in Python, SQL, Apache Spark, Snowpark, ETL/ELT, Data Modeling, and Data Governance.
  • Deep experience with Snowflake and/or Databricks.
  • Expertise in AWS, Azure, or Google Cloud Platform cloud platforms.
  • Experience with Kafka, Airflow, Dagster, dbt, Delta Lake, Delta Live Tables, ADF, AWS Glue, Fivetran, Informatica, or MuleSoft.
  • Strong understanding of Data Quality, Metadata Management, Lineage, Security, and Governance.
  • Excellent communication, stakeholder management, consulting, and leadership skills.

Preferred Qualifications

  • Experience with Snowflake Horizon, Databricks Unity Catalog, Cortex AI, or Mosaic AI.
  • Exposure to LLMs, RAG, OpenAI, Azure OpenAI, Vertex AI, SageMaker, MLflow, Vector Databases, and AI Agents.
  • Certifications in AWS, Azure, Google Cloud Platform, Snowflake, or Databricks.
  • Background in consulting and regulated industries such as Healthcare, Retail, or BFSI.
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.
  • Dice Id: 90805586
  • Position Id: 9118344
  • Posted 6 hours ago
Contact the job poster
SK

Sai Kiran

Recruiter @ Critical River, Inc.

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.