Company Profile:

R1 is a leading provider of technology-driven solutions that help hospitals and health systems to manage their financial systems and improve patients’ experience. We are the one company that combines the deep expertise of a global workforce of revenue cycle professionals with the industry's most advanced technology platform, encompassing sophisticated analytics, Al, intelligent automation and workflow orchestration. R1 is a place where we think boldly to create opportunities for everyone to innovate and grow. A place where we partner with purpose through transparency and inclusion. We are a global community of engineers, front-line associates, healthcare operators, and RCM experts that work together to go beyond for all those we serve. Because we know that all this adds up to something more, a place where we're all together better. 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:

We are currently seeking a “Lead Analyst” to work in Analytics & BI Development processes. This is a hands-on technical and Individual Contributor role. This position requires that the candidate be a skilled on SQL (Must), Advance Excel, Power BI and support on Analytics applications. The candidate needs to have strong technical knowledge and be very structured and analytical in his/her approach.

Essential Technical Duties and Responsibilities

3+ years- experience where primary responsibility involves writing complex SQL queries, building views and Store procedures.

Proficiency in SQL and experience with database management systems.

Design, develop, and maintain SQL views and stored procedures.

Write complex SQL queries to extract, manipulate, and analyze data.

Optimize database performance by tuning SQL queries and indexing.

Collaborate with software developers and data analysts to integrate SQL views and stored procedures with applications.

Excellent communication skills and ability to translate the complex to simple and easier terms for business leaders and users of data.

Good to have knowledge and skills for Cloud Computing such as Microsoft Azure, Snowflake

In-depth understanding of database management systems and ETL (Extract, transform, load) framework.

Should know how to develop Transition Tool Kit, Documentations, SOP, Artifacts.

Should know all data driven technologies and have hands-on in End-to-End Analytics which include Story-telling, Descriptive, Diagnostics, Predictive and Prescriptive Analysis.  

Drive the development and analysis of data, reporting automation, Dash boarding, and business intelligence program.

Qualifications

Graduate (BE-BTEC Computer science /BCA/MCA/MSc Computers) or have an equivalent academic qualification

Good communication Skills (both written & verbal)

Skill Set

3 + years’ experience on Relational Database and BI developer using SQL server(Must), Advance Excel(Desired) and Power BI  (Good To have)       

Extensive experience on Design and develop relational database models/schemas and Query performance tuning and write ad-hoc T-SQL queries.

Experience with advanced query design, stored procedures, views and functions.                             

 Experience with SQL Server & Data Warehouse Concepts.                              

Working knowledge of statistical modeling and analysis.                  

Strong oral and written communication skills.     

Ability to communicate with technical and business resources at many levels in a manner that supports progress and success.