Data Architect

Critical River, Inc.
San Francisco, CA, United States
2 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source

Tech stack

Artificial Intelligence Airflow Amazon Web Services Business Analytics Applications Data Analysis ARM Architecture Microsoft Azure Big Data BigQuery Data Architecture Information Engineering Data Governance
+32 more
Extract Transform Load (ETL) Data Vault Modeling Data Warehousing Dimensional Modeling Python (Programming Language) Meta-Data Management Power BI OpenAI Cloud Services SQL Databases Data Streaming Tableau (Software) Enterprise Data Management Google Cloud Retrieval-Augmented Generation Large Language Models Snowflake Apache Spark Generative AI Agentic-AI Microsoft Fabric Data Lakes AWS Glue Apache Kafka Data Management Machine Learning Operations Cloud Migration Azure Synapse Analytics Looker Analytics Mulesoft Amazon Redshift Databricks

Job description

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., * 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.

Requirements

  • 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., * 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.dice.com
Prepare application

Good distractions

Loading talks and stories from around this role…