Position Summary

To be a technology expert architecting solutions and mentoring people in BI / Reporting processes with prior expertise in the Pharma domain.

Job Responsibilities Independently, he/she should be able to drive and deliver complex reporting and BI project assignments in PowerBI on AWS/Azure Cloud. Should be able to design and deliver across Power BI services, Power Query, DAX, and data modelling concepts. Should be able to write complex SQLs focusing on Data Aggregation and analytic calculations used in the reporting KPIs. Be able to analyse the data and understand the requirements directly from customer or from project teams across pharma commercial data sets Should be able to drive the team on the day-to-day tasks in alignment with the project  plan and collaborate with team to accomplish milestones as per plan. Should be comfortable in discussing and prioritizing work items in an onshore-offshore model. Able to think analytically, use a systematic and logical approach to analyse data, problems, and situations. Manage client communication and client expectations independently. Should be able to deliver results back to the Client as per plan. Should have excellent communication skills. Education BE/B.TechMaster of Computer ApplicationWork Experience Should have 4-8 years of working on experience in developing Power BI reports. Must have proficiency in Power BI services, Power Query, DAX, and data modelling concepts. Should have experience in design techniques such as UI designing and creating mock-ups/intuitive visualizations seamless user experience.  Should have expertise in writing complex SQLs focusing on Data Aggregation and analytic calculations used for deriving the reporting KPIs. Strong understanding of data integration, ETL processes, data warehousing , preferably on AWS Redshift and/or Snowflake. Excellent problem-solving skills with the ability to troubleshoot and resolve technical issues. Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams. Good to have experience in the Pharma Commercial data sets and related KPIs for Sale Performance, Managed Market, Customer 360, Patient Journey etc. Good to have experience and additional know-how on other reporting tools. Behavioural Competencies Teamwork & LeadershipMotivation to Learn and GrowOwnershipCultural FitTalent ManagementTechnical Competencies Problem SolvingLifescience KnowledgeCommunicationCapability Building / Thought LeadershipPower BISQLBusiness Intelligence(BI)Snowflake