Data Engineer

Theradex Oncology; Princeton (NJ); On-site; USD 130,000 - 160,000; Full time

Benefits offered by this job

Medical, dental and vision coverage

401(k) with company match

Tuition reimbursement

Flexible work schedules

Job summary

Theradex Oncology, a CRO focused on oncology trials, seeks a Data Engineer/Oracle DBA to manage databases and build robust ETL data integrations for cancer research.

Responsibilities include designing ETL pipelines, migrating databases to AWS RDS, ensuring data quality and governance in a regulated setting. Base salary ranges from $130,000–$160,000, with limited travel and Princeton office access.

Qualifications

• 7–10 years of Oracle DBA or Data Engineer experience with ETL tools.
• Deep knowledge of Oracle architecture, administration, and performance tuning.
• Proficiency in SQL and PL/SQL.
• Experience with scripting languages (Shell, Python).
• Experience with cloud database technologies (AWS RDS).
• Experience with cloud migration and legacy modernization.
• Strong data warehousing understanding.
• Experience in CRO/pharma or regulated industry preferred.

Responsibilities

• Install, configure, and maintain database instances across environments.
• Perform upgrades, patching, migrations, and backups.
• Monitor performance, ensure security, and implement recovery strategies.
• Automate DBA tasks using SQL, PL/SQL, and shell scripts.
• Plan migrations to AWS RDS for Oracle.
• Design, develop, and maintain ETL processes for data integration.
• Develop data pipelines with Talend, SQL Scripts, and Power Automate.
• Ensure SDLC, validation, governance, and audit documentation.
• Identify data quality improvements and reduce technical debt.
• Create architecture and data lineage artifacts.

Skills

Oracle DBA

Data Engineer

SQL

PL/SQL

Python

Shell scripting

ETL methodologies

Data warehousing

AWS RDS

Cloud migration

Education

Bachelor’s degree in Computer Science/Information Systems

AWS certification preferred

Tools

Talend

Power Automate

SQL Scripts

Job description

Who We Are

Celebrating 40+ years!

Theradex Oncology is a full-service CRO specializing in oncology. The company manages global oncology trials and programs. The company was founded in 1982 working with the National Cancer Institute, which led to its expansion to working with industry sponsors developing cancer therapeutics. As a service-based company we support both domestic and international sponsors in the conduct of both early and late phase trials.

What You'll Do

As part of Theradex Oncology, you will have the opportunity to work with one of the largest professional teams focused solely on the development of cancer therapies. Cancer research continues to evolve as new therapies and therapeutic approaches are discovered, as part of the team you will work to support our sponsors in the development of these therapies. Theradex Oncology is an environment for highly motivated individuals who want to make a difference.

The Data Engineer will be responsible for management and maintenance of our critical database systems (Oracle + PostgreSQL), while designing and implementing robust data integration solutions that support groundbreaking cancer research.

The primary responsibilities of this position include, but is not limited to, the following:

DBA:

• Install, configure, and maintain database instances across development, testing, production, on-prem, and AWS cloud environments.
• Perform database upgrades, patching, migrations.
• Monitor performance and proactively resolve bottlenecks; implement security measures, develop and implement backup/recovery strategies, and troubleshoot issues for application development teams.
• Automate routine DBA tasks using scripting languages (SQL, PL/SQL, Shell scripting) and stay current with database technologies and best practices.
• Participate in the planning and execution of database migrations from on-premises environments to AWS RDS for Oracle.

Data Engineer with ETL:

• Design, develop, and implement ETL processes to extract data from various sources, transform it according to business requirements, and load it into target systems (e.g., data warehouse, data lake).
• Develop and maintain data pipelines using ETL tools (e.g., Talend, SQL Scripts, Power Automate, etc.).
• Optimize ETL processes for performance and scalability.
• Perform data profiling and data quality analysis to ensure data accuracy and consistency.
• Collaborate with business analysts and data scientists to understand data requirements and translate them into technical specifications.
• Implement data governance and data quality rules within ETL processes.
• Develop and maintain system architecture diagrams, data flow diagrams, integration diagrams, technical design documentation, source-to-target mappings, and data lineage artifacts to support data platforms and integrations.
• Ensure solutions are developed and maintained in accordance with SDLC, validation, change management, security, data governance, and quality standards, including maintenance of audit-ready documentation and traceability requirements.
• Identify opportunities to improve data quality, reduce technical debt, streamline integrations, and simplify data architecture across enterprise systems.

What You Need

Education & Certification

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• AWS certification preferred

Prior Experience

• 7-10 years of prior experience as an Oracle DBA or Data Engineer with ETL tools (e.g, Talend, SQL Scripts, Power Automate, etc.)

• Demonstrates deep understanding of Oracle database architecture, administration, and performance tuning, combined with expertise in ETL methodologies and tools.

• Proficient in SQL and PL/SQL

• Experience with scripting languages (e.g., Shell scripting, Python).

• Experience with cloud database technologies (AWS RDS preferably)

• Experience with cloud migration, application modernization, and legacy system decommissioning initiatives.

• Strong understanding of data warehousing concepts and methodologies.

• Prior experience in a CRO/pharmaceutical or highly regulated industry environment preferred

AdditionalRequirements

• Limited travel. Willingness to come to Princeton office as needed.

What We Offer

At Theradex we offer a supportive culture that puts people first. Our employees are eligible to participate in our comprehensive benefits package which includes medical, dental and vision coverage; life insurance, disability insurance (STD/LTD), company matched 401(k), very competitive tuition reimbursement, generous vacation/sick plans, flexible work schedules, employee discounts and other company provided benefits. The annual base salary for this position ranges from $130,000 - $160,000. The actual salary offer will be based on a number of factors, including but not limited to the candidate’s qualifications, experience, skills, and competencies for the role.

This position is not eligible for relocation or company provided sponsorship.

Theradex is an Equal Opportunity Employer.