Talent.com
Associate Consultant / Senior Associate Consultant- Business Insights and Analytics NAPAC

Associate Consultant / Senior Associate Consultant- Business Insights and Analytics NAPAC

ConfidentialBengaluru / Bangalore, India
10 days ago
Job description

At Lilly, we unite caring with discovery to make life better for people around the world. We are a global healthcare leader headquartered in Indianapolis, Indiana. Our employees around the world work to discover and bring life-changing medicines to those who need them, improve the understanding and management of disease, and give back to our communities through philanthropy and volunteerism. We give our best effort to our work, and we put people first. We're looking for people who are determined to make life better for people around the world.

Job Description

This role will be based in the LCCI Commercial BI&A team and work closely with the NAPAC (Australia, New Zealand, Hong Kong, South Korea and Taiwan) BI&A / OCE team to provide high-quality market intelligence support to drive better customer experience and business impact. NAPAC BI&A team is well established and works closely with brand teams to provide data insights and enable informed decision-making.

Project Execution

  • Build and exhibit deep expertise on available data sets and supports data-enabled decision-making using data from external suppliers in NAPAC and internal data from various other sources.
  • Consistent delivery of high-quality, timely, and insightful reports to enable brand and senior leadership to track the performance of Eli Lilly brands.
  • Develop and publish regular market intelligence reports on KPIs related to Sales, sales growth, wholesaler inventory, market share, market growth, sales force activity, P2P and non-personal channel promotional impressions and engagement metrics, etc.
  • Work on prescriptive and predictive analytical models to answer unstructured questions from the business.
  • Map physician's journey in an omnichannel environment
  • Understand the preferred communication channel for a physician.
  • Calculate ROI of various marketing tactics.
  • Developing into a trusted advisor by actively participating in various phases of the project, including kick-off, methodology development, execution, insight generation and data visualization, and results presentation to various stakeholders
  • Find and execute opportunities for productivity improvements by automation or process changes.

Requirements

  • Preferred degree in sciences or quantitative discipline, i.e., Econometrics, Statistics, Engineering, or Computer Sciences
  • At least 3-5 years of evolving experience in business / market intelligence, performance reporting, and descriptive analytics for Marketing or other commercial leadership, with demonstrated results in understanding, structuring, and making sense of unfamiliar and messy datasets in the pharma Industry.
  • Experience in working on prescriptive analytical problems like physician journey and behaviour changes, ROI modelling, forecasting.
  • Exposure to advanced analytics algorithms to create predictive data models.
  • Experience in working with business partners located in another country.
  • Interpersonal and communication skills, with the ability to work remotely across time zones.
  • Ability to operate effectively in an international matrix environment.
  • Preferred Technical Skills

  • Hands-on experience of managing and querying data on a range of relational data servers
  • Expertise in writing and debugging efficient SQL queries, Python or R (one of them), Excel and VBA
  • Experience in designing, developing, and deploying Reports, Dashboards, and Apps in Power BI including
  • Expertise in Power BI DAX and Power Query M-Code
  • Solid understanding of Data warehousing and BI concepts & building Data Models in Power BI.
  • Alteryx / KNIME experience highly desirable
  • Experience with the following technologies : Cloud platforms like AWS & Azure
  • Experience in business analytics tasks like data cleaning, preparation, and basics of good reporting
  • Experience in pharmaceutical forecasting is good to have.
  • Lilly is dedicated to helping individuals with disabilities to actively engage in the workforce, ensuring equal opportunities when vying for positions. If you require accommodation to submit a resume for a position at Lilly, please complete the accommodation request form (https : / / careers.lilly.com / us / en / workplace-accommodation) for further assistance. Please note this is for individuals to request an accommodation as part of the application process and any other correspondence will not receive a response.

    Lilly does not discriminate on the basis of age, race, color, religion, gender, sexual orientation, gender identity, gender expression, national origin, protected veteran status, disability or any other legally protected status.

    #WeAreLilly

    Skills Required

    Alteryx, Power Bi, Sql, Vba, Knime, Excel, Dax, Azure, Python, Aws

    Create a job alert for this search

    Associate Consultant • Bengaluru / Bangalore, India

    Related jobs
    • Promoted
    • New!
    Operational Excellence (Digital Enterprise)_Associate Manager

    Operational Excellence (Digital Enterprise)_Associate Manager

    Biocon BiologicsGreater Bengaluru Area, India
    Biocon Biologics is a subsidiary of Biocon Ltd, an innovation led global biopharmaceuticals company.Biocon Biologics is engaged in developing high quality, affordable biosimilars that can expand ac...Show moreLast updated: 6 hours ago
    • Promoted
    Senior Solutions Development Consultant

    Senior Solutions Development Consultant

    TELUS Digitalhosur, tamil nadu, in
    TELUS Digital focuses on the value of human connection to design, build and deliver high-tech, high-touch customer experiences powered by next-gen digital solutions. With over 70,000 team members an...Show moreLast updated: 1 day ago
    • Promoted
    Lead Consultant

    Lead Consultant

    Best Infosystems Ltd.Greater Bengaluru Area, India
    Lead Consultant_Full-Time_Bangalore / Pune / Navi Mumbai / Noida / Chennai.Bangalore / Pune / Navi Mumbai / Noida / Chennai. Excellent knowledge and experience in Oracle.Excellent knowledge master data management (...Show moreLast updated: 30+ days ago
    • Promoted
    Consultant

    Consultant

    IQVIABengaluru, Karnataka, India
    Job title : Associate Consultant.Location : Bangalore or Gurgaon.Must have skill : Market Analysis |Pricing Analysis |Market Access |Price Forecasting |VBA Excel | Market Research |Healthcare Consu...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Associate

    Senior Associate

    PwC Acceleration Center Indiabangalore, karnataka, in
    Main purpose of the job and key background information.ETS Oracle provides a broad range of assess and recommend services specific to the Oracle related to controls around the financial reporting p...Show moreLast updated: 30+ days ago
    • Promoted
    Sr. Analyst or Associate

    Sr. Analyst or Associate

    Tequity Advisorshosur, tamil nadu, in
    Tequity Advisors is dedicated to achieving the best outcomes for our clients through successful M&A transactions within Cloud, SaaS, and IT ecosystems. Leveraging our deep industry knowledge and glo...Show moreLast updated: 2 days ago
    • Promoted
    Principal Analytics Consultant

    Principal Analytics Consultant

    Prospectionhosur, tamil nadu, in
    Are you passionate about turning real-world healthcare data into actionable insights that improve patient outcomes? At.RWD) to deliver high-impact outcomes for pharmaceutical companies, healthcare ...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Consultant

    Senior Consultant

    ValorantBengaluru, IN
    Valorant is a fast-growing consulting firm at the intersection of procurement and AI.We help global clients — across private equity, technology, life sciences, financial services, industrials, and ...Show moreLast updated: 30+ days ago
    • Promoted
    BIG QUERY CONSULTANT

    BIG QUERY CONSULTANT

    APPIT Software Inchosur, tamil nadu, in
    Design, build and optimize large volume data pipelines using Big Query on Google Cloud Platform.Work on complex SQL, performance tuning, query optimization and large data processing workloads.Imple...Show moreLast updated: 7 days ago
    • Promoted
    Kyriba Implementation Consultant

    Kyriba Implementation Consultant

    MPC Cloud Consulting Pvt Ltdhosur, tamil nadu, in
    MPC Cloud Consulting are looking for.Kyriba Implementation Consultant.Kyriba Implementation Consultant.Payments, and bank reconciliations. This requires strong experience of Kyriba modules especiall...Show moreLast updated: 1 day ago
    • Promoted
    Associate Director - Advanced Analytics

    Associate Director - Advanced Analytics

    KMK Consulting Inc.hosur, tamil nadu, in
    KMK is a global data analytics and technology consulting company empowering leaders across the Life Sciences industries to make better data-driven decisions. Our data analytics and software platform...Show moreLast updated: 30+ days ago
    • Promoted
    Accounting Ai Transformation - Senior Associate / Lead

    Accounting Ai Transformation - Senior Associate / Lead

    Maximor AIBengaluru, Republic Of India, IN
    Chartered Accountant with 3–5 years of post-qualification experience.Big4 or top-tier accounting background.Accounting × AI Transformation team. This is a high-impact role at the intersection of.You...Show moreLast updated: 30+ days ago
    • Promoted
    Associate Director, Data Architecture (Snowflake • Databricks • AWS • CPG / FMCG • Enterprise Data)

    Associate Director, Data Architecture (Snowflake • Databricks • AWS • CPG / FMCG • Enterprise Data)

    Sky Systems, Inc. (SkySys)hosur, tamil nadu, in
    Associate Director, Data Architecture.Full-Time Contract (40hrs / week).Months+ (with a possibility of Contract-to-Hire). Marketing, Product, Finance, Supply Chain, and global business teams.This role...Show moreLast updated: 2 days ago
    • Promoted
    Consulting Manager – Digital Adoption Platform (DAP) Strategy & Leadership

    Consulting Manager – Digital Adoption Platform (DAP) Strategy & Leadership

    ISG (Information Services Group)hosur, tamil nadu, in
    Website : Leading Global Technology Research & Advisory Firm | ISG (isg-one.Wanted : dynamic and creative individuals ready to connect with a like-minded team. You’ll enjoy all the autonomy you need t...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Azure Integration Consultant

    Azure Integration Consultant

    CloudScaler Technologies B.V.hosur, tamil nadu, in
    Job Title : Azure Integration Consultant.We are looking for an Azure Integration Consultant with strong hands-on experience in building and maintaining Azure-based integration solutions.The role inv...Show moreLast updated: 17 hours ago
    • Promoted
    Accounting AI Transformation - Senior Associate / Lead (3+ PQE CA)

    Accounting AI Transformation - Senior Associate / Lead (3+ PQE CA)

    Maximor AIBengaluru, Karnataka, India
    Chartered Accountant with 3–5 years of post-qualification experience.Big4 or top-tier accounting background.Accounting × AI Transformation team. This is a high-impact role at the intersection of.You...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Consultant

    Consultant

    Tata Consultancy ServicesGreater Bengaluru Area, India
    High Radius Architect & Consultant.Location : Blr / Pune / Hyd / BBSR / Chennai / Kochi.Show moreLast updated: 6 hours ago
    • Promoted
    Consulting Actuary

    Consulting Actuary

    XceedanceBengaluru, Karnataka, India
    Led by the Chief Actuary, Xceedance has announced the expansion of global Actuarial and Analytics (A&A) Services to better align with the strategic objectives and commitments of insurance organizat...Show moreLast updated: 9 days ago