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.