SQL Developer

Machine Learning Technologies, LLC; Edison (NJ); On-site; USD 110,000 - 160,000; Full time

Job summary

Machine Learning Technologies, LLC in Edison, New Jersey, seeks an experienced Senior SQL Developer to design, optimize, and maintain complex SQL solutions for healthcare data systems, including claims, eligibility, and provider records.

You will collaborate with business analysts, data engineers, and application teams to ensure data quality, HIPAA compliance, and scalable performance across EHR, billing, and regulatory reporting, while supporting ETL processes.

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.
• Experience with ETL processes and healthcare data integration.
• Understanding of HIPAA and protection of sensitive healthcare information.

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.

Skills

SQL development

Performance tuning

Healthcare data

Data validation

ETL processes

HIPAA compliance

Database design

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.