SQL Developer (SQL Server)

We are seeking a hands-on SQL Developer with strong experience in Microsoft SQL Server to support critical data operations and deliver high-quality data solutions under strict timelines. This role is focused on data troubleshooting, optimization, and development of efficient SQL solutions within a fast-paced environment, working closely with cross-functional teams. This position requires working U.S. East Coast hours (or closely aligned schedule) on a regular basis. What You’ll Be Doing Design, develop, and maintain complex SQL queries, stored procedures, views, and functions in Microsoft SQL Server Analyze and optimize SQL performance using query tuning, indexing strategies, and execution plan analysis Investigate and resolve data issues and discrepancies, ensuring accuracy and integrity across systems Support and enhance data pipelines and ETL processes (data ingestion, transformation, and loading) Collaborate with cross-functional teams (data, product, engineering) to understand requirements and deliver solutions Troubleshoot production issues and provide timely, high-quality fixes under SLA-driven deadlines Contribute to process improvements, documentation, and best practices across data workflows Provide technical guidance and knowledge sharing within the team What We Look For 3–5 years of hands-on experience in SQL development Strong expertise in Microsoft SQL Server (development-focused, not administration) Proven experience writing complex queries, including joins, subqueries, CTEs, and window functions Solid understanding of performance tuning and query optimization Experience working with data pipelines / ETL processes (e.g., SSIS or similar tools) Strong understanding of database design principles (normalization, indexing, etc.) Experience troubleshooting data issues in production environments Ability to explain technical decisions and work independently with minimal supervision Strong analytical thinking, attention to detail, and problem-solving skills Advanced English proficiency required, with the ability to collaborate with Global-based teams and stakeholders Nice to Have Experience in data-intensive or SLA-driven environments Exposure to data warehousing concepts Basic knowledge of Python or scripting languages Experience in healthcare, clinical, or regulated environments We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. The duties and responsibilities listed in this job description represent the major responsibilities of the position. Other duties and responsibilities may be assigned, as required. Clario reserves the right to amend or change this job description to meet the needs of Clario. This job description and any attachments do not constitute or represent a contract. The Department Head has the discretion to hire personnel with a combination of experience and education, which may vary from the above listed qualifications. Clario Privacy Policy Clario is a leading provider of endpoint data solutions to the clinical trials industry, generating high-quality clinical evidence for life sciences companies. We offer comprehensive evidence generation solutions that combine medical imaging, eCOA, precision motion, cardiac solutions and respiratory endpoints. For more than 50 years, Clario has delivered deep scientific expertise and broad endpoint technologies to help transform lives around the world. Our endpoint data solutions have supported over 30,000 clinical trials in more than 100 countries. Our global team of science, technology, and operational experts have supported over 70% of all FDA drug approvals since 2015.