AWS Data Analyst

Technical/Functional Skills • Min. 3 years Pharma Manufacturing processes experience • Strong AWS services experience, including Data Migration Services, Lambda, Glue, Athena, RedShift, RedShift Spectrum, Arora, CloudWatch and other data movement services within AWS. • Experience in code migration using AWS Pipeline, CodeBuild, Cloud Formation • Strong experience in reporting and data analytic tools – Tableau, Power BI and/or SAP Business Objects. • Exposure to Agile Development process and practices Roles & Responsibilities  Ensure availability and quality of data needed for business processes and transactions.  Monitoring of Data Movement Interfaces, including AWS DMS, AWS Glue and other related AWS services.  Ensure system validation remains current, including configurations, design, SOP, and tests.  Provide system health check report for all system services, multiple times in a day.  Follow coding standards and system change control validation and verification processes.  Manage and co-ordinate on user and system generated tickets.  Identify, troubleshot, debug, and propose resolutions to technical issues.  Communications related to outages, LCM activities, follow-up with SME  Strong Technical leadership in one or more services in scope for this engagement  Troubleshoot problems with Dashboard and/or report queries.  Understands Service Data Model.  Supports the development and improvements for the data quality dashboard or system health check reports (AWS CloudWatch Health Dashboard)  Reports the holistic high-level system health metrics for Lilly Management (% accuracy across IDS, action completion reports  Provide training, consulting, and guidance to the Technical Analysts and the local configuration managers (LCM) across Information and Digital Solutions (IDS) for data accuracy and quality.  Support the development of the guidelines and execution of data clean-up or refresh.  Escalate to Client, when there is no response or actions from IDS partners, by the specified deadline.  Support the establishment of the timelines and deadlines for IDS partners to address the gaps and inconsistencies.  Answers the questions and service requests from IDS.  Proactively Identifies opportunities to build automation and automated checks into the system to ensure data compliance.  Provide a Weekly Status Report for the services provided by the Lead Analyst (Onshore) and the Technical Analysts (Offshore) for services.