Posted:
6/12/2026, 2:58:17 AM
Experience Level(s):
Mid Level ⋅ Senior
Field(s):
Data & Analytics ⋅ IT & Security
Workplace Type:
Remote
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.
Website: https://clario.com/
Headquarter Location: Philadelphia, Pennsylvania, United States
Employee Count: 5001-10000
Year Founded: 1972
IPO Status: Private
Last Funding Type: Private Equity
Industries: Biotechnology ⋅ Pharmaceutical