Theradex OncologyRemote
Data Engineer
United States of America
Full Time
1 hour ago
$130,000 - $160,000 USD
No H1B
Key skills
Oracle Database AdministrationPostgreSQLAWS RDSSQLPL/SQLShell ScriptingPythonTalendPower AutomateETL MethodologiesData WarehousingCloud MigrationApplication ModernizationLegacy System DecommissioningShellETLData LakeAWSRDSOracleSDLCChange Management
About this role
Theradex Oncology is a full-service CRO specializing in oncology, managing global oncology trials and programs. The Data Engineer will manage and maintain critical database systems while designing and implementing robust data integration solutions to support groundbreaking cancer research.
Responsibilities:
- 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
- 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
- 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
- Limited travel. Willingness to come to Princeton office as needed
- AWS certification preferred
- Prior experience in a CRO/pharmaceutical or highly regulated industry environment preferred