Lead Data Architect

Randstad USA

Pasadena (CA)

On-site

USD 83,000 - 90,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Randstad USA, located in Pasadena, CA, seeks a Lead Data Architect for an 8-month contract. The candidate must be onsite 3 days per week and will join a team delivering a next-gen cloud-hosted data platform.

The ideal candidate has a proven track record implementing cloud data solutions and transformation pipelines for large organizations. Expertise across data warehousing, ETL, data governance, and scalable architectures is required.

Qualifications

  • 8+ years of software development experience with data warehouse applications.
  • 3+ years in a technical leadership role.
  • 3+ years of cloud-based data warehouse platform experience (AWS Redshift preferred).
  • 3+ years of Python scripting experience.

Responsibilities

  • Architect and maintain ODS, EDW and related data environments including data lakes and data marts.
  • Design and implement high-performance data pipelines using ETL tools with batch and real-time data streams.
  • Develop scalable ingestion frameworks for structured and semi-structured data and data movement frameworks.
  • Create data architecture diagrams and translate requirements into data models.
  • Ensure data warehouse features are included for performance, resiliency, and scalability.
  • Lead data governance capabilities like data lineage and data quality.

Skills

Python scripting
Data governance
CI/CD
Executive communication

Education

Bachelor's/Master's in CS/Engineering

Tools

AWS Redshift
Azure Data Factory
Informatica Cloud
Informatica
Python scripting
GitHub Actions
Jenkins
Talend
SSIS

Job description

job summary:
Our client is looking for a Lead Data Architect for a 8 month contract opportunity located in West LA. The candidate will be required to be onsite 3 days per week.
location: Pasadena, California
job type: Contract
salary: $60 - 65 per hour
work hours: 8am to 5pm
education: Bachelors

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

We are seeking 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).
Qualifications

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.

Additional Requirements
Ability to work in the U.S. without sponsorship
Ability to meet the location requirement outlined above

Skills

AWS Redshift,AI Experience,AI,Azure Data Factory,large volumes of data,Cloud Data,Cloud-based data,Computer Engineering,Data Architect,enterprise data architecture,Data Architecture,Data Governance,Data Integration,data intelligence,data lake,Data lakes,data lineage,data marts,data pipelines,data flows,data streams,data solutions,EDW,dimensional data,data warehouse,Enterprise Data Warehouse,database,dimensional modeling,end-to-end testing,enterprise data,ETL development,ETL,data movement,ETL tools,ETL data,Github,GitHub Actions,Informatica Cloud,Informatica,data engineering,computer science,infrastructure-as-code tools,Miro,Jenkins,metadata repositories,data catalog,Visio,OLAP,OLTP,open-source,ODS,Operational data,PCI DSS,performance tuning,SQL,SSIS,SSRS,Python scripting,semi-structured data,software development,cloud data warehouse,test strategy,integration experience,Talend,test execution,communicate,Executive Communication,communication skills,ability to communicate,Communication,executive leadership,leadership,Problem-solving,collaborating,architecture,Architecting,automated testing framework,automation,business intelligence,business needs,change management,data models,Data Modeling,logical and physical data models,data model,data quality,Strong presentation,presenting,presentation skills,executive-level communication,fintech,data flow diagrams,financial services,compliance standards,modeling,clear communication,sponsorship,QA practices,QA,security,scalability,service delivery,project stakeholders,Warehousing,warehouse,technical leadership,technical publications,test planning,testing,data workflows

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.

Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.

Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Randstad Digital • Arlington (VA)

On-site
USD 66,000 - 72,000
Data Engineer Sr Specialized
Data Engineer Sr Specialized

Randstad USA • Cleveland (OH)

Remote
USD 92,000 - 106,000
Health insurance
Data Engineer Sr Specialized
Data Engineer Sr Specialized

Randstad Digital Americas • Cleveland (OH)

Remote
USD 92,000 - 106,000
Cloud Security Engineer
Cloud Security Engineer

Randstad Digital • Sacramento (CA)

Hybrid
USD 122,000 - 140,000
Medical
Prescription
Dental
+5
Administrative Assistant
Administrative Assistant

Randstad USA • Santa Fe Springs (CA)

On-site
USD 30,000 - 41,000
Medical insurance
Dental insurance
Vision insurance
+4
BSA
BSA

Capgemini • Jersey City (NJ)

On-site
USD 52,000 - 81,000
Medical benefits
Dental benefits
Vision benefits
+1
Data Engineering Manager (Banking)
Data Engineering Manager (Banking)

Ledgent Technology • San Diego (CA)

On-site
USD 162,000 - 198,000
Data Engineering Lead
Data Engineering Lead

Capgemini • Irving (TX)

On-site
USD 72,000 - 112,000
Medical benefits
Dental benefits
Vision benefits
+1
Supplier Enablement Specialist
Supplier Enablement Specialist

Randstad Digital Americas • Foster City (CA)

On-site
USD 68,000 - 69,000
Medical benefits
401K plan
Short-term disability
+1
Site Reliability Engineer
Site Reliability Engineer

Randstad USA • Chandler (AZ)

On-site
USD 78,000 - 92,000
Medical, Prescription, Dental, Vision
401K plan
Short-term disability
+1