Essential Functions of the job:
· 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.
· Assemble 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