Sr. Data Engineer

About ITC Infotech:

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.

Role - Sr. Data Engineer

Start Date - Immediate

Duration - Long Term

Job Description:

Primary Responsibilities

• Build and maintain TSQL views, stored procedures, and operational reports (SSRS or equivalent) using data from the HealthRules Payer data warehouse replicated to onpremises 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 adhoc 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 valuebased 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:
• TSQL
• 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 selfservice BI
• Handson 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.