Business Analyst - SQL Tableau

Recruiter
Genpact
Location
Bangalore, Karnataka, India
Salary
Competitive salary
Posted
16 Sep 2021
Closes
17 Sep 2021
Ref
CPG020822
Job role
Business analyst, CFO
With a startup spirit and 90,000+ curious and courageous minds, we have the expertise to go deep with the world's biggest brands-and we have fun doing it. Now, we're calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us.

Are you the one we are looking for?

We are inviting applications for the role of Business Analyst, SQL, Tableau

We are looking for a Healthcare Data Analyst to gather and analyze healthcare data from multiple sources (e.g. Medical claims and Pharmacy claim, Patient/Provider behavior) to extract trends and business insights. Good understanding on Medicare and Medicaid data. Understanding of healthcare Drug codes, diagnosis & procedures codes. Knowledge of Extract Transform and Load (ETL) frameworks using SQL and analytical tools. Knowledge of Enterprise Data Warehouse (EDW) and data management systems. Excellent analytical and communication skills. Outstanding organizational and problem-solving aptitude.

In this role the individual will be responsible working with client internal departments owner to understand the challenges and scope out the needed metrics to track performance of the business unit. Should be able to clearly capture the scope and as part of this role, He /She should be able to understand the data structure and involve in developing SQL codes to store, sort, and retrieve data and build visualization on top of it using Tableau. The specific SQL needs can vary based on the organization and application, but the ability to write and optimize these codes is essential in this role. The key success of this role will be in gathering requirements and specifications from the end-users and understand how the database and its information will be used

Responsibilities
  • Strong in SQL to have the needed data fetched from the data warehouse and apply needed rules and bring in the appropriate visuals to generate business insights
  • Developing, maintaining, and managing dashboards and other BI solutions.
  • Performing and documenting data analysis, data validation, and data mapping/design.
  • Reviewing and improving existing systems and collaborating with teams to integrate new systems.
  • Conducting unit tests and developing database queries to analyze the effects and troubleshoot any issues.
  • Ability to multitask and manage time between various projects
  • Ability to use existing SQL codes and understand the metrics and build on top of it
  • an efficient code that could optimize the performance and come up with suggestions and improvements.
  • Fix any issues related to database performance and provide corrective measures

Minimum Qualifications
  • Bachelor's degree or equivalent and work experience in Healthcare, Statistics, Mathematics, or a related field
  • Candidate must have a experience in Healthcare Analytics domain
  • Strong in coding SQL queries and Expertise in Tableau
  • Good exposure of Store procedures, functions and triggers
  • Good understanding of DB structure, Queries builder
  • Ability to articulate and document the needs and business understandings for end users
  • Experience in Python/R will be additional advantage.
  • Good Communication Skill


Preferred qualifications
  • Able to nurture robust working relationships with the team, peers and clients, scheduling flexibility required
  • Overall candidate should have problem solving, macro-level research and analytics approach and good in numbers.
  • Good people and customer handling skills.
  • Effective communication and interpersonal skill.

Similar jobs

Similar jobs