Data Architect

California Coast Credit Union; San Diego (CA); Hybrid; USD 131,000 - 164,000; Full time

Job summary

California Coast Credit Union is seeking a hands‑on Data Architect in San Diego to lead enterprise data architecture across on‑prem and cloud platforms. You will define scalable data models, set integration patterns, and guide Data Lake, Data Warehouse, and ODS initiatives for analytics, reporting, and digital banking.

The role involves mentoring Data Engineers and Analysts, collaborating with cross‑functional teams, and ensuring secure, high‑performing data environments while advancing modern

Qualifications

• Bachelor’s degree in computer science, Information Systems, or a related field.
• 12+ years of experience in data architecture, data engineering, database design, and enterprise data platforms.
• Proven leadership experience guiding engineering teams and influencing enterprise data strategy.

Responsibilities

• Define and maintain enterprise data models, canonical schemas, and integration patterns.
• Architect and govern Data Lake, Data Warehouse, ODS, and cloud data platforms.
• Lead data governance, quality, lineage, and metadata management initiatives.
• Design semantic models and analytics-ready structures for BI tools like Power BI/Tableau.
• Collaborate with engineering, product, security, and business teams to align data architecture with strategy.

Skills

Data architecture

Cloud data platforms

SQL

Python

ETL/ELT

Data governance

BI/Analytics concepts

Data modeling

Stakeholder management

Education

Bachelor’s degree in computer science or related field

Tools

Snowflake

Azure Synapse

Azure SQL

SQL Server

MongoDB Atlas

Cosmos DB

Data integration tools (ADF, Airflow, Informatica)

Dbt Cloud

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Data Architect

Full Time San Diego, CA, US

14 days ago Requisition ID: 2557

Salary Range: $130,813.65 To $163,517.07 Annually

JOB Objective

The Data Architect is a hands‑on technical leader responsible for shaping and modernizing the organization’s enterprise data architecture across on‑premises and cloud platforms. The role defines scalable data models, cloud‑native integration patterns, and architectural standards that enable analytics, reporting, digital banking, and other mission‑critical applications. Working closely with engineering, analytics, and business teams, this leader ensures secure, resilient, and high‑performing data environments while providing architectural direction for the Data Lake, Data Warehouse, Operational Data Store, and emerging cloud platforms. The position combines strategic architectural vision with deep, practical experience in designing, implementing, and optimizing modern data systems across structured, semi‑structured, and unstructured workloads.

Supervisory responsibilities

• Reports directly to the Director, Cloud & Data for strategic direction, coaching, and performance evaluation.
• Provides architectural leadership and technical guidance to Data Engineers, Data Analysts, and cross‑functional development teams.

NATURE & SCOPE

This role shapes enterprise data strategy, mentors teams on modern architecture and governance, and ensures alignment on scalable design principles across cloud and on‑prem data platforms.

• Define and maintain enterprise data models, canonical schemas, and integration patterns supporting analytics, reporting, and digital banking.
• Architect and govern the Data Lake, Data Warehouse, ODS, and cloud data platforms, ensuring consistency, scalability, and alignment with business needs.
• Establish standards for structured, semi‑structured, and unstructured data across SQL, NoSQL, and cloud‑native systems.
• Lead the design of golden‑record strategies, SSOT frameworks, and member‑data standardization initiatives.

Data Governance, Quality & Metadata Management

• Develop and enforce policies for data quality, lineage, cataloging, and metadata management.
• Partner with business and engineering teams to implement governance frameworks that ensure accuracy, consistency, and regulatory compliance.
• Oversee data validation, profiling, and quality automation across ingestion and transformation pipelines.
• Architect enterprise‑grade data ingestion, transformation, and integration pipelines using modern tools such as ADF, Airflow, Informatica, SSIS, and cloud‑native services.
• Define standards for API‑driven data exchange, event‑based integrations, and real‑time data flows supporting ODS and transactional reporting.
• Guide engineering teams on best practices for ETL/ELT design, orchestration, and automation.
• Provide architectural oversight for SQL Server, Azure SQL, Snowflake, MySQL, MongoDB Atlas, Cosmos DB, and other enterprise data platforms.
• Define strategies for high availability, disaster recovery, performance tuning, and secure connectivity.
• Lead modernization efforts including cloud migration, platform consolidation, and adoption of emerging data technologies.

Analytics & BI Enablement

• Architect semantic models, curated datasets, and analytics‑ready structures for BI platforms such as Power BI and Tableau.
• Partner with analytics teams to ensure data structures support advanced reporting, machine learning, and enterprise dashboards.
• Govern KPI definitions, metric consistency, and analytical data standards.

Collaboration & Cross‑Functional Leadership

• Work closely with engineering, product, security, and business teams to align data architecture with organizational strategy.
• Provide architectural guidance for enterprise projects, digital platform initiatives, and system conversions.
• Communicate complex data concepts to technical and non‑technical stakeholders through documentation, diagrams, and presentations.

EDUCATION, SKILLS & ABILITIES

• Bachelor’s degree in computer science, Information Systems, or related field.
• 12+ years of progressive experience in data architecture, data engineering, database design, and enterprise data platforms.
• Proven leadership experience guiding engineering teams and influencing enterprise data strategy.

Technical Expertise

• Mastery of enterprise data modeling (conceptual, logical, physical) and metadata management.
• Deep experience with cloud databases as a service such as Snowflake, Azure Synapse, Azure SQL, SQL Server, MongoDB Atlas, Cosmos DB, and cloud‑native data services.
• Advanced SQL, Python, and scripting capabilities for architectural prototyping and troubleshooting.
• Expertise in ETL/ELT frameworks such as SSIS, Informatica IDMC, Airflow, Dbt Cloud, ADF.
• Strong understanding of ODS architecture, real‑time data flows, and transactional reporting needs supported by responsibilities such as Configures and maintaining the organization’s Operation Data Store (ODS).
• Experience with data quality frameworks, governance tools, and lineage/cataloging platforms.
• Hands‑on experience with BI tools such as Power BI, Tableau and semantic modeling.
• Knowledge of cloud security, encryption, RBAC, and compliance standards for financial institutions.

Leadership & Soft Skills

• Strong communication and stakeholder‑management skills.
• Ability to translate business requirements into scalable architectural designs.
• Demonstrated mentorship, collaboration, and cross‑team leadership.
• Commitment to operational excellence, documentation, and continuous improvement.

MAJOR ACCOUNTABILITIES

• Define and maintain the enterprise data architecture roadmap.
• Ensure data platforms meet performance, security, and compliance standards.
• Lead architectural design for enterprise data initiatives such as golden records, and 360‑member view.
• Provide architectural oversight for Data Warehouse, Data Lake, ODS, and analytics/BI platforms.
• Partner with engineering teams to ensure high‑quality implementation of architectural designs.
• Support enterprise projects with architectural guidance and technical leadership.
• Ensure member service and satisfaction remain central to all data‑related initiatives.
• Perform other duties as assigned.

ENVIRONMENTAL CONDITIONS

• Work is primarily performed within a cubicle office setting. Subject to conversational noise found in an office environment.

Note: Staff are expected to perform various tasks, projects and administrative duties as assigned.

Management reserves the right to assign or change duties and tasks to this position at their discretion.