Lead Associate

R1 RCM, Inc.; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

R1 RCM is looking for a Lead - BI Analytics in Gurugram District, India. This hands-on technical role requires advanced skills in SQL, Python, and Excel, along with a strong background in Reporting and Analytics. Responsibilities include developing BI visualization solutions, scheduling reports, and automating data workflows.

Candidates should have a relevant degree and 4+ years of experience in database management and BI tools like SSIS and Power BI. Good communication skills are essential for success in this role.

Qualifications

• 4+ years experience in Reporting and Analytics with advanced SQL, Python, and Excel.
• Prior experience on Relational Database and BI development.
• Good communication skills, both written and verbal.

Responsibilities

• Design and develop advanced SQL and Excel reports.
• Publish and schedule SSIS/SSRS reports as per business needs.
• Lead END TO END BI Visualization solutions development.

Skills

Advanced Excel

SQL

Python

Business Intelligence (BI)

Data Visualization

SSIS

Reporting Automation

Education

Graduate (BE-BTECH Computer science /BCA/MCA/MSc Computers)

Tools

Power BI

Snowflake

SQL Server

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-BTEC Computer science /BCA/MCA/MSc Computers) or have an equivalent academic qualification Good communication Skills (both written verbal) 4+ years experience in Reporting and Analytics with Python, SQL and excel must have prior experience on Relational Database and BI developer using SQL server, SSIS, Power BI, Snowflake, 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 ab 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