ZipStaff Inc.

Lead Data Architect

Los Angeles, California•Contract
$45 - $47 hourly
About the Job
Title: Lead Data Architect.
Location: Los Angeles, CA (Hybrid).
Type: Contract.

Overview:
ZipStaff is hiring a hands-on Lead Data Architect for our client, a well-known financial technology and banking services company. You'll own enterprise data architecture (ODS, EDW, and data lake) for a next-gen cloud data platform, design data models, and present solutions to executive leadership. This is an architecture role, not strictly ETL development. Hybrid: minimum 3 days per week onsite in West Los Angeles; candidates must live in the Los Angeles area and be authorized to work in the U.S. without sponsorship.

Responsibilities:
  • Architect and maintain ODS, EDW, data lakes, data marts, and metadata repositories.
  • Design high-performance batch and real-time data pipelines using ETL tools such as Informatica, Azure Data Factory, and SQL packages.
  • Build reusable frameworks for structured and semi-structured data ingestion, settlement, and reconciliation.
  • Create architecture and data flow diagrams and translate requirements into logical and physical data models.
  • Deliver proofs of concept and present architecture recommendations to senior and C-suite leaders.
  • Lead data governance capabilities such as lineage, catalog, and data quality.
  • Resolve critical data warehouse and ODS production issues.
  • Write and test production-grade ETL code and integrate test suites into CI/CD (Jenkins, GitHub).

Required Qualifications:
  • 8+ years of software development, mainly data warehouse applications, with 3+ years in technical leadership.
  • Proven ownership of ODS, EDW, and/or data lake architecture, not just ETL mappings within an existing design.
  • Strong hands-on OLTP and dimensional (OLAP) data modeling.
  • 3+ years of hands-on cloud data warehouse development (AWS Redshift preferred).
  • Strong ETL and integration experience (Informatica Cloud/IICS preferred; Talend and SSIS/SSRS relevant).
  • 3+ years of Python scripting.
  • Practical, hands-on use of AI in a professional environment.
  • Performance tuning with large data volumes, plus knowledge of governance and compliance (SOC 2, PCI DSS).
  • Excellent communication, including presenting to executive leadership.

Preferred Qualifications:
  • Fintech or enterprise data warehouse platform experience.
  • Data modeling tools such as Erwin, Visio, or Miro.
  • Partner reporting, compliance analytics, or BI domains.
  • Bachelor's or master's degree in Computer Science or a related field.

Benefits:
  • Health Insurance.
  • Dental Insurance.
  • Vision Insurance.
  • 401(k) + matching.
  • Paid time off.
  • Referral Program.

About ZipStaff:
ZipStaff connects skilled technology professionals with leading organizations across the United States, matching top talent with impactful contract and full-time opportunities.

To apply, submit your resume through this posting. Qualified candidates will be contacted by a ZipStaff recruiter.