Company Profile:

R1 India is proud to be recognized amongst Top 25 Best Companies to Work For 2024, by the Great Place to Work Institute. This is our second consecutive recognition on this prestigious Best Workplaces list, building on the Top 50 recognition we achieved in 2023. Our focus on employee wellbeing and inclusion and diversity is demonstrated through prestigious recognitions with R1 India being ranked amongst Best in Healthcare, Top 100 Best Companies for Women by Avtar & Seramount, and amongst Top 10 Best Workplaces in Health & Wellness. We are committed to transform the healthcare industry with our innovative revenue cycle management services. Our goal is to ‘make healthcare work better for all’ by enabling efficiency for healthcare systems, hospitals, and physician practices. With over 30,000 employees globally, we are about 16,000+ strong in India with presence in Delhi NCR, Hyderabad, Bangalore, and Chennai. Our inclusive culture ensures that every employee feels valued, respected, and appreciated with a robust set of employee benefits and engagement activities.

Job description:

Role Objective
We are currently seeking a “Lead - BI Analytics” to contribute to Analytics & BI Development process. This is a hands-on technical and Individual Contributor role. This position requires that the candidate be a skilled on Advance Excel, SQL, Python and support on Reporting and Analytics applications. The candidate needs to have strong technical knowledge and be very structured and analytical in his/her approach.

Essential Duties and Responsibilities
Primary responsibility involves advanced SQL and advanced Excel report design and development.
Publishing and scheduling SSIS\SSRS report as per the business requirements.
Will be responsible for END TO END BI & Visualization solutions development and projects delivery across multiple clients.
Drive the development and analysis of data, reporting automation, Dash boarding, and business intelligence programs.
Would be supporting in consulting engagement and should be able to articulate and architect the solution effectively to bring-in the values which data analytics & visualization solution can deliver.
Good understanding of database management systems and ETL (Extract, transform, load) framework
Connecting to data sources, importing data and transforming data for Business Intelligence.
Experience in using advance level calculations on the data set.
Responsible for design methodology and project documentation.
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
Should have knowledge and experience in prototyping, designing, and requirement analysis.

Qualifications
Graduate (BE-BTECH)Computer science /BCA/MCA/MSc Computers) or have an equivalent academic qualification
Good communication Skills (both written & verbal)
3+ years’ experience in Reporting and Analytics with Python, Snowflake, SQL and excel must have prior experience on Relational Database and BI developer using SQL server, SSIS, Power BI, Tableau, Advance Excel. 

Skill Set: Good to have:
Experience on Design and develop relational database models/schemas and Query performance tuning and write ad-hoc SQL queries.
Exposure to Snowflake would be an added advantage
Experience with advanced query design, stored procedures, views, functions. 
Ability to communicate with technical and business resources at many levels in a manner that supports progress and success.
Understanding of Python and different libraries - Pandas, Numpy etc 
Exposure to Cloud Computing such as Microsoft Azure
Good knowledge/expertise on different versions of .Microsoft Sql Server 2008, 2012, 2016, 2017, 2020