Data Engineer

Sr. Data Engineer SSIS, SSRS Power Bi with HealthcareSacramento, CA HybridLooking for Locals Only Job description:Primary ResponsibilitiesBuild 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 ServerDevelop and maintain data marts to support commercial health plan analytics, including:Claims lag and denial ratesFinancial accuracy and reconciliationPMPM trendsProvider performance metricsSupport ad‑hoc and recurring data requests from finance, operations, compliance, and leadership teamsEnsure data quality, consistency, and reconciliation between HealthRules data warehouse and downstream reporting layersProvide limited support for value‑based care analytics, working within an existing enterprise semantic model that integrates:Health plan dataClinical dataQuality and performance dataRequired Skills & Experience3+ years of experience developing solutions in SQL Server using:T‑SQLSSRSSSISExperience working in a healthcare payer or provider environmentStrong knowledge of HealthRules Payer data warehouse structures, including:ClaimsMembershipProviderAccumulatorsExperience with commercial health plan metrics and KPIs, including:Claims processingEnrollmentAccumulatorsFinancial and operational reportingExperience building data marts or semantic layers to support reporting and self‑service BIHands‑on experience with Power BI, including working within existing datasets and semantic modelsPreferred 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 dataEducationBachelor’s of Engineering in Electronics and Telecomm or related fields.