Lead Database Engineer
Work Schedule Other Environmental Conditions Office
Job Description
Summarized Purpose: We are presenting an outstanding opportunity to join Thermo Fisher Scientific as a Sr Systems Developer. In this role, you will play a crucial part in performing the systems analysis, building, development, testing, and support of highly complex technical information system components. Education/Experience: Bachelor's degree or equivalent experience and relevant formal academic/vocational qualification. Previous roles showcasing the proficiencies necessary to fulfil the job responsibilities (similar to 5+ years’) or an equivalent blend of education, training, & experience. Major Job Responsibilities: Ensure weekly EHR data updates for existing Vestrum panel physicians. Integrate new panel members from existing EMR systems. Lead the data integrations, ETL process, and database operations based per collaborators requirement. Maintain and improve existing integrations while adding new EMR integrations Continue to improve automated quality assurance functions to validate incoming data and ensure data is loaded into the warehouse accurately. Normalize various EMR data into Data Warehouse and analytical database Maintain mapping tables for use by analysts (physicians, drugs, dosage forms and strengths, etc.) Link and transform patient activity data into standardized outputs. Implement requirements for backup and recovery, ensuring successful nightly recoverable backups of all databases. Maintain data base documentation describing data elements. Develop new data architecture and processes to improve performance using AWS analytical services. Proficiency in Python & Pyspark. Ensure database security and compliance with HIPAA, GDPR. Manage operations including distribution of weekly and monthly reports. Communicate and maintain strong relations with collaborators. Knowledge, Skills, and Abilities: SQL Server to AWS migration using analytical services. Client-focused approach with strong interpersonal and communication skills. Ability to multitask and prioritize with attention to detail. Strong logical, analytical thinking, and problem-solving capabilities. Proficiency in web development and scripting languages like Python and Shell. Proficiency in SQL and relational database schema. Expertise in relational database platforms: Oracle, SQL Server, MySQL, PostgreSQL. Familiarity with server environments (Windows, Linux/Unix), Apache, IIS. Familiarity with data governance, security, and compliance standards. Experience with validated systems and the clinical industry (preferred). Project management and leadership experience. Project management and leadership experience. Must Have Skills: Expert level SQL expertise. Proficiency in SQL server database technologies including SSIS and SSRS. Proficient in SQL and relational database advancement. Experience building Cloud BI solutions using AWS. Experience with Data architecture, scalable data processing framework. Data Modelling and database building experience. Strong problem-solving and analytical skills. Excellent documentation and communication abilities. Performance tuning and query optimization. Leadership and mentoring capabilities. Jira, Github experience. Agile methodology experience. Good to Have Skills: Experience with MySQL and PostgreSQL. Scripting and automation skills (e.g., Python, Shell) Familiarity with Apache, IIS, and server environments. Validated system experience. Familiarity with Tableau or PowerBI is helpful. Familiarity with Databricks or Snowflake. Experience in machine learning, NLP processing, and LLM is an advantage. Health care or Electronic Medical records, Clinical trial data domain experience. Working Hours: India: 05:30 PM to 02:30 AM IST Philippines: 08:00 PM to 05:00 AM PHT