Lead Associate-2

2 weeks ago


Gurugram, India R1 RCM Full time

Role Objective

We are currently seeking a Lead Associate 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 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.

  • Assurance Associate 2

    2 weeks ago


    Gurugram, India RSM Full time

    We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You'll...

  • Assurance Associate 2

    2 weeks ago


    Gurugram, India RSM US LLP Full time

    We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You'll...


  • Gurugram, Haryana, India Mastercard Full time

    **Our Purpose** - Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation,...


  • Gurugram, Haryana, India Mastercard Full time

    Our Purpose - Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build _a sustainable economy_ where everyone can prosper. We support a wide range of digital payments choices, making _transactions secure,_ simple, smart and accessible. Our technology and innovation,...


  • Gurugram, India RSM US LLP Full time

    We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You'll...


  • Gurugram, Haryana, India RSM US LLP Full time

    We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll...


  • Gurugram, Haryana, India RSM US LLP Full time

    Location: Gurugram, Haryana - Time type: Full time - Job level: Associate - Job type: Regular - Category: Assurance Group - ID: JR111790 **About us**: We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full...

  • Associate

    2 weeks ago


    Gurugram, India Kaizen Law Full time

    Law Firm Description Founded in August 2022, Kaizen Law is an independent law firm headquartered in Gurgaon, India. Within just over two years, Kaizen Law has established itself as a leading firm in India's mid-market M&A and PE/VC transactions. We practice corporate law, M&A involving listed and unlisted companies, financial investments, securities...

  • Assurance Associate 2

    4 hours ago


    Gurugram, Haryana, India RSM US LLP Full time

    We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll...


  • Gurugram, Haryana, India RSM US LLP Full time

    We are the leading provider of professional services to the middle market globally, our purpose is to instill confidence in a world of change, empowering our clients and people to realize their full potential. Our exceptional people are the key to our unrivaled, inclusive culture and talent experience and our ability to be compelling to our clients. You’ll...