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.