Lead Associate-2

R1 is leading provider of technologydriven 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 industrys 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 frontline 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 were 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 amongst Top 50 Best Workplaces for Millennials Top 50 for Women Top 25 for Diversity and Inclusion and Top 10 for Health and 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 30000 employees globally we are about 17000 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.

Role Objective

We are currently seeking a Lead Associate to work in Analytics & BI Development processes. This is a handson 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 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
• Indepth 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 handson in EndtoEnd Analytics which include Storytelling Descriptive Diagnostics Predictive and Prescriptive Analysis.
• Drive the development and analysis of data reporting automation Dash boarding and business intelligence program.

Qualifications

• Graduate (BEBTEC 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 adhoc TSQL 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.

Working in an evolving healthcare setting we use our shared expertise to deliver innovative solutions. Our fastgrowing team has opportunities to learn and grow through rewarding interactions collaboration and the freedom to explore professional interests.

Our associates are given valuable opportunities to contribute to innovate and create meaningful work that makes an impact in the communities we serve around the world. We also offer a culture of excellence that drives customer success and improves patient care. We believe in giving back to the community and offer a competitive benefits package. To learn more visit:

Visit us on Facebook