**Work Schedule** Standard (Mon-Fri) **Environmental Conditions** Office **Job Description** _At Thermo Fisher Scientific, you’ll discover meaningful work that makes a positive impact on a global scale. Join our colleagues in bringing our Mission to life – To enable our customers to make the world healthier, cleaner and safer. We provide our teams with the resources needed to achieve individual career goals while taking science a step beyond through research, development and delivery of life-changing therapies. As part of our clinical research portfolio, our CorEvitas evidence-based solutions specialize in generating data intelligence and clinical insights needed to bring safe and effective treatments to market. Your objectivity and dedication to patient safety will improve health outcomes that people and communities depend on – now and in the future._ _Location/Division Specific Information_ _\#CorEvitas_ _Discover Impactful Work:_ _Vestrum is looking for a Senior Data Engineer to join our talented database team in support of our development of real-world evidence used by medical professionals and the pharmaceutical industry._ _This position is responsible for the availability, integrity, accessibility, and performance of all the Vestrum database systems by supporting, enhancing, administering, and maintaining our corporate databases. The position also requires the management of staff engaged in operational aspects of the data administration process._ _A day in the Life:_ _Ensure weekly EHR data updates for existing Vestrum panel physicians are complete and appropriately loaded into databases and their associated applications_ _· Maintain current ETL processes to ensure data availability_ _· Must have Data architecture, scalable data processing framework development experience_ _· Experience with ETL migration from SQL Server to AWS using analytical services_ _· For new panel members and new applications, standardize free-text and other unstructured data fields including PDF files into structured data with associated updates to the data base_ _· Continue to develop automated quality assurance functions to validate incoming data and ensure the data are loaded into the warehouse appropriately_ _· Merge longitudinal patient level data from a variety of different sources and manage a tokenization project to link patient information from different sources_ _· Maintain various mapping tables for use by analysts (physicians, drugs, dosage forms and strengths, etc.)_ _· Familiar with linking and transforming patient activity data into standardized outputs._ _· Implement requirements for backup and recovery and ensure successful nightly recoverable backups of all databases_ _· Maintain data base documentation describing data elements_ _· Manage database configuration on AWS_ _· Define new data architecture and process to improve performance using AWS analytical services_ _· Maintain database security_ _· Ensure HIPPA, GDPR compliance_ _· Perform database space management and monitoring_ _· Manage operations including distribution of weekly and monthly reports_ _· Communicate with and maintain strong relations with data suppliers_ _· Machine learning, NLP processing experience is a Plus_ _· Maintaining and developing the relationship with external hosting provider for existing server hardware_ _Keys to Success:_ _Education_ _Bachelor (BS) of computer science or equivalent is required._ _Experience_ _Must have EMR or health care or pharmaceutical domain experience_ _Must have Python or Java experience_ _Relational, columnar, document oriented and cloud database experience is a plus_ _Experience in problem solving, troubleshooting and analyzing database issues and/or problems and to take appropriate corrective action_ _Experience with implementing data encryption_ _Experience in researching and/or applying current trends, methodologies, standards, practices and/or products in an IT environment._ _Knowledge, Skills, Abilities_ _Must be SQL Server database expert_ _Must know SSRS – SQL server reporting service_ _Must be a SQL expert_ _Must be able to guide and mentor the Junior developers_ _Must be able to lead the project_ _AWS analytical services experience – S3, Glue, Lambda, RDS, Redshift services is required_ _Must know ETL data processing tools and services_ _AWS non-relational database service experience is a plus_ _Significant experience onboarding new EMR data sources and integrating these data into the existing database structure_ _Our Mission is to enable our customers to make the world healthier, cleaner and safer. Watch as our colleagues explain 5 reasons to work with us. As one team of 100,000+ colleagues, we share a common set of values - Integrity, Intensity, Innovation and Involvement - working together to accelerate research, solve complex scientific challenges, drive technological innovation and support patients in need. #StartYourStory with Thermo Fisher Scientific, where diverse experiences, backgrounds and perspectives are valued._ Thermo Fisher Scientific is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.