7069 - Senior Data Architect Cloud Data Warehouse (Must currently reside in San Francisco to be considered)

  • San Francisco, CA
  • Posted 5 days ago | Updated 5 days ago

Overview

Hybrid
$50+
Contract - W2
Contract - Independent
Contract - 36 Month(s)
No Travel Required

Skills

Amazon Web Services
Analytics
Bridging
Business Strategy
Cloud Computing
Collaboration
Dashboard
Data Architecture
Data Governance
Data Modeling
Data Warehouse
Database
Decision-making
Dimensional Modeling
Documentation
ELT
Extract
Transform
Load
Facilitation
IT Architecture
Leadership
Management
Microsoft Azure
Microsoft Power BI
Normalization
Presentations
Regulatory Reporting
Reporting
Research
Snow Flake Schema
Status Reports
Talend
User-centered Design
Workflow

Job Details

We are seeking a highly experienced Senior Data Architect to support a large-scale, cloud-based enterprise data warehouse initiative. This role is critical in designing scalable, secure, and high-performing data architecture to support analytics and reporting needs across a statewide organization. The ideal candidate excels in bridging business strategy with technical execution, translating complex business and research requirements into robust data solutions.

  • Lead the design and implementation of data architecture and pipelines in a cloud-based data warehouse environment.

  • Collaborate with business analysts, researchers, and stakeholders to define and document data requirements.

  • Present and defend technical architecture solutions to senior leadership, including CIO and data teams.

  • Design ETL/ELT workflows, database schemas, and automation pipelines using modern data tools.

  • Serve as a liaison between technical and business teams, facilitating alignment and resolving conflicts.

  • Contribute to and promote data governance practices and documentation standards.

  • Participate in strategic decision-making to ensure data infrastructure supports evolving business needs.

  • Produce monthly status reports summarizing progress and deliverables.

  • Extensive hands-on experience architecting and managing cloud-based data warehouses (e.g., Snowflake, AWS, Azure).

  • Advanced expertise in data modeling, including dimensional modeling and normalization.

  • Proven experience designing ETL/ELT pipelines, ideally with Snowflake and Talend.

  • Strong ability to translate business/research needs into executable technical architecture.

  • Experience presenting technical solutions to senior executives.

  • Deep understanding of data governance, policy development, and documentation.

  • Experience creating analytics dashboards and visualizations (e.g., Power BI).

  • Familiarity with government operations, regulatory reporting, or judicial systems.

  • Knowledge of regulatory frameworks (e.g., FedRAMP, SOC2, GDPR).

  • Background in user-centered design and stakeholder engagement.

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.