Greetings from ITC Infotech!
Role - Data/BI Engineer
Location - Sacramento, CA
Start Date: Immediate
Position Type: Full Time (Medical, 401K, PTO etc.)
Job description:
- Build and maintain T-SQL views, stored procedures, and operational reports (SSRS or equivalent) against HealthRules Payer data warehouse replicated to on-premises SQL Server
- Develop data marts for commercial health plan operational analytics (claims lag, denial rates, financial accuracy, PMPM trends, provider performance)
- Support ad hoc data requests from finance, operations, and compliance teams
- Ensure data quality and reconciliation between HealthRules data warehouse and downstream reporting
- Provide limited support for value-based care analytics, working within an existing enterprise semantic model that integrates health plan data with clinical and quality data sources Required Experience
- 3+ years SQL Server development (T-SQL, SSRS, SSIS) in healthcare payer or provider environment
- Experience working with HealthRules Payer data warehouse structures (claims, membership, provider, accumulators)
- Commercial health plan metrics and KPIs (claims, enrollment, accumulators, financial reporting)
- Experience building semantic layers or data marts for self-service BI
- Power BI development experience, including working within existing semantic models and datasets 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 Qualification
Bachelor s in Computer Science, Information Technology, Engineering, or related field (equivalent experience acceptable).
ITC Infotech is an Equal Opportunity Employer. We believe that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation. All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. ITC infotech is committed to providing veteran employment opportunities to our service men and women.