Senior SQL / Data Engineer

HW3; New York (NY); On-site; USD 117,000 - 193,000; Full time

Job summary

Hw3 Llc in New York City is seeking a Senior SQL / Data Engineer to support financial data integration, database development, and enterprise accounting systems on a 5-days-on-site contract.

The role focuses on ETL/ELT pipelines, advanced SQL (Oracle PL/SQL), and data reconciliation, with Python and Unix/Linux scripting for automation. On-site NYC work is required and C2C is not accepted. Banking or financial services experience is preferred; Snowflake and OIC experience are a plus.

Qualifications

• 8+ years of hands-on software or data engineering experience.
• Advanced SQL and Oracle PL/SQL development.
• Oracle Financials experience (GL, SLA, or FAH).
• Python and Unix/Linux shell scripting experience.
• Experience with financial data reconciliation, production support, and troubleshooting.
• Ability to work 5 days on-site in NYC.

Responsibilities

• Design, develop, and maintain ETL/ELT data pipelines supporting financial transactions.
• Write and optimize complex SQL queries, PL/SQL procedures, and data transformations.
• Integrate financial data between source systems and accounting platforms.
• Perform data reconciliation, validation, and quality checks.
• Troubleshoot production issues and automate workflows using Python and Unix/Linux scripting.

Skills

Advanced SQL

Oracle PL/SQL

Python

Unix/Linux

Data integration

Tools

Snowflake

Oracle Integration Cloud (OIC)

Control-M

Job description

Location: New York City | 5 Days On-Site

Employment Type: Contract | Potential Extension or Conversion

We are seeking an experienced Senior SQL / Data Engineer to support financial data integration, database development, and enterprise accounting systems for an established financial services organization.

This is a W2 contract opportunity only. C2C (Corp-to-Corp) arrangements are not accepted.

Key Responsibilities

• Design, develop, and maintain ETL/ELT data pipelines supporting financial transactions.
• Write and optimize complex SQL queries, PL/SQL procedures, and data transformations.
• Integrate financial data between source systems and accounting platforms.
• Perform data reconciliation, validation, and quality checks.
• Troubleshoot production issues and automate workflows using Python and Unix/Linux scripting.

Must-Have Requirements

• 8+ years of hands-on software or data engineering experience.
• Advanced SQL and Oracle PL/SQL development.
• Oracle Financials experience (GL, SLA, or FAH).
• Python and Unix/Linux shell scripting experience.
• Experience with financial data reconciliation, production support, and troubleshooting.
• Ability to work 5 days on-site in NYC.

Preferred

• Banking or financial services experience.
• Snowflake, Oracle Integration Cloud (OIC), or Control-M experience.