> Markdown version of [/jobs/ext/2218270-data-architect](https://www.wearedevelopers.com/jobs/ext/2218270-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Architect - **Company:** S&K GLOBAL SOLUTIONS LLC - **Location:** Fountain Valley, CA, United States - **Contract:** Temporary contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Airflow, Amazon S3, Unix, Cloud Database, Code Generation, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Mapping, Data Warehousing, IBM DB2, JSON, Python (Programming Language), PostgreSQL, Machine Learning, Microsoft SQL Server, MongoDB, Oracle (Applications), Performance Tuning, Systems Development Life Cycle, PL-SQL, SQL Databases, Extensible Markup Language (XML), Enterprise Data Management, Data Processing, Informatica Powercenter, Large Language Models, Snowflake, Generative AI, Git, AWS Data Analytics, Machine Learning Operations, Cloud Migration, Functional Programming, Data Pipelines, Databricks - **Published:** August 25, 2026 - **Apply:** https://www.dice.com/job-detail/706d59d1-8ee1-4969-8c5d-956dba631e30 ## About the Role 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. ## Description * 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. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security) - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How to Become an AI Engineer](https://www.wearedevelopers.com/magazine/331-how-to-become-an-ai-engineer) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Graph and AI Trends 2026: Why Is AI Running but Not Yet Delivering?](https://www.wearedevelopers.com/magazine/680-graph-and-ai-trends-2026-why-is-ai-running-but-not-yet-delivering) - [What Industries Outside of AI Are Hiring The Most AI Experts?](https://www.wearedevelopers.com/magazine/98-what-industries-outside-of-ai-are-hiring-the-most-ai-experts)