LCCI BI&A IBU Analytics Japan – Sr. Associate Consultant

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

LCCI BI&A IBU Analytics Japan – Sr. Associate Consultant

This role will be based in the LCCI BI&A Japan Team and work closely with Japan Commercial Analytics Team in providing high quality analytical support to Brand, Market Research and other internal partners in Japan BU through right data, smart analytics and actionable insights.

The LCCI BI&A team comprises of creative problem solvers who support achievement of the brand’s goals, while always striving for process improvement and innovation.

The LCCI Business Insights & Analytics associate will do data analysis to support achievement of the brand’s goals, while always striving for process improvement and innovation

Key Responsibilities:

• Project Execution: as individual contributor, responsible for
  • Building and exhibiting deep expertise on available data sets and supports data enabled decision making using data from external suppliers (JDI, JPM, DDD, etc.) in Japan and internal data for various other sources in Eli Lilly Japan
  • Ensuring high stakeholder satisfaction through consistent delivery of high quality, timely and insightful outputs throughout analytics value chain on various objectives related to –
    • RWD engineering and analytics
      • Build comprehensive understanding of Japan RWD datasets (MDV/JMDC/IQVIA E360), create and maintain optimal data pipeline architecture ETL/ ELT into structured data
      • Build analytics tools that utilize the data pipeline to provide actionable insight into patient behaviour and treatment journey
    • Brand descriptive analytics and visualization to provide data-based insights on planning, measurement and segmentation e.g. Lilly brand performance, market monitoring, new brand launches, customer analysis
    • Market intelligence reporting 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.
    • Data support through data mining and warehousing
  • 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
  • Participating in meetings with stakeholders and communicating the final outputs and recommendations

• Project Delivery: as team member, supporting the team lead in driving
  • quality, speed, value and compliance throughout the analytics value chain
  • project management for seamless project execution, prioritization and high-quality delivery
  • creation and maintenance of standard operating procedures (SOPs), quality checklists that will enable excellent quality outputs
  • shared learning forums to identify challenges and establish best practices
  • expansion of analytical capability of the team by taking on more complex projects and delivering value
  • process improvements and implementation of analytical best practices

Education:

• Degree in sciences or quantitative discipline i.e. Finance, Econometrics, Statistics, Engineering or Computer Sciences. Experience in pharma/healthcare industry is preferable.

Experience:

• 4-6 years of analytics experience with demonstrated ability to think strategically in an ambiguous environment in analytics
• Experience in pharma industry is preferable
• Experience building and optimizing “big data” data pipelines, architectures and data sets
• Technical Skills
  • Strong experience in SQL
  • Strong experience in R, Python, Knime (at least 1)
  • Experience with relational SQL databases, especially AWS Redshift.
  • Experience with AWS cloud services Preferable: S3, EC2, Lambda, Glue, EMR, RDS, Pyspark highly, preferred. Experience with similar services on another platform would also be considered.
  • Strong knowledge of various pharma databases (high preference for Japan dataset and landscape knowledge including JDI, JPM, DDD, Ultmarc, M3/NMO/MedPeer/Carenet etc.)
  • Experience in data visualization tools e.g. Tableau/PowerBI (added advantage)
  • Advanced MS-office skills (MS-Excel and MS-PowerPoint)
• Analytical Skills
  • Strong experience in business analytics including insight generation for commercial leadership.
  • Experience in data manipulation, cleaning and preparation (database querying, descriptive statistics)
  • Problem solving skills and lateral thinking ability
  • An eye for detail
• Soft Skills
  • Strong work ethic and personal motivation
  • Good presentation skills
  • Experience in working with business partners located in another country, especially non-English speaking country like Japan
  • Interpersonal and communication skills with ability to work across time zones
  • Ability to operate effectively in an international matrix environment
  • Strong stakeholder management skills
  • Strong team player who is dynamic and result-oriented

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