Associate Healthcare Analyst (SQL)

EXL; Jersey City (NJ); On-site; USD 48,000 - 79,000; Full time

Job summary

EXL in the United States is seeking a data analytics professional to develop SQL queries, implement stored procedures, and optimize reporting with Azure Databricks. You will produce scalable code and support production issues while aligning analytics with health business goals.

Experience with SSRS/SSIS, PySpark, Hive and cloud technologies is required; certifications in data analytics or databases are a plus.

Qualifications

• SQL Server: advanced SQL, stored procedures and functions.
• SSRS/SSIS for data integration and reporting.
• Azure Databricks experience.
• Big Data tools: Python, PySpark, Hive, Zeppelin notebook.
• Knowledge of cloud technologies.
• Certifications in Data analytics/Database.

Responsibilities

• Ability to write programs independently using SQL, Hive QL etc.
• Tune queries for performance, security and stability of the reports.
• Understand functional aspects of reports and perform deployment.
• Pro‑active in maintaining and increasing technical knowledge.
• Collaborate with others to achieve goals and positive results.
• Capable of handling production support issues and resolving them.
• Propose new and state‑of‑the‑art technologies to improve reporting.
• Deliver analytic insights, interpretations and recommendations with professional customer focus.

Skills

Advanced SQL

Stored procedures

Functions

Big data analytics

Cloud technologies

Tools

SSRS

SSIS

Azure Databricks

Python

PySpark

Hive

Zeppelin notebook

Job description

Description

• 1+ Years of experience in developing SQL queries, Stored procedures and Functions.
• Performs advanced data analytics including monitoring performance, query development, opportunity assessments, trend identification and bulk data inserts.
• Knowledge of Azure - Databricks
• Develop, evolve, deploy, and manage analytic and reporting services and processes, ensuring all deliverables meet the requirements of customers and EXL’s Health business goals.
• Produce scalable and flexible, high-quality code that satisfies both functional and non-functional requirements.
• Coordinate and prioritize analytical including client communication, planning, and identifying operational process flow, ability to plan, manage and execute projects within the targeted timelines.
• Responsible for addressing production support issues on day-to-day basis and closing them on time.
• Propose new and state of – the – art technologies and processes that will improve efficiency and enhance the reporting platform.
• Deliver results with analytic insights, interpretations and recommendations presents in a professional manner with a high customer service focus.

*Base Pay Range: $48,100 - $79,000

For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits

*The posted range is the hiring range for this role — a subset of the broader range available to employees over time — and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process.

Responsibilities

• Ability to write programs independently using technologies like SQL, Hive QL etc.
• Quick learner with ability to understand product’s functionality end to end.
• Responsible for tuning queries for performance, security and stability of the reports.
• Need to understand the functional aspects of the reports being developed & perform deployment.
• Pro‑active in maintaining and increasing the teams and your own technical knowledge.
• Works collaboratively with others to achieve common goals and positive results
• Capable of working with high degree of discretion, employing effective customer service and communication methods

Qualifications

Required Skills:

• SQL Server: Advanced SQL, Stored procedures and functions.
• Enterprise modeling tool and data integration platform –(SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS))
• Azure Databricks
• Big Data Tools, not limited to – Python, PySpark, HIVE and Zeppelin notebook
• Knowledge of Cloud technologies
• Certifications in Data analytics/Database

Skills Nice to Have:

• Knowledge of Cloud technologies
• Certifications in Data analytics/Database

Business Domain:

• US Healthcare Insurance
• Healthcare Claims Processing
• ICD Codes and classifications
• Subrogation Process