Data Integration Engineer - SQL, Python & ADF

Zohorecruit; Jersey City (NJ); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Axiom Path is assisting a global financial institution in Jersey City with a data integration role focused on ETL development and QA for compliance analytics. You will collaborate with data developers, analysts, and engineers to deliver reliable data solutions and robust validation across the data lifecycle.

The role emphasizes SQL proficiency, Python scripting, and experience with Azure Data Factory in a hybrid work setup.

Qualifications

• Strong hands-on SQL skills, including complex queries, joins, transformations, troubleshooting, and performance tuning.
• Experience developing scripts or data-processing workflows with Python.
• Practical experience with Azure Data Factory or another enterprise ETL platform.
• Knowledge of data warehousing concepts, dimensional modeling, and structured data delivery.
• Demonstrated ability to test and validate data pipelines, transformation logic, and downstream outputs.
• Experience investigating data discrepancies and performing source-to-target reconciliation.

Responsibilities

• Develop scripts, processes, and tools that ingest, transform, validate, and deliver data for analytics and reporting.
• Write efficient SQL queries, stored procedures, and data transformation logic.
• Design and maintain ETL pipelines using Python, Azure Data Factory, or comparable data integration tools.
• Automate recurring data workflows to improve reliability and reduce manual processing.
• Perform development-level quality assurance, including data reconciliation, defect identification, and regression testing.
• Monitor and improve data quality, completeness, consistency, and accuracy.
• Troubleshoot data pipeline issues and optimize SQL queries and ETL processes for performance.
• Partner with business analysts, data analysts, and developers to translate reporting requirements into reliable technical solutions.
• Document data workflows, validation rules, dependencies, and technical processes.

Skills

SQL

Python

Azure Data Factory

Data warehousing

ETL

QA testing

Data reconciliation

Collaboration

Job description

Axiom Path is assisting a global financial institution in Jersey City with a data integration role focused on ETL development and QA for compliance analytics. You will collaborate with data developers, analysts, and engineers to deliver reliable data solutions and robust validation across the data lifecycle.

The role emphasizes SQL proficiency, Python scripting, and experience with Azure Data Factory in a hybrid work setup.