Job Description:
As a Senior Associate, 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 PowerBI (primary), along with other BI tools like Tableau/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:
3+ years of experience in BI development, reporting, or data visualization, preferably in the pharmaceutical or life sciences domain.
- Strong hands-on experience building dashboards using Power BI.
- Advanced SQL skills for querying and transforming data across complex data models.
- Familiarity with pharma data such as Sales, Claims, and secondary market data is a strong plus.
- Experience in data profiling, cleansing, and standardization techniques.
- Ability to translate business questions into effective visual analytics.
- Strong communication skills to interact with stakeholders and present data insights clearly.
- Self-driven, detail-oriented, and comfortable working with minimal supervision in a team-oriented environment.
- Exposure to data warehousing concepts and cloud data platforms (e.g., Snowflake, Redshift, or BigQuery) is an advantage.
Education
Bachelor’s or Master’s Degree (computer science, engineering or other technical disciplines)