We are seeking a skilled SQL Developer with 3–5 years of experience to design, develop, optimize and maintain database scripts. The ideal candidate will have strong expertise in SQL programming, database performance tuning, and data pipeline support, and will work collaboratively with cross-functional teams including analytics, product, and engineering.
This role supports U.S. East Coast business hours; candidates must be willing and able to work U.S. Eastern Time or closely aligned hours on a regular basis.
What You’ll Be Doing
Design, develop, and maintain complex SQL queries, stored procedures, views, and functions
Optimize database performance through query tuning, indexing, and execution plan analysis
Develop and support ETL processes for data ingestion, transformation, and loading
Ensure data accuracy, consistency, and integrity across systems
Work closely with data analysts, data engineers, and application teams to understand business requirements
Troubleshoot database issues and provide timely resolution
Create and maintain technical documentation for database structures and processes
Support reporting and analytics needs by building efficient data models
What We Look For
3–5 years of hands-on experience in SQL development
Strong proficiency in relational databases such as: Microsoft SQL Server, MySQL, PostgreSQL, or Oracle
Expertise in writing complex queries, joins, CTEs, and window functions
Experience with performance tuning and query optimization
Good understanding of database design principles (normalization, indexing, etc.)
Experience with ETL tools or scripting (e.g., SSIS, Informatica, or custom pipelines)
Familiarity with data warehousing concepts
Basic knowledge of Python or other scripting languages is a plus
Strong problem-solving and analytical skills
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.
Skills Required
- 3-5 years of hands-on experience in SQL development
- Strong proficiency in relational databases such as Microsoft SQL Server, MySQL, PostgreSQL, or Oracle
- Expertise in writing complex queries, joins, CTEs, and window functions
- Experience with performance tuning and query optimization
- Good understanding of database design principles (normalization, indexing)
- Experience with ETL tools or scripting (e.g., SSIS, Informatica, or custom pipelines)
- Familiarity with data warehousing concepts
- Basic knowledge of Python or other scripting languages
- Willingness and ability to work U.S. Eastern Time or closely aligned hours
- Strong problem-solving and analytical skills
Clario Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Clario and has not been reviewed or approved by Clario.
-
Leave & Time Off Breadth — Time off is described as generous, including flexible PTO for some roles and up to 26–31 PTO days for eligible staff. The calendar includes 15 paid company holidays and a Winter Break.
-
Healthcare Strength — Healthcare offerings include multiple medical plan options via Highmark with coordinated care navigation, plus dental and vision through established carriers. Employer HSA contributions and mental-health support broaden the package.
-
Inclusive Benefits Coverage — Coverage highlights include domestic-partner eligibility, transgender-inclusive care, and HIV prevention/treatment. These inclusive elements are presented alongside broader inclusion commitments.
Clario Insights
What We Do
-- Clario has been named a Top Workplace by Energage for the 2022 Top Workplaces USA national awards. -- Clario generates the richest clinical evidence by fusing our deep scientific expertise and global scale into the broadest endpoint technology platform. By doing this, we empower our partners to transform lives. With almost 50 years of experience, 19,000 clinical trials, and 870 regulatory approvals, Clario has mastered the ability to generate rich evidence across a Trial Anywhere™ portfolio: decentralized (DCT), hybrid and site-based clinical trials. With 30 facilities in nine countries across North America, Europe, and Asia Pacific, Clario delivers the power of certainty. Partners ————— Clario brings the best of ERT and Bioclinica together to work alongside our partners to solve some of their biggest questions on topics such as: - eCOA vs. paper - Decentralized Clinical Trial (DCT) - Rescue a clinical trial - Broad endpoint technology: cardiac safety, imaging, respiratory And many more. People ———— We are so honoured to be named a 2022 Top Workplace by Energage. One of our leading values at Clario is People First Always. We help individuals build meaningful careers at Clario as they serve to help transform patients lives. Join us on this journey and check out our careers page: https://clario.com/careers/
