Job Description

About Astrazeneca AstraZeneca is a global, science-led, patient-focused biopharmaceutical company that focuses on the discovery, development and commercialization of prescription medicines for some of the world\'s most serious diseases. But we\'re more than one of the world\'s leading pharmaceutical companies. An entrepreneurial spirit that keeps us ahead of the rest-we apply creativity to every task we do, taking smart risks to turn our ideas into reality. Always at full speed, we thrive in our fast-paced and dynamic environment. / Capsule This position involves overseeing the maintenance, updates, and problem-solving of the organization\'s information systems, databases, and networks to ensure seamless operations and data accuracy. It demands a combination of technical skills. Proficiency in Excel and Power BI is essential for this role, as these tools are frequently utilized for data analysis, reporting, and visualization. Objective System Administration Critical actions & Measures Install, configure, and maintain hardware and software systems, databases, operating systems, and applications. Monitor system performance and security to ensure optimal functionality and protection against potential threats. Implement upgrades and patches to keep systems up-to-date and secure. System Performance and Reliability: System Uptime: Track system availability and downtime to ensure reliable access to information and minimize disruptions to business operations. Response Time: Measure the speed and responsiveness of the MIS system in processing user queries, generating reports, and performing data transactions. Analytical Skills Critical actions & Measures Ability to perform various data analysis tasks such as sorting, filtering, and summarizing data using Excel functions like VLOOKUP, HLOOKUP, SUMIFS, COUNTIFS, and AVERAGEIFS. PivotTables and PivotCharts: Proficiency in creating PivotTables and PivotCharts to analyze and summarize large datasets, identify trends, and generate insights. Data Modeling: Understanding of Excel\'s data modeling capabilities, including creating relationships between tables, defining calculated columns and measures, and building complex data models. Advanced Formulas: Knowledge of advanced Excel functions such as INDEX-MATCH, SUMPRODUCT, IFERROR, and array formulas to perform complex calculations and data manipulations. Macros and VBA: Basic understanding of recording and editing macros, as well as writing VBA (Visual Basic for Applications) code to automate repetitive tasks and enhance Excel\'s functionality. Data Quality: Measure the accuracy, completeness, consistency, and reliability of data managed by the MIS system. Error Rates: Monitor the frequency and severity of data errors or discrepancies and strive to minimize them through data validation and quality control processes. Compliance: Ensure adherence to data governance policies, regulatory requirements, and industry standards to maintain data integrity and confidentiality. Data Visualization-Power BI Skills Critical actions & Measures Data Visualization: Proficiency in designing interactive and visually appealing reports and dashboards using Power BI\'s visualization tools, including charts, graphs, maps, and slicers. Data Import and Transformation: Ability to import data from various sources into Power BI Desktop, clean and transform data using Power Query Editor, and create data models. DAX (Data Analysis Expressions): Understanding of DAX functions for creating calculated columns, measures, and calculated tables to perform advanced calculations and analysis within Power BI. Data Modeling: Knowledge of Power BI\'s data modeling, capabilities such as creating relationships between tables, defining hierarchies, and optimizing data models for performance. Power BI Service: Familiarity with Power BI Service for publishing, sharing, RLS and collaborating on reports and dashboards, as well as configuring data refresh schedules and managing access permissions. Clarity and Interpretability: Assess the clarity, simplicity, and intuitiveness of visualizations created by the Data Visualization specialist, ensuring that they effectively communicate complex data insights to stakeholders. Relevance to Audience: Evaluate the relevance and appropriateness of visualizations for different target audiences, such as executives, managers, analysts, and operational staff. Actionability: Determine the extent to which visualizations enable stakeholders to derive actionable insights and make informed decisions based on the presented data. Data Quality: Monitor the accuracy, completeness, and timeliness of data visualized in dashboards, ensuring that data sources are reliable, up-to-date, and free from errors or inconsistencies. Audit and Risk Management: Critical actions & Measures Audit Assessment and Analysis: Conduct regular audit assessments to identify potential risks and vulnerabilities within the organization. Analyze risk factors associated with various business processes, systems, and activities to prioritize audit monitoring efforts. Audit Trail and Documentation Management: Maintain a robust audit trail and documentation management system to track changes, approvals, and access to sensitive compliance-related information. Ensure that all documentation is organized, securely stored, and easily accessible for audit purposes. Collaboration and Communication: Foster collaboration and communication across departments and functions to promote a culture of compliance throughout the organization. Establish clear channels for reporting compliance concerns, seeking guidance, and sharing information to facilitate timely resolution of issues. Compliance & Audit Monitoring Frequency: Definition: Number of Audit monitoring activities or checks conducted within a defined period (e.g., monthly, quarterly). Calculation: Total number of Audit monitoring activities conducted Example: If audit monitoring activities were conducted 6 times in a year, the compliance monitoring frequency would be 6 times Essential Education, Qualifications, Skills and Experience Bachelor\'s degree Expert in Advanced Excel -Proficiency in using complex formulas (e.g., VLOOKUP, HLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, etc.), Ability to create and understand nested formulas, Expertise in data cleaning, transformation, and manipulation, Ability to sort, filter, and extract relevant information from large datasets, Pivot Tables and Pivot Reporting, Proficient in creating various types of charts and graphs for data visualization, Ability to approach complex data-related problems with a logical and analytical mindset, keen eye for detail, especially when working with large datasets. Data Visualization Tools: Proficiency in Power BI tool for creating meaningful visualizations to communicate insights effectively. Additional knowledge of tools like Tableau, Matplotlib, Seaborn, or ggplot would be useful. Communication Skills: Strong written and verbal communication skills for presenting findings, creating reports, and interacting with cross-functional teams. Desirable Young and result-oriented individual, having a portfolio of personal or professional data science projects in the Pharma industry. Statistical Modeling: Understanding of statistical concepts and proficiency in using statistical models for analysis and inference. Hypothesis Testing: Knowledge of hypothesis testing, and experimental design is important for drawing meaningful conclusions from data. Key Relationships to Reach Solutions Internal (to AZ or team) Insights managers Commercial Excellence Team Business Marketing Salesforce IT External (to AZ) Management Consultants (IQVIA, Veeva) Global Commercial Excellence Team Why AstraZeneca At AstraZeneca we\'re dedicated to being a Great Place to Work. Where you are empowered to push the boundaries of science and unleash your entrepreneurial spirit. There\'s no better place to make a difference to medicine, patients and society. An inclusive culture that champions diversity and collaboration, and always committed to lifelong learning, growth and development. We\'re on an exciting journey to pioneer the future of healthcare. You can find alternative messaging to use in the \'Global Talent Attraction Story messaging\' section of the Global Playbook on the Employer Brand Portal - try to use other examples in order to make it different for candidates! So, what\'s next Are you already imagining yourself joining our team Good, because we can\'t wait to hear from you. Are you ready to bring new ideas and fresh thinking to the table Brilliant! We have one seat available and we hope it\'s yours. If you\'re curious to know more then please reach out to (contact person) We welcome with your application, no later than (Month) (XX) Where can I find out more Our Social Media, Follow AstraZeneca on LinkedIn https://www.linkedin.com/company/1603/ Follow AstraZeneca on Facebook https://www.facebook.com/astrazenecacareers/ Follow AstraZeneca on Instagram https://www.instagram.com/astrazeneca_careers/hl=en If you have site, country or departmental social media then feel free to switch any of the above links.

foundit