Data Engineer: Cloud ETL Pipelines & SQL Automation

AARATECH; New York (NY); Hybrid; USD 70,000 - 80,000; Full time

Job summary

Aaratech Inc. is seeking a Data Engineer to help build and maintain data pipelines on cloud platforms.

You will develop ETL/ELT workflows, bring data together from multiple systems, and help keep the data that powers reporting and analytics accurate and reliable. You will build and maintain ETL/ELT pipelines using tools like Azure Data Factory, SSIS, or AWS Glue; pull data from databases, files, and APIs; write SQL and Python to transform data; monitor pipelines and collaborate with analysts to

Qualifications

• Bachelor's degree in Computer Science, IT, or a related field — or equivalent hands‑on experience.
• 2+ years working with data — ETL development, data integration, SQL development, or database work all count.
• Good SQL skills: comfortable with joins, aggregations, and writing queries against real-world data.
• Experience with at least one ETL tool (Azure Data Factory, SSIS, Informatica, Talend, or similar).
• Basic familiarity with data warehouse concepts (tables, schemas, fact/dimension basics).
• Some Python scripting exposure, or a strong desire to learn it.
• Clear communicator and reliable problem-solver.

Responsibilities

• Build and maintain ETL/ELT data pipelines using tools such as Azure Data Factory, SSIS, or AWS Glue.
• Pull data together from multiple sources — databases, files, APIs — into clean, usable datasets.
• Write SQL to transform, join, and validate data.
• Use Python scripts to automate routine data tasks.
• Monitor pipelines and help troubleshoot issues when data does not land as expected.
• Work with analysts and business teams to understand what data they need and deliver it.
• Document your pipelines so others can understand and maintain them.

Skills

SQL development

Python scripting

Data pipeline design

Communication

Education

Bachelor's degree in CS/IT or equivalent

Tools

Azure Data Factory

SSIS

Informatica

Talend

Power BI

Tableau

Job description

Aaratech Inc. is seeking a Data Engineer to help build and maintain data pipelines on cloud platforms.

You will develop ETL/ELT workflows, bring data together from multiple systems, and help keep the data that powers reporting and analytics accurate and reliable. You will build and maintain ETL/ELT pipelines using tools like Azure Data Factory, SSIS, or AWS Glue; pull data from databases, files, and APIs; write SQL and Python to transform data; monitor pipelines and collaborate with analysts to