Lead Data Architect

Codetech•Pasadena, TX
•Hybrid

About The Position

Green Dot Corporation is seeking a hands-on Lead Data Architect to design and deliver large-scale data solutions as part of a next-generation cloud-hosted data platform. The role combines enterprise data architecture ownership with strong data engineering and development experience. The architect will design and maintain ODS, EDW, data lake, data mart, and metadata repository environments; create data models and data-flow designs; and communicate architecture decisions and technical recommendations to stakeholders and senior technology leaders. The position involves delivering proofs of concept and production implementations, building high-performance data movement pipelines, developing reusable data ingestion and settlement/reconciliation frameworks, and supporting data governance, data quality, and data lineage capabilities. It also includes hands-on production-grade ETL development, performance tuning, testing framework and strategy leadership, CI/CD integration, and resolving production issues. The role requires practical AI experience and demonstrated ability to present technical solutions to executive leadership. This is a structured hybrid position requiring at least three days per week onsite in West Los Angeles. The posting says candidates must currently reside in the approved location of West Los Angeles, California; elsewhere it states that Los Angeles-area candidates are sought and relocation may be considered at the candidate's expense. Candidates must be authorized to work in the United States without sponsorship.

Requirements

  • At least 8 years of overall software development experience, primarily with data warehouse applications.
  • At least 3 years in a technical leadership role.
  • At least 3 years of hands-on development experience with a cloud-based data warehouse platform.
  • At least 3 years of Python scripting development experience.
  • Strong knowledge and experience in OLAP data modeling and design.
  • Demonstrated ownership and experience designing enterprise ODS, EDW, and/or data lake architectures.
  • Hands-on experience with both OLTP transactional modeling and EDW dimensional modeling.
  • Strong ETL development and data integration experience.
  • Practical, hands-on application of AI in a professional work environment.
  • Strong data engineering foundation, including data workflows, integration, and enterprise data systems.
  • Experience presenting architecture, data solutions, and technical recommendations to senior leadership and C-suite executives.
  • Knowledge of data governance, security, and compliance standards such as SOC 2 and PCI DSS.
  • Demonstrated expertise in performance tuning across database environments with large volumes of data.
  • Familiarity with CI/CD pipelines and infrastructure-as-code tools.
  • Ability to understand complex business needs and analyze, design, and develop solutions.
  • Strong communication and professional skills, including the ability to navigate relationships across business units.
  • Ability to meet the location requirement and work onsite in West Los Angeles at least three days per week.
  • Authorization to work in the United States without sponsorship.
  • Bachelor's and/or master's degree in computer science, computer engineering, or a related field preferred.

Nice To Haves

  • AWS Redshift experience.
  • Informatica Cloud (IICS) experience.
  • Experience with Azure Data Factory, SQL Packages, Talend, or SSIS/SSRS.
  • Experience with data modeling tools such as Erwin; Visio or Miro experience may also be considered.
  • 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.

Responsibilities

  • Architect and maintain operational data stores (ODS), enterprise data warehouses (EDW), and related data intelligence environments, including data lakes, data marts, and metadata repositories.
  • Design and implement high-performance data movement pipelines using multiple ETL tools and batch and real-time event data streams.
  • Develop scalable, reusable frameworks for ingesting structured and semi-structured data and implement large-scale settlement and reconciliation frameworks.
  • Create data architecture and data-flow diagrams and collaborate with peers to translate requirements into logical and physical data models.
  • Incorporate data warehouse capabilities into model designs to optimize performance, resiliency, and scalability.
  • Deliver and present proofs of concept for key technology components to project stakeholders and internal technology leaders.
  • Lead and coordinate the design and operationalization of data governance capabilities, including data lineage, data catalog, and data quality.
  • Troubleshoot data warehouse and ODS application issues and production errors, including critical production incidents requiring immediate attention.
  • Write, test, and deliver production-grade ETL pipeline code for financial services without relying on other groups for testing.
  • Implement intelligent testing frameworks that auto-generate test cases, predict bugs, and enable self-healing.
  • Lead test strategy, planning, and execution across functional, integration, systems, end-to-end, accessibility, database validation, and automation testing.
  • Integrate test suites into CI/CD pipelines such as Jenkins and GitHub.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service