SSIS SSRS SQL Server Data enginee

Sr. Data Engineer

Location : Sacramento, CA

Job description:

Primary Responsibilities

Build and maintain T‑SQL views, stored procedures, and operational reports (SSRS or equivalent) using data from the HealthRules Payer data warehouse replicated to on‑premises SQL Server
Develop and maintain data marts to support commercial health plan analytics, including:
Claims lag and denial rates
Financial accuracy and reconciliation
PMPM trends
Provider performance metrics
Support ad‑hoc and recurring data requests from finance, operations, compliance, and leadership teams
Ensure data quality, consistency, and reconciliation between HealthRules data warehouse and downstream reporting layers
Provide limited support for value‑based care analytics, working within an existing enterprise semantic model that integrates:
Health plan data
Clinical data
Quality and performance data
 

Required Skills & Experience

3+ years of experience developing solutions in SQL Server using:
T‑SQL
SSRS
SSIS
Experience working in a healthcare payer or provider environment
Strong knowledge of HealthRules Payer data warehouse structures, including:
Claims
Membership
Provider
Accumulators
Experience with commercial health plan metrics and KPIs, including:
Claims processing
Enrollment
Accumulators
Financial and operational reporting
Experience building data marts or semantic layers to support reporting and self‑service BI
Hands‑on experience with Power BI, including working within existing datasets and semantic models
 

Preferred Qualifications

• Understanding of health plan regulatory reporting (e.g., risk adjustment, MLR, quality measures)

• Experience with value-based care analytics (quality measures, cost of care, utilization, risk stratification)

• Experience working with multi-source data models integrating payer, clinical, and quality data

Education

Bachelor’s of Engineering in Electronics and Telecomm or related fields.
 

Best Regards,
Gopal Sharma
Senior Talent Acquisition – USA
Net2Source Inc.
Global HQ Address: 7250 Dallas Pkwy, Suite 825, Plano, Texas – 75024
India HQ Address: N2S, C-99, Sector 63, Noida – 201301
Email: sharma.gopal@net2source.com || 

Web: www.net2source.com