Data Architect

Softek; Piscataway Township (NJ); On-site; USD 140,000 - 220,000; Full time

Job summary

Softek seeks an experienced data architect/engineer to design AI-ready data architectures for large-scale analytics. You will architect unified schemas, metadata standards, and governed data models while implementing Delta Lake, Lakehouse patterns, and ETL/ELT pipelines on Databricks.

The role emphasizes AWS-native designs (S3/IAM/KMS/Lambda/Glue) and data governance across streaming and API data exchanges.

Qualifications

• 12+ years of experience in enterprise data architecture, data engineering, or advanced database design supporting large-scale analytics environments.
• Proven experience designing AI-ready data architectures, including unified schemas, metadata standards, governed data models, and scalable data structures.
• Hands-on experience with Databricks architecture, including Delta Lake, Unity Catalog, Lakehouse architecture, and ETL/ELT pipelines.
• Strong experience designing cloud-native AWS architectures using services such as S3, IAM, KMS, Lambda, Glue, API Gateway, RDS, or Aurora.
• Demonstrated experience implementing data governance, including data lineage, metadata standardization, semantic models, ontologies, compliance, and data-quality practices.
• Experience supporting streaming data ingestion, microservices integration, and API-based data exchange.
• Experience working in Agile environments, preferably within Federal Government or large enterprise organizations.
• Possession of both required certifications, with the ability to provide valid certification documentation upon request.
• Prior experience supporting Federal data modernization or transformation programs.

Skills

Data architecture

Data engineering

Advanced database design

AI-ready data architecture

Unified schemas

Metadata standards

Governed data models

Scalable data structures

Data governance

Data lineage

Semantic models

Ontologies

Compliance

Data quality

Streaming data ingestion

Microservices integration

API-based data exchange

Agile environments

Federal data modernization

Certifications

Tools

Databricks

Delta Lake

Unity Catalog

Lakehouse

ETL/ELT pipelines

AWS

S3

IAM

KMS

Lambda

Glue

API Gateway

RDS

Aurora

Job description

• 12+ years of experience in enterprise data architecture, data engineering, or advanced database design supporting large-scale analytics environments.
• Proven experience designing AI-ready data architectures , including unified schemas, metadata standards, governed data models, and scalable data structures.
• Hands-on experience with Databricks architecture , including Delta Lake, Unity Catalog, Lakehouse architecture, and ETL/ELT pipelines.
• Strong experience designing cloud-native AWS architectures using services such as S3, IAM, KMS, Lambda, Glue, API Gateway, RDS, or Aurora.
• Demonstrated experience implementing data governance , including data lineage, metadata standardization, semantic models, ontologies, compliance, and data-quality practices.
• Experience supporting streaming data ingestion, microservices integration, and API-based data exchange .
• Experience working in Agile environments , preferably within Federal Government or large enterprise organizations.
• Possession of both required certifications , with the ability to provide valid certification documentation upon request.
• Prior experience supporting Federal data modernization or transformation programs .