Principal Clinical Datawarehouse Programmer

• Work with business/project owners understanding business requirements.
• In-depth understanding of clinical trials and their associated deliverables.
• Design ETL data pipelines specifications following SDLC process.
• Design, develop, test, and deploy ETL data pipelines.
• Design, develop, test, and deploy Validation Checks.
• Design, develop, test, and deploy Data Models.
• Maintain ETL data pipelines and enforce data governance, security, and protection of our data.
• Troubleshooting ETL data pipelines and debugging faulty code.
• Monitoring and improving ETL data pipelines performance.
• Testing data outputs to ensure that they are fit for use.
• Assembly of large, complex data sets that meet business requirements.
• Preparing data outputs for manipulation by downstream applications/users.
• Design and build the infrastructure if required for optimal ETL data pipelines from a wide variety of data sources using SQL and other technologies (like R or Python).
• Support the build analytics tools that utilize the data to provide actionable insights into operational efficiency, and other key business performance metrics.
• Work with internal and external stakeholders to assist with data-related technical issues and support data needs.
• Ability to work in a dynamic environment.
• Perform other duties as directed by Director, Clinical Data Architect.

Requirements

• 5+ years’ experience with ETL data pipelines
• 5+ years’ experience with SQL and relational databases
• 2+ years’ experience with SDLC
• 3+ years’ experience with clinical trial data in the pharmaceutical/biotechnology
• 2+ years’ experience with APIs
• Experience with CDISC SDTM, SDTMIG, and other working CDASH standards a plus
• 3+ Years’ Experience with Oracle Life Science Data Hub (LSH)
• 3+ Years’ Experience with Oracle Data Management Workbench (DMW)
• 3+ Years’ Experience with Oracle Clinical Data Analytics (CDA)
• 3+ Years’ Experience with Oracle Clinical Data Analytics (ODI)
• Experience with Oracle Business Intelligence Enterprise Edition (OBIEE)
• Experience with BI platform (Spotfire, PowerBI, and etc.) a plus