Senior Data Architect: Snowflake or Databricks Specialist

8 West Consulting; United States; Remote; USD 150,000 - 210,000; Full time

Job summary

8 West Consulting seeks a senior, client-facing Data Architect/Consultant with deep production experience in Snowflake or Databricks to modernise data estates, define target architectures and deliver migrations across multiple client engagements.

You will combine hands-on technical judgement with executive-level communication, guiding discovery, architectures and data products while identifying opportunities in governance, analytics and AI.

Qualifications

• Platform expertise required on a production level for Snowflake or Databricks with hands-on design, implementation or migration experience.
• Snowflake pathway: architecture, loading, ELT, performance, security and capabilities like Snowpipe, Streams, Tasks; Databricks pathway: lakehouse, Delta Lake, Spark/PySpark, Unity Catalog, ingestion/orchestration tools.
• Experience delivering complex data migration and engineering projects across discovery, architecture, planning and implementation with dependencies and milestones.

Responsibilities

• Advise business and technology leaders. Lead workshops and explain options, risks and investments for executives.
• Shape enterprise data architecture, assess legacy estates and design warehouse or lakehouse platforms, migration stages and operating models.
• Lead data migration and integration; guide ETL/ELT, batch/incremental ingestion, CDC, orchestration, testing and production cutover.
• Stay close to technical delivery; review SQL, pipelines, data models and integrations; address reliability, performance and cost.
• Design trustworthy data layers with proper data quality, lineage, security and lifecycle controls.
• Enable secure sharing and data products; assess sharing, private exchange and marketplace options.
• Deliver with enterprise discipline; own roadmaps, dependencies, architecture decisions and stakeholder communications.
• Develop long-term client value; transfer knowledge and identify consulting opportunities in platform engineering and governance.

Skills

Snowflake

Databricks

Client advisory

Data migration

SQL & modelling

Governance

Platform delivery

Data architecture

Tools

dbt

Airflow

Job description

8 West Consulting seeks a senior, client-facing Data Architect/Consultant with deep production experience in Snowflake or Databricks to modernise data estates, define target architectures and deliver migrations across multiple client engagements.

You will combine hands-on technical judgement with executive-level communication, guiding discovery, architectures and data products while identifying opportunities in governance, analytics and AI.