Lead Database Engineer

ThermoFisher Scientific; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

ThermoFisher Scientific is seeking a Sr Systems Developer in Bengaluru, Karnataka. This role involves systems analysis, development, testing, and support of complex information systems. The ideal candidate will have at least 5 years in similar roles, proficiency in SQL and Python, and experience with AWS.

The responsibilities include managing data integrations, improving database security, and ensuring compliance with standards while developing new data architectures.

Qualifications

• 5+ years of relevant experience in systems development.
• Strong understanding of SQL and relational databases.
• Proficiency in web development languages.

Responsibilities

• Perform systems analysis and support complex technical components.
• Lead data integrations and ETL processes.
• Maintain and improve existing integrations.

Skills

SQL Server migration

Client-focused

Problem-solving

Python

Pyspark

Database security and compliance

Education

Bachelor's degree or equivalent experience

Tools

Jira

Github

AWS

Job description

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

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.