Senior Consultant - BI

As a Senior Consultant, you will work closely with internal and external stakeholders and deliver high quality analytics solutions to real-world Pharma commercial organization's business problems. You will bring deep Pharma / Healthcare domain expertise and use cloud data tools to help solve complex problems

Key Responsibilities

• Collaborate with internal teams and client stakeholders to deliver Business Intelligence solutions that support key decision-making for the Commercial function of Pharma organizations.
• Leverage deep domain knowledge of pharmaceutical sales, claims, and secondary data to structure and optimize BI reporting frameworks.
• Develop, maintain, and optimize interactive dashboards and visualizations using Tableau (primary), along with other BI tools like Power BI or Qlik, to enable data-driven insights.
• Translate business requirements into effective data visualizations and actionable reporting solutions tailored to end-user needs.
• Write complex SQL queries and work with large datasets housed in Data Lakes or Data Warehouses to extract, transform, and present data efficiently.
• Conduct data validation, QA checks, and troubleshoot stakeholder-reported issues by performing root cause analysis and implementing solutions.
• Collaborate with data engineering teams to define data models, KPIs, and automate data pipelines feeding BI tools.
• Manage ad-hoc and recurring reporting needs, ensuring accuracy, timeliness, and consistency of data outputs.
• Drive process improvements in dashboard development, data governance, and reporting workflows.
• Document dashboard specifications, data definitions, and maintain data dictionaries.
• Stay up to date with industry trends in BI tools, visualization of best practices and emerging data sources in the healthcare and pharma space.
• Prioritize and manage multiple BI project requests in a fast-paced, dynamic environment.

Qualifications

Education

Skills Required

BigQuery, Power Bi, data warehouses , Tableau, Redshift, Sql, snowflake , Qlik, Data Profiling, Data Governance