JobHabor
Menu

Lead Data Architect

Sidram Technologies · Pasadena, CA, United States · Hybrid

Weak hiring record · median 369 days open

100100

Hiring signal

Actively hiring

Posted today · Never reposted · Checked today · How we score

First seen
16 November 2026
Reposted
Not since September 2026
Last checked
Today · still on the employer's board
All reasons
  • 89% of this employer's openings are over 60 days old

In its favour

  • Posted yesterday
  • Still listed on the employer's own board

Did you apply?

Lead Data Architect at Sidram Technologies. We’ll keep it in your applied jobs, so you can see it later and be warned before applying to the same employer twice.

This position may be offered to a candidate authorized to work in the US for his/her/their stated employer, without any restrictions which would prevent the candidate from working on the proposed assignment for the duration of the assignment period.

Position Overview

Seeking a hands-on Lead Data Architect with strong data engineering experience. The ideal candidate must have demonstrated ownership of enterprise data architecture, including designing ODS, EDW, and data lake solutions. This is not strictly an ETL development role. Candidates must have the ability to design architecture, develop data models, and communicate technical solutions to executive leadership.

Must-Have Qualifications

Data Architecture

Proven experience independently designing and owning ODS, EDW, and/or data lake architectures. Must have architecture-level responsibilities rather than simply developing ETL mappings within an existing design.

Data Modeling

Strong hands-on experience with both OLTP (transactional) and EDW dimensional data modeling. Candidates must demonstrate proficiency in both.

Cloud Data Warehousing

Minimum 3 years of hands-on cloud data warehouse experience. AWS Redshift preferred.

ETL/Data Integration

Strong ETL development and integration experience. Informatica Cloud (IICS) preferred. SSIS/SSRS and Talend experience are relevant.

AI Experience

Practical, hands-on application of AI in a professional work environment. Coursework, certifications, or theoretical knowledge alone are insufficient.

Executive Communication

Strong presentation and communication skills, including experience presenting architecture, data solutions, and technical recommendations to senior leadership and C-suite executives.

Data Engineering

Strong technical foundation in data engineering, data workflows, data integration, and enterprise data systems.

Additional Technical Skills

Data modeling tools such as Erwin; Visio and Miro experience may be considered.

AWS Redshift

Informatica Cloud (IICS)

Talend

SSIS/SSRS

ODS/EDW architecture

Data lakes

OLTP and dimensional modeling

Location and Work Authorization

Hybrid schedule is mandatory

3 days per week onsite in West Los Angeles.

Candidates should currently reside in the Los Angeles area.

Relocation may be considered if completed at the candidate's expense within weeks of starting.

Must be authorized to work in the U.S. without sponsorship.

Common Candidate Gaps / Reasons for Rejection

Strong ETL developers without architecture ownership.

Candidates who have built data pipelines or mappings but have not designed enterprise data architectures.

Experience with only OLTP or dimensional modeling rather than both.

Limited cloud data warehousing experience.

AI experience limited to coursework or certifications.

Insufficient executive-level communication or presentation skills.

Candidates unable to meet the mandatory West LA hybrid schedule.

Interview Focus / Supplier Screening

Suppliers should validate the following before submitting candidates

Has the candidate independently designed an ODS, EDW, or data lake architecture? What specific architecture decisions did they own?

Can the candidate explain their hands-on experience with both OLTP and dimensional data modeling?

How many years of hands-on cloud data warehouse experience do they have? Specifically, what experience do they have with AWS Redshift?

What experience do they have with Informatica Cloud (IICS), Talend, and SSIS/SSRS?

How have they applied AI in actual production or business environments?

Have they presented data architecture or technical solutions to C-suite or executive stakeholders?

Can they clearly articulate end-to-end data flows, architecture decisions, and technical tradeoffs?

Are they able to work onsite in West Los Angeles three days per week without requiring sponsorship?

Key Takeaway for Suppliers

Prioritize true data architects who are also hands-on data engineers. Candidates must demonstrate architecture ownership, strong data modeling across OLTP and EDW, cloud data warehousing expertise, practical AI experience, and the ability to communicate confidently with executive leadership. Strong ETL development experience alone is not sufficient.

Job Information

Job Taxonomy

Data Warehouse ETL

Job Title

Lead Data Architect

Job Description

This position is classified as structured hybrid, with an expectation of a minimum of three (3) days per week working in the office and flexibility to work remotely on the remaining days. On-site expectations may evolve over time to support business needs, with clear communication provided in advance.

JOB DESCRIPTION

Location Requirement

This position is open only to candidates who currently reside in one of the following approved locations: West Los Angeles, CA

Job Summary

Green Dot Corporation is seeking for a Lead Data Architect of large-scale data solutions. You will join a team delivering a transformative next-gen cloud hosted data platform.

The ideal candidate will have a proven track record in implementing next-gen cloud data solutions and transformation pipelines for large scale organizations. We are seeking someone with deep technical skills in a variety of data warehouse related technologies to play an important role in developing and delivering early proofs of concept and production implementation. The successful candidate will have hands-on experience in a multitude of data domains; including building data warehouse models, ETL development, automated testing framework, performance tuning, service delivery, incident resolution tracking, and change management.

Key Responsibilities

Architecting and maintaining Operational data stores (ODS), Enterprise Data Warehouse (EDW) and associated data intelligence environments including data lakes, data marts, and metadata repositories.

Designing and implementing high performance data movement pipelines using multiple ETL tools (Informatica, Azure Data Factory, SQL Packages, etc) with batch and real-time event data streams.

Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks.

Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models.

Ensures data warehouse features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability.

Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders.

Leading and coordinating the design and operationalization of Data Governance capabilities like data lineage, data catalog, data quality, etc.

Problem-solving of Data warehouse and ODS application issues and production errors, including high level critical production issues that require immediate attention.

Write, test and produce production grade ETL data pipeline code in financial services without relying on testing by other groups.

Implement intelligent testing frameworks that auto-generate test cases, predict bugs, and enable self-healing.

Leads the creation of test strategy, test planning, and test execution related to all aspects of testing like functional, integration, systems, end-to-end testing, accessibility, database validations, and automation.

Integrate test suites into CI/CD pipelines (Jenkins, Github).

Required Qualifications

Bachelors and/or masters degree in computer science, Computer Engineering or related field preferred.

8+ years of overall software development experience is required primarily with Data warehouse applications, with 3+ years in a technical leadership role.

3+ years of hands-on development experience in Cloud-based data warehouse platform (AWS Redshift preferred) and experience with ETL tools (Informatica Cloud preferred).

3+ years of development experience with Python scripting experience.

Strong knowledge and experience in OLAP data modeling & design.

Knowledge of data governance, security, and compliance standards (e.g., SOC 2, PCI DSS).

Demonstrated expertise in performance tuning in various DB environments with large volumes of data.

Familiarity with CI/CD pipelines (e.g., Jenkins, GitHub Actions) and infrastructure-as-code tools.

Expertise in understanding complex business needs, analyzing, designing, and developing solutions.

Communication and professional skills and the ability to navigate relationships across business units.

Preferred Qualifications

Experience in fintech or enterprise data warehouse platforms.

Familiarity with data warehouse operational domains such as partner reporting, compliance analytics, and business intelligence.

Contributions to open-source QA frameworks or technical publications.

Demonstrated leadership in building scalable QA practices, as outlined in internal QA leadership guidance.

**Ability to meet the location requirement outlined above**

Required Skills

Basic Qualification

Additional Skills

Background Check

No

Drug Screen

No

Skills

More jobs at Sidram Technologies

All 2,877

Similar roles