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:

Specialist is responsible for Designing, developing, and maintaining business intelligence solution using  SQL / SSIS/ Snowflake /Power BI. This position requires advanced technical expertise with SSIS,  Power BI , SQL and  Snowflake tools as well as a passion for innovating business processes. The analyst must be comfortable coordinating directly with clients, business stakeholders, and R1 product deployment teams to complete new data acquisition and data pipelines. This position is also responsible for solving data quality related issues and guiding other analysts to formulate and implement appropriate courses of action. This person must be an expert software developer and data analyst who will lead collaboration with other analysts to ensure accuracy and timeliness of project completion.

Snowflake Development

Database Design and Development: Create and maintain SQL Server Queries, including tables, views, indexes, and stored procedures.

ETL Processes: Design, develop, and manage ETL solutions using SQL Server Integration Services (SSIS) to acquire and prepare data from various sources.

Data Transformation: Build data transformations with SSIS, ensuring accurate and efficient data movement.

Performance Tuning: Debug and optimize SQL queries and SSIS packages to enhance performance.

Collaboration: Work closely with database administrators, business analysts, and other IT professionals to ensure seamless data integration and flow.

Documentation: Maintain comprehensive documentation for database designs, ETL processes, and data mappings.

Key duties & responsibilities:  

SSIS Development

Power BI Performance tuning, modeling, and optimization

Ability to look at various data load options and suggest an optimal way of proceeding

Excellent understanding of tools functions, limitations, and hidden features

Capacity estimation and administration

Component with power BI Desktop, Gateway, service, and report server.

Design, document and develop complex MS Power Platform (Power BI, Power APPs, etc.) solutions

Stay up to data on all new power BI features and functionalization and find ways to introduce them to the organization.

Data profiling, and data warehousing and Data lakes (preferable on snowflake)

Knowledge in Agile Software development

TSQL, SQL – database modeling, design, testing implementations and integration

Strong interpersonal and communication skills (verbal and written) along with strong planning and organization skills

Excellent team player, ability to work independently and as part of a team

Experience in mentoring junior developers and providing technical leadership

Certified in power BI is an added advantage

Experience, Skills and Knowledge:  

Bachelor’s degree in Computer Science / B.Tech/B.E/MCA

Minimum 6 - 7 years’ experience. 

5+ years of data analysis and SQL and SSIS Development experience is required 

Demonstrated exceptional analytical and problem-solving skills with strong attention to detail 

Excellent communications and strong commitment for delivering the highest level of service 

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

Technical Skills  -

Expert knowledge of SQL  Server Development 

Expert knowledge of SSIS  Development 

Experience with cloud-based data systems such as Snowflake or Databricks 

Experience with on-prem data systems such as MS SQL Server or PostgreSQL 

Experience with data integration tools such as SSIS, ADF, or Talend 

Experience with programming languages such as Python or .NET 

Key competency profile : 

Change Management, Expectations Management  

People Management, Conflict Management  

Spot new opportunities by anticipating change and planning accordingly  

Find ways to better serve customers and patients  

Be accountable for customer service of highest quality  

Create connections across teams by valuing differences and including others  

Own your development by implementing and sharing your learnings  

Motivate each other to perform at our highest level  

Help people improve by learning from successes and failures  

Work the right way by acting with integrity and living our values every day  

Succeed by proactively identifying problems and solutions for yourself and others