Lead Data Engineer (SQL & Python)

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

Benefits offered by this job

Competitive compensation and annual performance bonus

Provident Fund and comprehensive medical insurance

Paid time off including vacation, sick leave, and public holidays

Employee wellness programs

Professional development opportunities

Job summary

Clario is seeking a Lead SQL & Python Engineer in Bangalore, India. In this pivotal role, you will lead the design and delivery of data solutions that support clinical trials. Your expertise will ensure the successful use of our products while mentoring a team of Data Delivery Engineers. The position demands strong SQL and Python programming skills, technical leadership, and excellent communication abilities. Join us to make a lasting impact in the field of clinical evidence.

Qualifications

• 1-2 years of leadership experience and 4-5 years of technical experience.
• Experience with SQL and Oracle stored procedures, views, and functions.
• Proven hands-on experience with Python programming.

Responsibilities

• Design and deliver data solutions to support clinical trials.
• Lead and mentor team members in technical tasks.
• Ensure compliance with SOPs and regulatory requirements.

Skills

SQL development

Python programming

Data visualization

Technical leadership

Communication skills

Education

MS/BA/BS in a related field

Tools

MS SQL Server

Power BI

Oracle

Job description

Overview

Join Clario, part of Thermo Fisher Scientific and help transform lives by unlocking better evidence.

We’re looking for a Lead SQL & Python Engineer to join our team in Bangalore, India. In this role, you’ll design and deliver data solutions that meet business and customer needs, ensuring Clario clients can successfully use our products in clinical trials. You will also lead and mentor a team of Data Delivery Engineers, fostering collaboration and driving project execution.

What We Offer

• Competitive compensation and annual performance bonus
• Provident Fund and comprehensive medical insurance for you and eligible dependents
• Paid time off including vacation, sick leave, and public holidays
• Employee wellness programs and engagement activities
• Professional development through internal and external training and certification programs

What You’ll Be Doing

• Design and deliver data solutions to support clinical trials
• Recommend design approaches and reporting options for successful trial execution
• Develop complex custom solutions to optimize data flow across internal systems
• Design and configure integrations with external systems
• Create custom reports and dashboards integrating multiple data sources
• Attend study meetings, review specifications, and provide technical consultation
• Perform code reviews, peer reviews, and resolve defects promptly
• Document work through release notes and ensure proper unit testing across environments
• Troubleshoot technical issues and serve as the last line of defense for escalations
• Lead and mentor team members, assist with training, and foster a collaborative environment
• Drive strategic initiatives to improve efficiency and automate processes
• Ensure compliance with SOPs and regulatory requirements
• Participate in client-facing meetings and act as a subject matter expert for technical escalations
• Coordinate deliverables, schedules, and prioritization for the Data Delivery team
• Own CAPAs, support audits, and contribute to continuous improvement initiatives

What We Look For

• MS/BA/BS in a related field
• 1–2 years of leadership experience and 4–5 years of technical experience, including at least 3 years in the industry
• Strong ability to design and develop SQL and Oracle stored procedures, views, and functions; experience with MS SQL Server preferred
• Extensive, hands‑on experience in designing, developing, and optimizing complex SQL queries, including Oracle stored procedures, views, and functions is required; familiarity with MS SQL Server is preferred.
• Proven, hands‑on experience with Python programming is required; familiarity with additional scripting or object‑oriented languages is desirable.
• Solid understanding of relational database concepts and large-scale database management
• Proven experience with Power BI for interactive reports and dashboards
• Strong data visualization skills using Plotly is a plus
• Experience integrating data sources and optimizing performance for large datasets
• Excellent verbal and written communication skills
• Proven track record in technical leadership and ability to manage multiple projects in a fast-paced environment
• Clinical trial experience is a plus