Data Engineering Architect
Bright Mind Solutions 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 Engineering Architect in Fountain Valley, CA vacancy
$166k - $220k
...Lattice OS, an AI-powered operating system that turns thousands of data streams into a realtime, 3D command and control center. As the... ...to the military in months, not years.ABOUT THE TEAMAs a Data Engineer on the Analytics Team, you will be collaborating with stakeholders...SuggestedFull timeWork experience placementImmediate startShift work$76.73k - $127.88k
...Are you an experienced, passionate pioneer in technology who wants to work in a collaborative environment? As an experienced Data Engineer, you will have the ability to share new ideas and collaborate on projects as a consultant without the extensive demands of travel...SuggestedLocal areaVisa sponsorship$116.2k - $229.1k
Position Summary Join Deloitte’s AI & Engineering practice and help organizations... ...enterprise technology platforms, modernize data environments, and unlock value through innovation... ...and develop teams of data engineers and architects, fostering technical growth and...SuggestedLocal areaVisa sponsorship- ...technical specifications, and a solid understanding of healthcare data structures and workflows. Key Responsibilities: Reporting &... ...mapping, data validation, and quality reviews. Collaborate with data engineering teams to ensure data pipelines are aligned with reporting needs...Suggested
Acuity Eye Group
Santa Ana, CA9 hours ago $146k
...Anduril Industries, based in Costa Mesa, California, is seeking a Data Engineer to build and maintain data ingestion pipelines and analytical tools. With a focus on innovation, the successful candidate will work on transforming telemetry and test records into actionable...SuggestedAnduril Industries
Costa Mesa, CA4 days ago- ...Big Data EngineerLocation: Costa Mesa, CA or Allen, TXDuration: FulltimeJob Description: Big Data EngineerMust Have Technical/Functional Skills: Big Data, PySpark, AWS (EMR, SageMaker, DunamoDB)Roles & Responsibilities:Strong hands-on experience with AWS Cloud Services...Immediate startRelocation
JConnect Infotech
Costa Mesa, CA8 hours ago $166k - $220k
...operating system that turns thousands of data streams into a realtime, 3D command and control... ...ABOUT THE JOBAs a Senior Data Protection Engineer on our Classified Systems team, you'll... ...matters, gives you a blank canvas to architect from, and the mandate to see it through to...Full timeFor contractorsWork experience placementImmediate startRemote work$112k - $149k
...Lattice OS, an AI-powered operating system that turns thousands of data streams into a realtime, 3D command and control center. As the... ..., not years.ABOUT THE TEAMAnduril is seeking a Product Data Engineer to join our Configuration Management team. As a Product Data Engineer...Full timeWork experience placementImmediate start$86.1k - $115k
...Associate Data EngineerAs our Data Engineer, you will function as a consultant between our technology unit and other business units to understand their challenges. You'll ask questions and present ideas that enable them to solve those data problems with code. Our team...Full timeWork at officeLocal areaRemote work3 days per weekAAA
Costa Mesa, CA3 days ago- Compunnel, Inc. is seeking a Big Data Engineer responsible for designing and implementing scalable platforms within AWS. The role demands strong expertise in technologies including Spark, Hadoop, Scala, and Java, focusing on processing large datasets and building data pipelines...
- Anduril Industries, based in Costa Mesa, California, is looking for a Data Engineer to join their People Data & Analytics team. This role involves designing, building, and optimizing data pipelines to enhance decision-making through strategic insights from HR data. The...
- ...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...Contract work
$160.8k - $241.2k
...will influence architectures, systems, and product selections for data center applications. You will work hands‑on with customers... ...qualifications would make you successful?Degree in Electrical or Mechanical Engineering; advanced degree preferred10+ years in technical roles within...Ongoing contractFull timeTemporary workImmediate startFlexible hours$105.4k - $207.8k
...Innovation & Delivery Transformation (I&DT) practice. I&DT applies an engineering- and innovation-led mindset to how Deloitte builds, delivers,... ...'s product and engineering teams. Together, you'll build out Data Studio's agentic use cases — starting from Deloitte's agentic...Local area- Snowflake DBT Data Engineer Location Irvine CA 5 Day onsite Required technical skills for DBT Snowflake roleDevelop DBT Projects Build maintain and manage the endtoend DBT project ensuring modularity reusability and adherence to established data standardsAdvanced SQL Jinja...
$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...Full time- Anduril Industries in California seeks a Senior Materials and Process Engineer to define design allowables and lead a data-driven materials program across an expansive defense portfolio. You will establish standards for data capture, govern material qualification, and...
$134.5k - $265.1k
...combining Deloitte's sports industry experience with proprietary data, AI-native decision intelligence, and reusable Converge... ...organizations. The team works across Product Management, Data Engineering, Data Science, Software Engineering, Forward Deployed Engineering...Local area$105.4k - $207.8k
...organizational risk profiles of leading companies? Do you want to build the data foundations that power the next generation of AI-enabled cyber... ...could be the place for you.We are looking for a hands-on Data Engineer to build and operate the governed data foundations powering...Local areaVisa sponsorship- Job Role : L3 Support IDMC (Informatica Intelligent Data Management)Job Location : Irvine,CaliforniaJob description : Provide L2 L3 production support for Informatica MDM platformMaintain high availability of MDM CDIPC and associated integrationsPerform root cause analysis...
$166k - $220k
...Lattice OS, an AI-powered operating system that turns thousands of data streams into a realtime, 3D command and control center. As the... ...for our data platformPartner with operations, product, and engineering to advocate best practices and build supporting systems and infrastructure...Full timeWork experience placementImmediate startShift work$146k - $194k
...Lattice OS, an AI-powered operating system that turns thousands of data streams into a realtime, 3D command and control center. As the... ...to the cloud, how it's modeled, and how it reaches the engineers, managers, and leaders who act on it.We're a new team within the...Full timeWork experience placementImmediate start$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...$130k - $150k
...Don't hesitate, come and join us! About this opportunity – Sr Data & AI Engineer - ON-SITE: IRVINE, CA Description The Data & AI Engineer at... ..., particularly in the US. The Data & AI Engineer will help architect, build, and optimize data solutions for various business departments...Work at officeRemote workBalt USA
Irvine, CA4 days ago- ...Balt Group in Irvine, CA is seeking a Sr Data & AI Engineer to build and optimize data solutions that support the US growth strategy. The role focuses on data collection, governance, and AI-enabled analytics within Snowflake and Tableau ecosystems. On-site position requiring...
Balt Brasil
Irvine, CA4 days ago - ...Megazone Cloud US is seeking a Senior Data Engineer to lead and define our data-driven culture. You will architect scalable data platforms on AWS, driving data strategy with Databricks or Snowflake, and mentor engineers in Python and SQL. We value a builder mindset, startup...
MegazoneCloud US
Irvine, CA4 days ago $34.47 - $38.46 per hour
...processes Implement and maintain database security measures Ensure data security, data integrity, and data quality Monitor database... ...understand requirements and provide solutions that meet business needs Architect, develop, and manage scalable, reliable data pipelines...Hourly payFlexible hoursPizza Hut
Irvine, CA1 day ago$150k - $180k
...global performance and enable consumers to enjoy a seamless, effortless lifestyle. Key Responsibilities Develop and maintain the Big Data Platform by performing data cleansing, data warehouse modeling, and report development on large datasets. Collaborate with cross‑...Local areaWorldwideTP-Link Systems Inc.
Irvine, CA1 day ago$100k - $120k
...Department: Information Technology | Reports To: Lead Software Architect Schedule: Full-Time | Minimum 4 Days In-Office FLSA Status:... ...both in-store and online. Position Summary We are seeking a Data Engineer to join our Information Technology team. Reporting to the Lead...Full timeCasual workWork at officeAfternoon shiftWeekday workTillys
Irvine, CA3 days ago- ...About the Role: We are looking for an experienced Data Engineer to design, build, and operate the pipelines that power our Databricks-based... ..., and reusable components. Work closely with data architects and product owners to translate business requirements into data...
AspiringIT
Irvine, CA4 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Engineering Architect. Be the first to apply!
Related searches
- data Fountain Valley, CA
- health data Fountain Valley, CA
- data visualization Fountain Valley, CA
- data capturer Fountain Valley, CA
- provider data management Fountain Valley, CA
- data collection researcher Fountain Valley, CA
- data network cabling Fountain Valley, CA
- data labeling Fountain Valley, CA
- data tech Fountain Valley, CA
- data modeling Fountain Valley, CA