SQL SSIS BI Developer

Sr. SQL SSIS BI Developer (Healthcare Payer)Location: Sacramento, CA (Hybrid – 2 Days Onsite every week)Duration: 24 Months ContractExperience: 10+ YearsDomain: Healthcare PayerJob SummaryWe are seeking an experienced Sr. Engineer with strong expertise in Healthcare Payer analytics, SQL/SSIS development, and Enterprise Data Warehousing. The ideal candidate will have hands-on experience with HealthRules Payer (HRP) or QNXT, healthcare claims and enrollment data, and business intelligence reporting. Experience working with CalPERS data or reporting is highly preferred.Key ResponsibilitiesDesign, develop, and optimize complex SQL queries, stored procedures, and ETL processes using SQL Server and SSIS.Build and maintain enterprise data warehouses, data marts, and healthcare reporting solutions.Analyze and report on Claims, Enrollment, Provider, and Accumulator data using HealthRules Payer (HRP) or QNXT.Develop interactive dashboards and executive reports using Power BI and Tableau.Support HEDIS/NCQA reporting, operational analytics, financial reconciliation, and data quality initiatives.Ensure compliance with HIPAA, data governance, and security standards while collaborating with business and technical stakeholders.Required SkillsAdvanced SQL, T-SQL, Stored Procedures, Query OptimizationSSIS, ETL Development, Enterprise Data WarehousingHealthcare Payer experience with HealthRules Payer (HRP) or QNXTClaims, Membership, Provider & Enrollment data analysisPower BI, Tableau, DAXSQL Server, Snowflake, Oracle, Teradata, Azure Data PlatformData Governance, Data Quality, HIPAA ComplianceStrong analytical, problem-solving, and stakeholder communication skillsPreferred QualificationsExperience with CalPERS data or reportingHands-on experience with HEDIS measures and NCQA specificationsExperience building executive dashboards, operational reporting, and healthcare analytics solutions