MS-SQL Developer

In Medidata, we are currently seeking a skilled SQL Developer to join our talented team and contribute to write complex SQL queries and create standard and custom complex visualizations and data products (extracts) in Medidata CIS Team. You will be working together with colleagues from Medidata onshore and offshore Teams (Pune, Bangalore, and Hyderabad).

This position can be based in Pune, India.

Role Description & Responsibilities

• Design and write complex SQL queries, stored procedures, functions, and dynamic scripts for data manipulation and reporting.

• Lead the development of custom and standard visualizations using tools such as Tableau, Business Objects, Crystal Reports, or Logi Analytics.

• Collaborate with clients and cross-functional teams to gather requirements, define technical specifications, and deliver data products.

• Mentor junior developers, guiding them on best practices, code reviews, and problem-solving.

• Act as the technical point of contact for the SQL development team and contribute to architecture and process improvements.

• Identify technical or timeline risks early and propose creative solutions with minimal oversight.

• Perform unit testing, debugging, and optimization of queries for performance and accuracy.

• Ensure compliance with development standards and documentation protocols.

• Independently analyze, design, and deliver solutions in diverse and complex environments.

• Collaborate effectively with both onshore and offshore teams.

Qualifications - External

• 4–6 years of hands-on experience in MS SQL Server, with proven expertise in writing complex queries and optimizing performance.
• Exposure to BI/reporting tools like Tableau, Crystal Reports, Business Objects, or Logi Analytics is a strong plus.
• Strong understanding of database design, query optimization, indexing, and data transformation techniques.
• Experience in requirement gathering, technical specification writing, and stakeholder communication.
• Ability to identify and mitigate technical and project risks.
• Prior experience with client-facing roles and delivering under minimal supervision.

What’s in it for you

• Requirement Gathering with the Clients

• Provide/Judge the feasibility.

• Write complex SQL queries.

• Perform Unit Testing

• Perform Debug of applications

• Proactively identify the risks in both Technical and Timelines

• Create Standard and Custom complex Visualizations.

• Perform Investigation and find the root cause of the issue and fix it.