SQL Developer

Robotic Process Automation LLC; Edison (NJ); On-site; USD 110,000 - 160,000; Full time

Job summary

Robotic Technologies Automation seeks an experienced Senior SQL Developer to design, optimize, and maintain complex SQL solutions for healthcare data. You will handle patient demographics, claims, billing, eligibility, and provider records, ensuring quality and HIPAA-compliant data practices.

You will collaborate with analysts and data engineers to deliver reliable database solutions, support reporting requirements, and improve query performance across EHR and related systems.

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.
• Understanding of indexes, execution plans, and query performance tuning.
• Experience with healthcare data systems (patients, claims, billing, eligibility, provider records).
• Knowledge of HIPAA and data privacy requirements.

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 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.

Skills

SQL development

Query optimization

ETL processes

Healthcare data

HIPAA compliance

Database performance tuning

SQL Server

Oracle

PostgreSQL

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.