Skip to main content

This job has expired

Analyst -Data Engineering

Employer
Confidential
Location
Hyderabad Hyderabad Telangana, Telangana, India
Salary
Competitive Salary
Closing date
Jun 24, 2024

View more

Job Role
Other
Sector
Finance
Contract Type
Permanent
Hours
Full Time
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-Data Engineering
  • 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 different franchises.
  • People :
    • Maintain effective relationship with the end stakeholders within the allocated GBU and tasks - with an end objective to develop education and communication content as per requirement
    • Actively lead and develop SGH operations associates and ensure new technologies are leveraged
    • Initiate the contracting process and related documents within defined timelines; and
    • Collaborate with global stakeholders for project planning and setting up the timelines and maintaining budget
    • Performance indicators : Feedback from (end stakeholders) on overall satisfaction
    • Weightage : 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
    • Contribute to evolving our offerings and improving efficiency of repeated /routine processes through standardization/ automation of various offerings, models, and processes
    • Proactively conduct rationalization of reports to avoid data redundancies and free up capacity to work on new initiatives/projects
    • Synthesis of data and insights by collaborating/gathering inputs from colleagues in other functions such as Market Research, Brand Analytics, Marketing, Finance, Market Access, Medical, etc.
    • Provide quarterly utilization metrics of reports produced via usage metrics available in Power BI or other methods for reports outside of BI framework
    • Assist development and maintenance of KPI reports for the commercial team, covering Marketing and other related functions, and access appropriate information via a variety of tools and sources
    • Create dashboards to synthesize and visualize key information and enable business decisions
    • Develop a deep understanding of internal customers data and analytical needs focusing on the customer-facing model
    • Monitor the external environment to stay up to date on the latest therapeutic area research and clinical development, as well as competitor landscape, and summarize and present findings through various communication channels
    • Capability in applying deeper technical skills and knowledge that is shared across the functional area (e.g., deep knowledge of key data sets, modelling capabilities, etc.)
    • Set up and maintain analytics work environment to support activities across all analytics pillars (Advanced, Strategic, Reporting, Omnichannel) using a combination of PowerBI and Snowflake
    • Transition existing data extract - transform processes from the legacy SAS environment to Snowflake
    • Create and maintain standard integrated, analytics ready datasets (or unmaterialized views) to be used in build of ongoing reports and adhoc analysis. (for example. Weekly HCP level TRx, NRx, NBRx, by brand, by paytype, with segment label, and various other customer dimensions)
    • Analytics work environment will adhere to Global enterprise BI and Data standards and will use the technology and software that is aligned with Sanofi Global Digital roadmap.
    • Create and maintain library of standard summaries and visualizations to be used in building recurring reports AND as a template that can be customized as needed. (for example a line chart showing TRx market share over 24 months by brand, a pie chart showing percent of TRx by pay type based on 12 months of history, Summary of NBRx growth by segment, etc.)
    • Develop a deep understanding of internal customers data and analytical needs focusing on the customer-facing model
    • Monitor the external environment to stay up to date on the latest therapeutic area research and clinical development, as well as competitor landscape
    • Access appropriate information via a variety of tools and sources
    • Summarize and present findings through various communication channels
    • Capability in applying deeper technical skills and knowledge that is shared across the functional area (e.g., deep knowledge of key data sets, modeling capabilities, etc.)
    • Performance indicators : Adherence to timeline, quality target
    • Weightage : 50%
  • Process :
    • Support delivery of projects in terms of resourcing, coordination, quality, timeliness, efficiency, and high technical standards for deliveries made by the medical/ field writing group, including scientific documents and clinical/medical reports
    • Contribute to overall quality enhancement by ensuring high scientific standards for the output produced by the medical/ field writing group; and
    • 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
    • Use latest tools / technologies / methodologies and partner with internal teams to provide support on all sort of regular and adhoc business analytics activities like build, maintenance, and enhancements of such systems
    • Ability to work cross-functionally, gather requirements, analyse data, and generate insights and reports that can be used by the GBU
    • Work collaboratively with the stakeholder teams to prioritize work and deliver on time-sensitive requests
    • Be able to provide and defend gathered intelligence, methodology, content, and conclusions to the global leadership in a clear, concise format
    • Performance indicators : Feedback from stakeholders on satisfaction with deliverables Adherence to plan/calendar
    • Weightage : 25%
  • Stakeholder : Work closely with global teams and/ external vendors to ensure the end-to-end effective project delivery of the designated publication/medical education deliverables
About you
  • Experience :
    • 2+ years of experience in a data expert/SME, data engineer role within Pharma Domain.
    • In-depth knowledge of common databases like IQVIA, APLD, Engagement and execution data.
    • Demonstrated leadership and management in driving innovation and automation leveraging advanced statistical and analytical techniques.
    • People management experience by recruiting, selecting, orienting, and training associates; conflicts or complaints resolving ability from stakeholders and associates.
    • Supervising project activities and ensuring it is properly provisioned and staffed.
  • 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 :
    • Proficient of programming languages (e.g. SQL, SAS, Python, R, VBA)
    • Experience using analytical platforms (e.g. Databricks, Jupyter Notebook, SQL developers, SPSS, SAS, CART/machine learning, Access etc)
    • Proficient with pharmaceutical and commercial data sources and/or CRM data systems (e.g. IQVIA, Symphony, Komodo, Veeva, 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 and ensuring high quality data output with strong quality assurance
    • 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 : Advanced degree in areas such as 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
  • Additional Requirement: Required to align to US EST work schedule to engage global insights and brand teams. This role is a sole contributor focused on development, delivery and communication of insights

Skills: Machine Learning, Alteryx, Power Bi, Supply Chain, Sas, Access, Tableau, Sql, smartsheet , Vba, Spss, Pharmaceutical Development, Manufacturing, Databricks, Excel, Qliksense, Python, cart

Experience: 2.00-4.00 Years

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert