Designs, develops, tests, deploys, and maintains enterprise business intelligence reports, dashboards, data warehouses, and ETL solutions. The role uses SQL Server, SSIS, Power BI, Azure services, and Tableau to support healthcare payer analytics. Responsibilities include data modeling, query tuning, report testing, documentation, requirements analysis, solution design, stakeholder communication, end-to-end delivery, mentoring, and collaboration on product roadmaps and scalable features.
Basic Functions6-8 ;Years of experience in enterprise application design, development & support.Handling high volume SQL warehouse, Extensive knowledge on MS SQL, SSIS and Visual ReportExperienced in designing and building data warehouses/marts using Microsoft SQL.Proficient in developing engaging and insightful visual dashboards with Power BI.Possesses a strong understanding of data modelling and visualization principles.Design, develop, and maintain enterprise BI reports, visualizations, and dashboards in Power BIWork with the report team to design and implement a reporting user experience that is consistent and intuitive across environments and across report methods. ;Must have at least 1+ years of experience working on Azure Cloud Services such as Azure SQL, Data Factory and Data Bricks nice to have Synapse. ;Produce scalable and flexible, high-quality code that satisfies both functional and non-functional requirements. ;Develop, deploy, test and maintain technical assets in a highly secure and integrated enterprise computing environment & Support functional testing.Identify business reporting and analytic needs by collaborating with end users, stakeholders, and technology teams. ;Provide report testing support and execute report and analytics unit testing. ;Document report design and test case documentation as well as assist with end user documentation. ;Cross train & mentor team members for complete knowledge of technologies. ;Analyze and translate business requirements to technical design with security and data protection settings. ; ;Collaborate/communicate with on-site project team and business users as required. ;Work with development teams and product managers to ideate software solutions. ;Own all projects deliverables and ensure proper communication between teams and quality levels; responsible for end to end solution deliveryComprehend the fundamental solution being developed/deployed – its business value, blueprint, how it fits with the overall architecture, risks, and more.Would be required to provide inputs on solution and design effort to build scalable features /functionality. ; ; ; ; ; ;Essential FunctionsMulti-disciplinary technologist who enjoys designing and executing Healthcare solutions.Understanding of the US Healthcare value chain and key impact drivers [Payer and/or Provider]Strong problem solving and analytical skills and the ability to “roll up your sleeves” and work with a client to create timely solutions and resolutions.Ability to work on multiple product features simultaneously. ;Quick learner with ability to understand product’s functionality end to end.Experience with Strong knowledge of algorithms, design patterns and fundamental computer science concepts ;Would be responsible for tuning queries for performance, security and stability of the reports. ;Need to understand the functional aspects of the reports being developed & perform deployment. ;Detailing and analysis required in Data creation and tableau Reporting. ; ;Primary Internal InteractionsReview with the Overall Product Manager & AVP for improvements in the product development lifecycleAssessment meeting with VP & above for additional product development features.Train & Mentor, the juniors in the teamPrimary External Interactions ; Communicate with onshore stakeholders & Executive Team Members. ; Help the Product Management Group set up the product roadmap & help in identifying future sellable ; ; ; product features. ; ; Client Interactions to better understand expectations & streamline solutions. If required should be a bridge between the client and the technology teams. ;SkillsTechnical SkillsRequired Skills – ;SQL Server 2008 & above: ; SQL, Stored procedures, functionsPower BI Reports and Self-Service Power BI Reports buildingETL Data Load, SSISAzure SQL, Azure Data Factory, Data BricksMust have experience on cloud Azure hosted applications. ; ;Skills Nice to HaveProgramming Languages: Python, PySparKData Analysis Tools – (Online analytical processing (OLAP), ETL frameworks) & ;Azure Synapse ;Enterprise business intelligence platform (Tableau)Expertise in US Healthcare Insurance.Part of any open-source contributionsCertifications in Agile & Waterfall MethodologiesCertifications in Azure ;Process Specific Skills ;Business Domain ;- ;US Healthcare Insurance & Payer Analytics ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; Care Coordination & Care Optimization ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Population Health Analytics & Risk Management ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; Member 360 View & Analytics ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Gaps & Compliance Measures ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ;Payer Management & Code Classification Management ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; Utilization & Cost Management ; ; ; ; ; ; ; ; ; ; ; ;Soft SkillsUnderstanding of Healthcare business vertical and the business terms withinGood analytical skills.Strong communication skills - oral and verbalAbility to work with various stakeholders across various geography. ;Excellent Team player, with the ability to build & sustain teamsShould be able to function as an Individual Contributor as well if required.Mentor people and create a high performing organization (foster relationships, resolve conflicts and so on while delivering performance feedbackWorking HoursGeneral Shift – 12 PM to 9 PMWill be required to extend as per project release needs ;Education Requirements ;Master’s or Bachelor’s degree from top tier colleges with good grades, preferably from an Engineering Background ;
About the TeamEXL is the indispensable partner for leading businesses in data-led industries such as insurance, banking and financial services, healthcare, retail and logistics. We bring a unique combination of data, advanced analytics, digital technology and industry expertise to help our clients turn data into insights, streamline operations, improve customer experience, and transform their business. Our partnerships with clients are built on a foundation of collaboration – and we’ve been chosen as a partner by nine of the top ten leading US insurance companies, nine of the top 20 global banks, and six of the top ten US health care payers. We function as one team to make your goals our goals, whether that’s unlocking the value of generative AI or embedding analytics into workflows that reduce risk or power your growth. Clients choose EXL as their transformation partner for many reasons. Our geographic diversity make talent all over the world instantly accessible. Digital accelerators enable unmatched speed-to-value, letting you realize results fast. It’s our people that truly set us apart, though, including the 1,500 data scientists we have dedicated to our generative AI practice. And our more than twenty years of experience in delivering business services, garnering stellar client references, and maintaining a solid balance sheet are reassuring to our C-suite clients. Find out for yourself why clients, employees, and analysts think we’re some of the best in the business. Contact us to see how we can help you achieve your goals.
EXL Chennai, Tamil Nadu, IND Office
Chennai, India
Similar Jobs
Digital Media • Information Technology • News + Entertainment
Designs and customizes software applications, manages releases, gathers requirements, and improves functionality and user experience. Collaborates with stakeholders, QA, and cross-functional teams to deliver reliable solutions. Tracks performance metrics, maintains technical documentation, researches industry trends, and leads development, prototyping, and design sessions. Mentors junior engineers and exercises independent judgment while supporting variable work schedules.
Digital Media • Information Technology • News + Entertainment
Develops and optimizes data structures, ingestion frameworks, ETL pipelines, warehouses, and data lakes. Ensures data quality, governance, lineage, and compliance while supporting analytics and machine learning initiatives. Designs storage solutions across on-premises and cloud platforms, manages migrations, develops APIs, monitors data flows, collaborates with technology and analytics teams, and participates in code reviews and model deployments.
Top Skills:
Amazon RedshiftAPIsAws S3DatabricksETLKubernetesMinioTeradata
Digital Media • Information Technology • News + Entertainment
Designs and plans internal communications networks, tests and certifies network components, and ensures seamless integration and deployment. Requires expertise with Juniper and Cisco firewalls, firewall policy enforcement, network monitoring, JUNOS, Cisco IOS, and diagnostic tools. Familiarity with NetBrain, PRTG, Cisco DNA, Python, and Ansible is beneficial. The role requires a bachelor's degree, though equivalent education and experience may be considered.
Top Skills:
AiopsAnsibleCheck PointCiscoCisco DnaCisco IosFortinetJuniperJunosNetbrainPrtg Network MonitorPython
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.

