Develops Power BI dashboards, SSRS reports, data models, KPIs, and healthcare analytics solutions. Uses advanced SQL and Python to transform, analyze, and optimize large healthcare datasets. Performs exploratory analysis, ensures data quality and governance, supports reporting and production issues, and communicates insights to technical, business, client, and executive stakeholders. Collaborates across Product, Engineering, Client Services, and Operations teams in Agile delivery environments.
Multi-disciplinary data professional who enjoys solving Healthcare analytics problems.
Strong understanding of the U.S. Healthcare value chain (Payer and/or Provider).
Experience working with healthcare data including claims, eligibility, risk adjustment, utilization, and quality metrics.
Ability to derive meaningful and actionable insights from structured and semi-structured healthcare datasets.
Strong analytical mindset with ability to connect data findings to business outcomes.
Experience working in Agile (SCRUM) environments and iterative delivery cycles.
Ability to work on multiple reporting initiatives simultaneously.
Strong stakeholder communication skills – capable of presenting insights to both technical and non-technical audiences.
Experience optimizing Power BI datasets and SQL queries for performance and scalability.
Quick learner with strong problem-solving skills and attention to detail.
*Base Pay Range: $60,100 - $98,700
For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits
Responsibilities- Design, develop, and maintain Power BI dashboards and SSRS reports to support operational and strategic decision-making and data transformations with Python.
- Translate business requirements into data models, KPIs, and visualizations that drive actionable insights.
- Perform exploratory data analysis (EDA) to uncover trends, patterns, and performance improvement opportunities.
- Develop scalable data models and datasets optimized for reporting and analytics consumption.
- Ensure data quality, integrity, governance, and security compliance in reporting solutions.
- Collaborate with cross-functional teams to gather requirements and deliver analytics solutions aligned to business objectives.
- Monitor, maintain, and enhance existing dashboards to improve performance and usability.
- Provide analytical support for operational reviews, client discussions, and executive reporting.
- Support production issues related to data discrepancies, report failures, and performance bottlenecks.
- Collaborate with Product, Engineering, Client Services, and Operations teams for data requirements and reporting needs.
- Share knowledge and best practices around analytics, dashboard design, and data governance.
- Proactively contribute to improving internal analytics frameworks and reusable reporting assets.
- Support leadership with ad-hoc analysis and executive-ready reporting materials.
- Communicate with onshore stakeholders and clients regarding reporting requirements and analytics outputs.
- Participate in client discussions to clarify data definitions, KPIs, and reporting expectations.
- Act as a bridge between business stakeholders and technology teams for analytics delivery
- 4–6 years of experience in data analytics, business intelligence, and reporting within enterprise environments.
- Strong hands-on experience in SQL for complex querying, data transformation, performance tuning, and optimization.
- Proficient in Python for data analysis, data manipulation, and automation.
- Bachelor's degree in Math, Statistics, or related field required
Required Skills:
- Advanced SQL (CTEs, Window Functions, Query Optimization, Stored Procedures)
- Python (Pandas, NumPy, PySpark)
- Power BI
- Data Warehousing Concepts & Dimensional Modeling
- ETL/ELT pipeline understanding
- Strong knowledge of data governance, data quality, and security best practices
- Experience working with large healthcare datasets
- Version control tools (Git preferred)
- Experience with Cloud Platforms (Azure preferred)
Skills Nice to Have:
- Experience or certifications in Azure Data / Databricks
- Experience with Healthcare interoperability standards (HL7, FHIR)
- Exposure to Risk Adjustment models (CMS-HCC)
- Knowledge of Snowflake or other modern cloud data warehouses
- Experience with advanced analytics or predictive modeling
Business Domain Knowledge:
- Medicare Risk Adjustment. CMS payment models
- US Healthcare Insurance & Payer Analytics
- Population Health Analytics & Risk Management
- Payer Management & Code Classification Management
- Utilization & Cost Management
*The posted base salary range is the hiring base salary range for this role. Final offers are based on several factors, including: the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position.
About Us EXL (NASDAQ: EXLS) is a leading data analytics and digital operations and solutions company. We partner with clients using a data and AI-led approach to reinvent business models, drive better business outcomes and unlock growth with speed. EXL harnesses the power of data, analytics, AI, and deep industry knowledge to transform operations for the world’s leading corporations in industries including insurance, healthcare, banking and financial services, media and retail, among others. EXL was founded in 1999 with the core values of innovation, collaboration, excellence, integrity and respect. We are headquartered in New York and have more than 54,000 employees spanning six continents. For more information, visit www.exlservice.com.
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Analyzes and manages Medicare Advantage eligibility, utilization, and benefit data. The role validates data accuracy, supports vendor data exchanges, troubleshoots production issues, performs SQL-based ad hoc analysis, and ensures compliance with CMS and organizational standards. It collaborates with product owners, vendors, IT teams, and business stakeholders to design scalable data solutions, communicate findings, manage requirements, and drive projects to completion.
Top Skills:
DatabricksPythonSnowflakeSQL Server
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Analyzes renewal opportunities and account histories, gathers pricing, product, partner, and contract data, and prepares system-derived renewal proposals. Uses Salesforce and Excel to validate information, review documents, test system enhancements, and coordinate with cross-functional teams. Manages assigned regional tasks, organizes findings, and ensures accurate, timely completion in a deadline-driven environment.
Top Skills:
ExcelMicrosoft PowerpointMicrosoft WordSalesforce
Fintech • Software • Financial Services
Owns fraud and market-abuse detection models, rules, and partner-facing surveillance reporting across trading data. Investigates wash trading, collusion, hedging, reverse trading, and other suspicious activity; calibrates thresholds, validates false positives, maintains data quality, and produces evidence-based findings. Requires strong SQL, cloud data warehouse experience, futures and derivatives knowledge, anomaly detection expertise, and the ability to communicate findings to partners and executives.
Top Skills:
AthenaBigQueryPythonSQL
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
