Sr. Data Engineer

ITC Infotech; Sacramento (CA); On-site; USD 110,000 - 140,000; Full time

Job summary

ITC Infotech in Sacramento, CA seeks an experienced SQL Server BI Developer to build data marts, ETL processes, and reporting layers for healthcare payer analytics. You will work with the HealthRules data warehouse and Power BI dashboards to deliver reliable metrics for finance, operations, and leadership.

Required 3+ years in SQL Server with SSRS/SSIS, healthcare payer environment, and strong data governance. This is a long‑term role with growth opportunities in enterprise analytics.

Qualifications

• 3+ years of experience developing solutions in SQL Server and BI tooling.
• Proficient with SSRS and SSIS.
• Experience in a healthcare payer or provider environment.

Responsibilities

• Build and maintain SQL Server views, stored procedures, and reports using HealthRules data warehouse.
• Develop and maintain data marts to support health plan analytics.
• Provide data quality and reconciliations between data warehouse and reporting layers.
• Support ad-hoc data requests from finance, operations, and leadership.

Skills

SQL Server

SSRS

SSIS

Power BI

Healthcare experience

Education

B.E. Electronics & Telecommunication

Tools

HealthRules Payer DW

Job description

ITC Infotech is a wholly owned subsidiary of ITC Limited, one of India's foremost private sector companies and a diversified conglomerate. The ITC Group, with a market capitalization of $65 billion, is globally recognized as a leader in sustainability. The group's vision is to achieve world-class performance and create growing value for both the Indian economy and its stakeholders. This vision is supported by core values such as Trusteeship, where professional managers hold the company in "trust" for its stakeholders; a strong Customer Focus; Respect for People; a commitment to Excellence; a pursuit of Innovation; and a strong Nation Orientation.

ITC Infotech's business philosophy is that business is at the center and technology is an enabler, as reflected in its tagline, "Business-friendly Solutions." The company offers a wide range of services and solutions across key business areas, including CIO Services (Automation, Digital Workplace, ERP), Digital Experience (Experience Transformation), and Product 4.0 (Product Lifecycle Management, Digital Manufacturing). In the last seven years, ITC Infotech has successfully doubled its revenue from $250 million to $500 million+ annually, with its EBIT improving from 8% to over 18%.

With this strong growth momentum, ITC Infotech is now embarking on its next journey, known as 'Next Orbit,' with the ambitious goal of reaching $1 billion in annual revenue within the next four years. The Americas region is a critical part of this charter and is expected to increase its contribution to total revenue from the current 35% to a range of 40% to 50%. Manufacturing is a key vertical for the group and ITC Infotech with BFSI, Retail, CPG, Travel, Transportation & Hospitality being others.

Start Date - Immediate

Duration - Long Term

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:
• Clinical data
• Quality and performance data

Required Skills & Experience

• 3+ years of experience developing solutions in SQL Server using:
• SSRS
• SSIS
• Experience working in a healthcare payer or provider environment
• Strong knowledge of HealthRules Payer data warehouse structures, including:
• Claims
• Membership
• Provider
• Experience with commercial health plan metrics and KPIs, including:
• Claims processing
• 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.

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.