Data Integration Architect – Scalable AI Pipelines

association of arab universities; New York (NY); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Equity participation

Medical coverage

Vision coverage

Dental coverage

Visa sponsorship

Relocation support

Job summary

Aaru is seeking a Data Integration Specialist to build and maintain the data foundation that powers its simulations. You will design reliable pipelines to ingest, clean, and integrate large multimodal datasets from APIs, flat files, cloud storage, and data warehouses, ensuring data can be linked, queried, and trusted at scale.

This in‑person role is based in New York City, requiring 3+ years in data integration or data engineering with SQL and Python, and experience with Snowflake, BigQuery, or

Qualifications

• 3+ years of experience in data integration, data engineering, ETL/ELT, or similar roles.
• Hands-on experience with large-scale datasets (>100 TB) and building reliable systems.
• Fluency in SQL and Python, with experience across modern data infrastructure.
• Strong judgment on data quality and integration risks.

Responsibilities

• Build and maintain scalable pipelines to ingest, clean, and integrate large multimodal datasets.
• Own data ingestion across APIs, flat files, cloud storage, and data warehouses.
• Design workflows for linkage, entity resolution, deduplication, and schema harmonization.
• Collaborate with engineering, research, and deployment teams to make data usable for simulations.
• Establish and monitor data quality checks and documentation.
• Evaluate new data sources and determine how they can join with existing assets.

Skills

SQL

Python

Data integration

ETL/ELT

Large-scale datasets

Tools

Snowflake

BigQuery

Databricks

Job description

Aaru is seeking a Data Integration Specialist to build and maintain the data foundation that powers its simulations. You will design reliable pipelines to ingest, clean, and integrate large multimodal datasets from APIs, flat files, cloud storage, and data warehouses, ensuring data can be linked, queried, and trusted at scale.

This in‑person role is based in New York City, requiring 3+ years in data integration or data engineering with SQL and Python, and experience with Snowflake, BigQuery, or