Lead Data Engineer
COL - Cundinamarca - Bogotá (Colpatria)
MSD
At MSD, we're following the science to tackle some of the world's greatest health threats. Get a glimpse of how we work to improve lives.Job Description
Activities may include, but are not limited to:
- Creates and develops clinical databases and data transfer files according to written specifications.
- Leads and participates in the review of electronic case report forms (eCRF) and edit checks, database development, programming of edit checks, and scripts to aid in transfer of electronic data files into the Clinical Data Management System (CDMS).
- Interface with members of study teams, including external CROs/Vendors where applicable, to integrate study team requirements into all deliverables.
- Responsible for all data mapping deliverables including SDTM structure set-up and transformation maps to support multiple clinical programs.
- Creates and develops mapping specifications to meet SDTM structure requirements utilizing E2E visibility tools to ensure quality and timeliness of data flow.
- Leads and participates in developing transformation logic, and scripts to aid in the flow of data downstream for Analysis and Reporting.
- Responsible for reporting deliverables supporting data cleaning and verification and any external data captured in clinical studies.
- Coordinates data reporting activities for multiple clinical programs.
- Creates and reviews reporting specifications to ensure high quality deliverables, meet SDTM structure requirements and the needs of the business.
- Leads and participates in the review of standard and template reports, and scripts to aid in the review of data to ensure a quality database.
- Assumes the responsibilities for all database Archiving and Decommissioning activities in support of multiple clinical programs.
- Rendering of PDFs utilizing the approved tools via Electronic Data Capture for archiving data.
- Generation of Final Subject PDFs for site Archival package, and creation of the subjects needed for Item 12 submission requests.
- Decommissioning of trials from the production servers via AWS.
- Ensuring PDFs are filed in official repository (i.e., Veeva Vault) TMF.
Coordinates and participates in the following activities:
- Develop required training and provide ongoing training and development to Developers on standards and Study Build, transformations, mapping, reporting and Archival Process.
- Interfaces with functional manager to assure consistency of technical and process strategies across all therapy areas.
- Plans appropriately to ensure adherence to timelines.
- Acts as a technical resource to a functional group.
- Interface with members of study teams and key stakeholders, to integrate requirements into all deliverables.
- Ensures adherence to clinical database standards, SDTM structures, SOPs, and Process Guidelines.
- Trains new hires and participates in the interview process.
- Helps to develop a customer oriented and can-do attitude on a team and contributes as subject matter expert for trouble-shooting findings.
- Leads and participates in activities including, but not limited to, task forces, testing of new systems and helps coordinate technical initiatives.
- Contributes strategies, innovative and creative solutions to enhance processes and increase productivity of a group.
- Assist Manager/Associate Director in project planning, manpower projections and resource allocations across therapy areas.
B.A. or B.S. degree, preferably in mathematics, science, a healthcare-related discipline, or computer science; or relevant skills and experience.
- Knowledge of database structures and available tools to manage, extract, report, and warehouse data.
- Minimum 4 years of database development or data programming experience, at least three of which including clinical databases.
- Demonstrated strong technical proficiency in a Clinical Data Management Systems (i.e., InForm, Inform Architect, Central Designer, SQL-PL/SQL
- Minimum 4 years of experience with
CDISC Standards, (SDTM, CDASH, Define.xml)
XML, Java
ELT tools - 3+ years’ experience in data transformations and data loading in tools such as InForm
- 2+ years’ experience in System Development Lifecycle Management / system validation knowledge.
- 3+ years’ experience with reporting tools such as Cognos or JReview.
- Experience in eCRF generation for site documentation and downstream regulatory compliance deliverables.
- Advanced knowledge of the Data Management process from study start-up through close-out.
- Ability to collaborate and communicate with cross functional stakeholders to interpret and ensure quality report specifications and input to report development.
- Solid knowledge of MS Windows/Office software and exposure to web-based applications.
- Effective communication skills (oral and written) with the ability to communicate with both the technical and business areas.
- Strong organizational and critical thinking skills.
- Keen sense of urgency and customer focus.
- Ability to work cross functionally and as part of a team.
- Able to work independently, under pressure and change environment with flexibility.
- An overall working knowledge of drug discovery process, FDA regulations, GxP guidelines, ICH guidelines, clinical database validation and documentation processes, and 21 CFR Part 11.
Current Employees apply HERE
Current Contingent Workers apply HERE
Search Firm Representatives Please Read Carefully
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.
Employee Status:
RegularRelocation:
VISA Sponsorship:
Travel Requirements:
Flexible Work Arrangements:
HybridShift:
Valid Driving License:
Hazardous Material(s):
Job Posting End Date:
07/19/2024*A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: AWS Computer Science Data management Drug discovery ELT Java Mathematics SQL Testing XML
Perks/benefits: Flex hours Relocation support Startup environment
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Research Scientist jobs
- Open Junior Data Analyst jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open Principal Data Scientist jobs
- Open BI Analyst jobs
- Open Business Intelligence Engineer jobs
- Open Data Science Intern jobs
- Open Senior Business Intelligence Analyst jobs
- Open Sr. Data Scientist jobs
- Open Lead Data Analyst jobs
- Open Azure Data Engineer jobs
- Open Software Engineer, Machine Learning jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Analytics Engineer jobs
- Open Marketing Data Analyst jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Engineering Manager jobs
- Open Product Data Analyst jobs
- Open Data Analyst II jobs
- Open Privacy-related jobs
- Open GCP-related jobs
- Open Tableau-related jobs
- Open Excel-related jobs
- Open ML models-related jobs
- Open Data pipelines-related jobs
- Open APIs-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open LLMs-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open Business Intelligence-related jobs
- Open Data governance-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Git-related jobs
- Open Docker-related jobs
- Open Snowflake-related jobs