Data Engineer

Introduction

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 critical database systems (Oracle + PostgreSQL), while designing and implementing robust data integration solutions that support groundbreaking cancer research.

Responsibilities

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.

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 (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.

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.