SQL Developer

Robotics Technologies LLC; Edison (NJ); On-site; USD 90,000 - 130,000; Full time

Job summary

Robotics Technologies LLC in Edison, NJ seeks an experienced Senior SQL Developer to design, optimize, and maintain complex SQL queries, stored procedures, functions, and views within healthcare data systems.

You will collaborate with healthcare business analysts, data engineers, and application teams to deliver reliable database solutions for reporting on patient demographics, claims, eligibility, billing, and provider data, while ensuring HIPAA compliance.

Qualifications

• 8–10 years of experience in SQL development and database programming.
• Strong knowledge of complex SQL queries, joins, CTEs, subqueries, and window functions.
• Hands-on experience with stored procedures, functions, views, and triggers.
• Strong understanding of indexes, execution plans, and query performance tuning.
• Experience with SQL Server, Oracle, or PostgreSQL.
• Knowledge of database design, data modeling, and data validation.
• Experience with ETL processes and healthcare data integration.
• Understanding of HIPAA and the protection of sensitive healthcare information.

Responsibilities

• Develop, maintain, and optimize complex SQL queries, stored procedures, functions, triggers, and views.

Skills

SQL development

Query optimization

Data modeling

ETL processes

HIPAA compliance

Healthcare data familiarity

Tools

SQL Server

Oracle

PostgreSQL

Job description

We are seeking an experienced Senior SQL Developer with strong expertise in SQL development, database performance tuning, and healthcare data systems. The ideal candidate will have experience working with healthcare data, including patient information, claims, billing, eligibility, and provider records. The candidate will collaborate with healthcare business analysts, data engineers, and application teams to develop reliable database solutions and support healthcare reporting requirements.

Key Responsibilities

Develop, maintain, and optimize complex SQL queries, stored procedures, functions, triggers, and views.

Work with healthcare datasets, including patient demographics, medical claims, eligibility, provider, and billing information.

Develop SQL solutions to support healthcare analytics, operational reporting, and regulatory reporting.

Perform data validation, reconciliation, and quality checks across healthcare systems.

Analyze and optimize query performance for large healthcare databases.

Support ETL processes and data integration between electronic health record (EHR), claims, and billing systems.

Collaborate with business analysts and healthcare stakeholders to understand business requirements.

Troubleshoot database issues and support production environments.

Ensure compliance with HIPAA requirements and organizational data privacy policies.

Maintain technical documentation, data mappings, and database development standards.

Required Technical Skills

8–10 years of experience in SQL development and database programming.

Strong knowledge of complex SQL queries, joins, CTEs, subqueries, and window functions.

Hands-on experience with stored procedures, functions, views, and triggers.

Strong understanding of indexes, execution plans, and query performance tuning.

Experience with SQL Server, Oracle, or PostgreSQL.

Knowledge of database design, data modeling, and data validation.

Experience with ETL processes and healthcare data integration.

Understanding of HIPAA and the protection of sensitive healthcare information.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.