Clips

Threads

Jobs

Channels

Pharma Analytics

Full–time

Posted on: 4 days ago

  • *Project Role:** Pharma Analytics
  • *Work Experience:** 4 to 7 Years
  • *Work location:** Bangalore/Pune/Gurugram
  • *Work Mode:** Hybrid
  • *Must Have Skills:** General Analytics, Proficient SQL, Advance Excel, US Healthcare experience, statistical knowledge.
  • *Job Overview:**

    • This position provides strategic and tactical support to the organization by analyzing, processing and interpreting client data in support of the sales and operations processes. Expertise and work efforts are focused on the analysis of the clients business goals, objectives and needs and the general business environment. Understanding the analysis requirements from internal or external customers and executing those requirements is critical. Candidate must understand relational database management, as well as have the required experience with SQL, Python/R and Excel. In addition, this individual would have the ability to function both independently and within a group. The ideal candidate will be very attentive to detail and perform with a high degree of accuracy. This position requires flexibility to handle a variety of tasks at one time and strong initiative.
  • *Primary job responsibilities include:**
  • Create ad hoc and standard reports using Microsoft SQL Server for different functional areas of the company
  • Data wrangling on SQL, Hive, Impala, Python
  • Assess reporting results through data investigation, analysis, and evaluation
  • Analyzes complex business questions and issues using data from internal and external sources to provide feedback to decision-makers with a full understanding of area of specialization.
  • Identifies and interprets trends and patterns in datasets to support the development of recommendations
  • QA reports for not only coding errors and issues, but also make suggestions on data representation
  • Strong Written and Communications Skills
  • Ability to gather and interpret relevant data and information
  • Ability to determine the interrelationships between solutions and requirements
  • Highly Organized, thereby efficiently handling multiple data jobs/sets
  • Ability to think analytically and should be a problem solver
  • Ability to make effective decisions under pressure
  • *Required Skills:**
  • Hands on experience with data and data queries, data processing/data transformations, Data integration scenarios
  • Experience with LRx, Dx, Claims datasets, Pharma Sales data and processes is preferred
  • 5+ years current & continuous experience with Microsoft SQL Server
  • 3+ years current & continuous experience with Microsoft PowerBI, Python, and SQL Server Reporting Services (SSRS) a plus
  • Knowledge of statistical software a plus
  • Strong Excel skills (Pivot tables, vlookups, etc.)
  • Shell scripting (on windows platform)
  • Good communication skills
  • Bachelors degree or equivalent experience