Data Engineer

Theradex Oncology offers a collaborative, data driven culture focused on advancing cancer research. As a full service CRO with over 40 years of experience, we support global oncology trials and work with sponsors across early and late phase programs. This onsite Data Engineer role in Princeton, NJ combines hands on database administration with robust data integration and ETL design to empower researchers. The compensation range is USD 130,000 to 160,000 per year, complemented by a comprehensive benefits package that supports work-life balance and professional growth.

Benefits

• Medical, dental and vision coverage
• Life insurance
• Disability insurance (STD/LTD)
• 401(k) with company match
• Tuition reimbursement
• Generous vacation and sick leave
• Flexible work schedules
• Employee discounts
• Other company provided benefits

Responsibilities

• Install, configure, and maintain database instances across development, testing, production, on prem and AWS cloud environments.
• Perform database upgrades, patches, and migrations to keep systems current.
• Monitor performance, resolve bottlenecks, implement security measures, and design backup and recovery strategies; troubleshoot issues for application development teams.
• Automate routine DBA tasks using SQL, PL/SQL, and shell scripting; stay current with database technologies and industry best practices.
• Plan and execute migrations from on premises to AWS RDS for Oracle as part of cloud modernization efforts.
• Design, develop, and deploy ETL processes to extract data from diverse sources, transform it to meet business rules, and load into target systems such as data warehouses or data lakes.
• Build and maintain data pipelines using ETL tools and scripts (Talend, SQL Scripts, Power Automate, etc.).
• Optimize ETL processes for performance and scalability.
• Conduct data profiling and quality analyses to ensure accuracy and consistency.
• Collaborate with business analysts and data scientists to translate data needs into technical specifications.
• Implement data governance and data quality rules within ETL workflows.
• Develop and maintain architecture diagrams, data flow diagrams, integration diagrams, technical design documents, source-to-target mappings, and data lineage artifacts to support data platforms and integrations.
• Ensure solutions adhere to SDLC, validation, change management, security, data governance, and quality standards, including audit-ready documentation and traceability.
• Identify opportunities to improve data quality, reduce technical debt, streamline integrations, and simplify data architecture across enterprise systems.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• AWS certification preferred
• 7-10 years of prior experience as an Oracle DBA or Data Engineer with ETL tools (Talend, SQL Scripts, Power Automate, etc.)
• Deep understanding of Oracle database architecture, administration, and performance tuning, with expertise in ETL methodologies and tools.
• Proficient in SQL and PL/SQL
• Experience with scripting languages such as Shell scripting and Python
• Experience with cloud database technologies, preferably AWS RDS
• 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 environment is preferred

Technologies

• Oracle
• PostgreSQL
• AWS RDS
• SQL
• PL/SQL
• Shell scripting
• Python
• Talend
• Power Automate

Who we are

Theradex Oncology is a full service CRO focused on oncology. Celebrating 40 plus years, the company manages global oncology trials and programs. Founded in 1982 with early collaborations for the National Cancer Institute, Theradex Oncology expanded to work with industry sponsors developing cancer therapeutics. As a service based organization, we support both domestic and international sponsors in conducting both early and late phase trials.