On-Site Oracle SQL Lead - Daily 7am Data Pipelines

Liberty Personnel Services, Inc.; Philadelphia (Philadelphia County); On-site; USD 120,000 - 180,000; Full time

Job summary

Liberty Personnel Services, Inc. is seeking a Database Lead in Philadelphia to own the Oracle SQL pipelines powering daily trading data. You’ll transform inbound cash position files into clean, reliable data for downstream systems and troubleshoot issues before the market opens.

You’ll own end-to-end data workflows with an on-site, early-morning cadence around 7am, collaborating with middle-office and technology partners to ensure accuracy, performance, and timely delivery every morning.

Qualifications

• Strong, hands-on experience with Oracle SQL.
• Experience in data transformation, file ingestion/ETL, or reconciliation.
• Comfort with an early-morning schedule (start around 7am).
• Ability to work calmly under time pressure.
• Local to the Bala Cynwyd/Philadelphia area and on-site availability.
• Familiarity with middle-office or operations-critical data processes is a plus.

Responsibilities

• Ingest daily inbound cash position files.
• Validate incoming data to catch issues early.
• Transform raw inputs into structured data for downstream systems.
• Develop and maintain Oracle SQL processes that drive daily workflows.
• Optimize Oracle SQL code for speed, reliability, and clarity.
• Troubleshoot data quality and file format problems in real time.
• Perform reconciliation to ensure accuracy of positions.
• Collaborate with middle-office and technology partners to resolve exceptions quickly.
• Document procedures and support continuous improvement of data pipelines.

Skills

Oracle SQL

Data transformation

ETL workflows

Data reconciliation

Python

Early-morning schedule

On-site work

Job description

Liberty Personnel Services, Inc. is seeking a Database Lead in Philadelphia to own the Oracle SQL pipelines powering daily trading data. You’ll transform inbound cash position files into clean, reliable data for downstream systems and troubleshoot issues before the market opens.

You’ll own end-to-end data workflows with an on-site, early-morning cadence around 7am, collaborating with middle-office and technology partners to ensure accuracy, performance, and timely delivery every morning.