Data Architect

S&K GLOBAL SOLUTIONS LLC

Fountain Valley, CA, United States

2 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

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)

+28 more

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

Job 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.

Requirements

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.