Analyst - Reporting Solution

Job title: Analyst

• Hiring Manager: Team Lead Commercial Analytics
• Location: Hyderabad
• % of travel expected: Travel required as per business need, if any
• Job type: Permanent and Full time

About the job

Our Team:

Sanofi Global Hub (SGH) is an internal Sanofi resource organization based in India and is setup to centralize processes and activities to support Specialty Care, Vaccines, General Medicines, CHC, CMO, and R&D, Data & Digital functions​. SGH strives to be a strategic and functional partner for tactical deliveries to Medical, HEVA, and Commercial organizations​ in Sanofi, Globally.

Main responsibilities:

The overall purpose and main responsibilities are listed below:

• At our Sanofi we are leveraging analytics and technology, on behalf of patients around the world. We are seeking those who have a passion for using data, analytics, and insights to drive decision making that will allow us to tackle some of the world’s greatest health threats.
• Within our commercial Insights, Analytics, and Data organization we are transforming to better power decision-making across our end-to-end commercialization process, from business development to late lifecycle management.
• Deliverables support planning and decision making across multiple functional areas such as finance, manufacturing, product development and commercial.
• In addition to ensuring high-quality deliverables, our team drives synergies across the franchise, fosters innovation and best practices, and creates solutions to bring speed, scale and shareability to our planning processes. As we endeavour, we are seeking a dynamic talent for the role of “Analyst Reporting Solution”.
• We are looking for a team member to support our analytics team based out of US. Robust analytics is a priority for our businesses, as the product potential has major implications to a wide range of disciplines.
• It is essential to have someone who understands and aspires to implement innovative analytics techniques to drive our insights generation across franchises.
• Will assist in managing adhoc and regular reporting requests
• He/she will ensure reporting and follow ups on Project Management activities, project resources, budget, and timelines
• He/she will ensure on time and accurate delivery of all analytics and dashboard requirement by collaborating with relevant stakeholders
• He/she will ensure dashboards and metrics are maintained as per requirements
• Responsible for access management of all Smartsheet trackers and Dashboard
• Ensuring data consistency across all dashboards and analytics requirements
• Pro-actively identifying analytical requirements
• Developing SOPs for dashboards and other analytical needs
• Providing training on analytical tools and usage
• Building advance tools and automate or improve processes for analytical and other needs

• People:
  • Maintain effective relationship with the end stakeholders within the allocated GBU and tasks – with an end objective to develop report and analysis as per requirement
  • Collaborate with global stakeholders for project planning and setting up the timelines and maintaining budget
  • Performance indicators: Stakeholder feedback to be maintained completed task as expected
    • 20%
• Performance:
  • Refresh Existing Reports and identifies improvement opportunities in reporting and BI tools and as needed structure / functionality with the latest insights as they become available
  • Create dashboards to synthesize and visualize key information and enable business decisions
  • Works to develop deal tracking analytics and reporting capabilities
  • Collaborates with Digital to enhance data access across various sources, develop tools, technology, and process to constantly improve quality and productivity
  • Developing a deep understanding of our CRM data model and the workings of the Veeva platform.
  • Developing insights and visualizations from Veeva activity data as well as other external data sources using MyInsights Studio and HTML5 coding (when necessary) to build MyInsights Dashboards.
  • Will be responsible for reporting of monthly sales reporting by gathering the data provided by the partners, data cleansing if necessary, uploading into the data lake, production of the reports according to agreed template and gathering of associated business insights from the business.
  • Develop and support tool to ensure robustness and unique sourcing of Pricing information with customer
  • He/she will ensure dashboards and metrics are maintained as per requirements
  • Ensuring data consistency across all dashboards and analytics requirements
  • Pro-actively identifying analytical requirements
  • Developing SOPs for dashboards and other analytical needs
  • Providing training on analytical tools and usage
  • Performance indicators:
    • Report QC standards to be maintained
    • Timely support for generating specific reports
  • Weightage: 60%
• Process:
  • Support delivery of projects in terms of resourcing, coordination, quality, timeliness, efficiency, and high technical standards for deliveries
  • Secure adherence to compliance procedures and internal/operational risk controls in accordance with all applicable standards
  • Refresh report on frequency/cycle basis (weekly/monthly/quarterly/annually), along with QC checks for each refresh
  • Ensure on time and accurate delivery of all analytics and dashboard requirements
  • Ensure data quality and consistency is maintained throughout the lifecycle of tracker/dashboard
  • Pro-actively identifying analytical requirements
  • Understanding analytical requirement of all relevant stakeholders and develop solution accordingly
  • Continuously exploring the new features and add on, assess different tools to improve the overall performance in a cost-effective way
  • Developing SOPs for dashboards and other analytical needs elements (hotspots, links, etc.)
  • Performance indicators: Feedback from stakeholders on satisfaction with deliverables
  • Weightage: 20%

About you

• Experience: 3+ years' experience with analytical tools such as (Advanced Excel & Power BI). In-depth knowledge of common databases like IQVIA, APLD, Engagement and execution data, etc.
• Soft skills: Strong learning agility; Ability to manage ambiguous environments, and to adapt to changing needs of the business; Good interpersonal and communication skills; strong presentation skills a must; Team player who is curious, dynamic, result oriented and can work collaboratively; Ability to think strategically in an ambiguous environment; Ability to operate effectively in an international matrix environment, with ability to work across time zones; Demonstrated leadership and management in driving innovation and automation leveraging advanced statistical and analytical techniques
• Technical skills:
  • Experience of developing and managing dashboards
  • Excellent planning, design, project management and documentation skills
  • Strong project management abilities; capable of prioritizing and handling multiple projects simultaneously
  • Proficiency of programming languages (e.g. SQL, SAS, Python, R, VBA)
  • Strong experience using analytical platforms (e.g. Databricks, Jupyter Notebook, SQL developers, etc)
  • Experience with pharmaceutical data sources and CRM data systems (e.g. IQVIA, Symphony, Komodo, Veeva CRM , Salesforce)
  • Experience of using analytical tools like Power BI, Qliksense, Tableau, Smartsheet, and Alteryx etc;
  • Expert knowledge of Excel and proficiency in VBA
  • Experience of developing and managing dashboards
  • Project management abilities; capable of prioritizing and handling multiple projects simultaneously
  • An aptitude for problem solving and strategic thinking
  • Ability to synthesize complex information into clear and actionable insights
  • Proven ability to work effectively across all levels of stakeholders and diverse functions
  • Solid understanding of pharmaceutical development, manufacturing, supply chain and marketing functions
  • Demonstrated leadership and management in driving innovation and automation leveraging advanced statistical and analytical techniques
• Education: Bachelor’s or Master’s degree in areas such as Information Science/Operations/Management/Statistics/Decision Sciences/Engineering/Life Sciences/Business Analytics or related field (e.g., PhD / MBA / Masters);
• Languages: Excellent knowledge in English and strong communication skills – written and spoken