Data Architect
WorkNovas LLC
Title: Data Architect
Location: Fountain Valley, CA (100% Onsite )
Duration: 12 Months Contract
Job Description: Data Engineering Architect with 12+ years of experience in enterprise data engineering, ETL, data warehousing, cloud modernization and AI/ML solutions.
Technical Skills
- Strong expertise in Informatica PowerCenter, IDMC/IICS, PL/SQL, SQL, Python and Unix/Linux, with hands-on experience designing scalable ETL/ELT pipelines across heterogeneous sources including Oracle, SQL Server, PostgreSQL, DB2, MongoDB, APIs, JSON/XML and flat files.
- Experienced in AWS data and analytics services including S3, Glue, RDS, Redshift and Lambda, along with Databricks, Snowflake and Apache Airflow for cloud-based data engineering, orchestration and analytics architectures.
- Expertise in ETL architecture, complex transformations, full/incremental/CDC loads, SCD, data modelling, performance tuning, reconciliation and data quality.
Good Understanding of following:
- AI/ML capabilities covering Python, ML pipelines, MLOps, Generative AI, LLMs, RAG, embeddings, vector databases, LangChain/LangGraph and AI agents.
- Experience applying AI to data quality automation, anomaly detection, ETL/code generation, intelligent monitoring, RCA, data governance and enterprise data operations.
- Understanding of SDLC, architecture/design governance, CI/CD, Git, Agile delivery and technical leadership, with the ability to define enterprise data and AI architectures, lead solution design and mentor engineering teams.
Roles & Responsibilities:
- Define end-to-end data architecture for ETL, data warehouse, lakehouse and cloud platforms.
- Design source-to-target mapping, complex transformations, full/incremental/CDC loads, SCD, data modelling, performance tuning, reconciliation and data quality.
- Lead Informatica PowerCenter/IDMC architecture, mapping design, workflows and ETL framework standards.
- Design scalable data pipelines using AWS S3, Glue, RDS, Redshift, Lambda, Databricks, Snowflake and Airflow.
- Develop and optimize PL/SQL, SQL and Python solutions for complex data processing and validation.
- Define data modelling, CDC, SCD, incremental loads, reconciliation and data quality frameworks.
- Architect AI/ML and GenAI solutions, including LLM, RAG, embeddings, vector databases and AI agents.
- Drive ETL modernization and cloud migration from legacy/on-prem platforms to cloud architectures.
- Establish performance, security, monitoring, CI/CD and data governance standards.
- Lead technical design reviews, provide architecture guidance, resolve complex technical issues and mentor engineering teams.
- Collaborate with business, data, cloud and AI teams to translate requirements into scalable, secure and cost-effective solutions.
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Architect in Fountain Valley, CA vacancy
- ...top priority, we customize our solutions and services to align with the unique needs of each client.Job DescriptionTitle: Big data Architect ( Experience 12 Years) Location: Costa Mesa, CA Type: Contract About the Project: This project is focused on modernizing and re...SuggestedContract work
$129k - $171k
Anduril is seeking a Data Product Enablement Specialist in Costa Mesa, California. The ideal candidate will have over 6 years of experience in Data Enablement and Data Analytics, serving as a bridge between business and technical teams. Responsibilities include leading...SuggestedFull time$160.8k - $241.2k
...and Chip to Chiller. As a trusted pre‑sales technical advisor, you will influence architectures, systems, and product selections for data center applications. You will work hands‑on with customers early in the design cycle to understand challenges and shape solutions...SuggestedOngoing contractFull timeTemporary workImmediate startFlexible hours- ...Experience in developing, validating, publishing, maintaining LOGICAL data models with exposure to or experience in developing, validating... ...documentation for data modelsWork with Business Analysts, Data Architects, Software developers, DBAs to achieve project objectives -...SuggestedFull time
$129k - $171k
Anduril in Costa Mesa is seeking a Supply Chain Master Data Engineer to ensure the integrity and accuracy of critical supply chain data. The ideal candidate will manage governance for supplier records and contractual data, collaborating with various teams to maintain data...Suggested- ...Veriipro is seeking an experienced Enterprise Data Platform leader to drive transformation initiatives in the Asset Management domain. You will shape strategy and end-to-end delivery using Databricks, Azure, AWS, dbt, and modern data platforms. You will lead cross-functional...
Veriipro
Irvine, CA2 days ago $144k - $329.1k
...skill set to keep up with the ever‑growing demands of the modern data platform. During implementation you will solve complex... ...quality solutions. Your responsibilities will include: As Data Architect – Senior Manager, you will have an expert understanding of data...Summer holidayFlexible hoursEY
Irvine, CA2 days ago- ...Preferre d: Experience wit h dbt, Python, Airflow, APIs, CI/CD, Snowflake security/governance, and modern data architecture . Job Description : Looking for a Data Architect with strong experience in Snowflake and a background in t he Retail & Apparel industry . Design and...
Apexsync Technologies
Anaheim, CA2 days ago $129k - $171k
...designed, built and sold. Anduril’s family of systems is powered by Lattice OS, an AI-powered operating system that turns thousands of data streams into a realtime, 3D command and control center. As the world enters an era of strategic competition, Anduril is committed to...Full timeWork experience placementImmediate start- ...Data Engineering Lead/ArchitectWe are seeking a highly skilled and experienced Data Engineering Lead/Architect to join our dynamic team. The ideal candidate will have a proven track record of designing, building, and maintaining scalable data pipelines, with strong expertise...Remote work
Innowhyte Inc
Irvine, CA4 days ago $126k - $214k
...Principal Data ArchitectFull-time Remote Exclusive confidential search — details shared with qualified applicants.Become a Key Player... ...classifications, and SLAs; integrate it with tooling.Architect and drive lakehouse strategy (medallion bronze/silver/gold Delta...Remote workNextDeavor
Irvine, CA2 days ago$118.64k - $163.13k
...team members.Who You Are:As a Senior Database Developer - AI/ML Data Systems, you will be a senior member of our database... ...organization. In this role, you will collaborate with stakeholders, architects, data scientists, and engineering teams to deliver scalable, efficient...Summer holidayWork at officeImmediate start- PDS Health in Irvine, CA is seeking an Architect of Business Analytics and Data Intelligence to design scalable data pipelines and data models, establish standards, and ensure data security and quality across the data platform. You will lead architecture governance, collaborate...
$146k - $183k
...Lattice OS, an AI-powered operating system that turns thousands of data streams into a realtime, 3D command and control center. As the... ...with Lattice.We are seeking highly experienced Lead Electrical Architects to play a pivotal role in defining and shaping the electrical...Permanent employmentFull timeWork experience placementImmediate start$129.3k - $172.3k
...information, please visit We DoWe are seeking a Principal Enterprise Data Quality Analyst to help build, operationalize, and mature the... ...root-cause analysis with Data Owners, Stewards, Custodians, architects, engineers, application teams, BI teams, and other domain...Full timeLocal area$112.4k - $149.8k
...technology leaders at First American—where history meets innovation, and tradition fuels transformation. As a Senior Product Analyst - Data & Integration, you'll play a critical role in shaping how customer data powers the future of our sales, marketing, service, and AI...Full timeLocal areaRemote work$105.4k - $207.8k
...helps organizations address evolving cyber threats with solutions that strengthen resilience, support compliance, and protect critical data. As part of this team, you will help clients design and implement Microsoft Purview capabilities that advance data governance,...Local areaVisa sponsorship$55.54 - $67.51 per hour
...controls, technology policies, governance standards, disaster recovery and business continuity plans, technical documentation, and data protection measures; conduct security reviews and risk assessments to reduce operational risk. ~ Facilitate collaboration between...Hourly payContract workFor contractorsCurrently hiringWork at officeImmediate startFlexible hoursCity of Fountain Valley
Fountain Valley, CA5 days ago- A data analytics firm is seeking an Entry Level Data Science and Analyst to work remotely from the U.S. Responsibilities include analyzing data, creating reports, and collaborating with teams on strategic problems. Ideal candidates will possess a Bachelor's degree and...Remote work
Jobsultant Solutions
Santa Ana, CA4 days ago $85k - $135k
...American will always strive to be a great place to work, for all. For more information, please visit We DoWe are seeking an Enterprise Data Management Analyst - Metadata Mgmt/Data Catalog to help mature enterprise data governance capabilities across metadata management,...Full timeLocal areaRemote work- ...SUMMARY: The Clinical Data Analyst is responsible for coordinating/supporting adherence to evidence-based guidelines and best practices through retroactive and/or concurrent patient reviews with analysis of findings related to regulatory requirements. He/she, in collaboration...Daily paidFull timePart time
KPC Health
Santa Ana, CA3 days ago $50 - $52 per hour
...onsite Bilingual Requirement Bilingual Korean not required but strongly preferred Education and Years of Experience Bachelor’s degree in Data Analytics, Supply Chain, Engineering, Statistics, or related field. 3+ years of experience in logistics analytics, operations...Intac Solution
Santa Ana, CA2 days ago- ...Korean Bilingual Data Analyst AO7177536 Top Skills: Python, Data Modeling, Tableau Korean/Bilingual Top 4 things to focus on: 1. Experience in logistics, distribution center, warehouse, and/or supply chain environments 2. High proficiency in MS Excel, SQL, Access, PowerPoint...
BTI Solutions
Santa Ana, CA2 days ago - ...Data AnalystThe purpose of this position is to oversee the Organization's data collection, trend analysis and reporting on outcomes measurement tools. Acts as advisor to Senior Leadership Team regarding metrics data management. Coordinates and provides training reporting...Work at office
Goodwill of Orange County
Santa Ana, CA2 days ago - EY in California is seeking a professional to lead initiatives in the Power & Utilities sector. You will manage complex projects, drive improvements, and serve as a trusted advisor to clients. With a foundation in technology consulting, you will build your career in a dynamic...Flexible hours
- PIMCO is seeking a Data Strategy Lead for our Portfolio Management business to join in Newport Beach (preferred) or NYC office. You will shape the technical vision for data management and production that underpins research, analytics tools, dashboards and decision support...Work at office
$153.6k - $207.8k
...teams as a technical leader and perform hands-on development of Data & Analytics solutions with exceptional quality.Possessing a... ...and services, as a Delivery Consultant you will be proficient in architecting complex, scalable, and secure solutions tailored to meet the specific...Local areaFlexible hours- ...Description:This role serves as the technical counterpart to the Data Steward, Director, and is responsible for the assessment and... ...direction of technology to meet system requirements. The Data Lead/Architect designs and develops IT architecture (integrated process,...Full timeFlexible hours
$120.2k - $140k
...Are you an experienced, passionate pioneer in technology who wants to work in a collaborative environment? As an experienced Clinical Data AMS Senior Consultant you will have the ability to share new ideas and collaborate on projects as a consultant without the extensive...Permanent employmentLocal areaRemote workVisa sponsorship$116.2k - $229.1k
Position Summary Dayforce Integration Data Management - Senior ConsultantOur Human Capital practice is at the forefront of transforming the nature of work. As converging forces reshape industries, our team uniquely addresses the complexities of work, workforce,...Local areaVisa sponsorship
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Architect. Be the first to apply!
Related searches
- data loss prevention analyst Fountain Valley, CA
- data collection Fountain Valley, CA
- data technician Fountain Valley, CA
- data visualization Fountain Valley, CA
- test data management Fountain Valley, CA
- clinical data Fountain Valley, CA
- data tech Fountain Valley, CA
- data Fountain Valley, CA
- data modeling Fountain Valley, CA
- data collection researcher Fountain Valley, CA