Senior Consultant - Cyber Security Reporting Analyst

Career Level - D2

AstraZeneca is a global, science-led biopharmaceutical company that focuses on the discovery, development, and commercialization of prescription medicines. We are dedicated to advancing science to improve health and deliver results for patients and shareholders. Join us to help make a difference in patients' lives every day.

We are seeking a highly skilled and motivated Cyber Security Data Analyst to join our dynamic Cyber Security Risk & Reporting team. The successful candidate will have extensive experience in Power BI reporting, ETL (Extract, Transform, Load) processes, and AWS S3, and will be responsible for crafting, developing and maintaining our Cyber Security Reporting suite, enabling data driven decision making by our senior leaders. This role requires close collaboration with colleagues both within Cyber Security and IT functions across AstraZeneca’s Enterprise Services and Business Technology Groups (BTGs).

Data Analysis:

• Perform data analysis to identify trends, patterns, and anomalies.
• Work with large datasets to extract meaningful information and provide recommendations.
• Collaborate with business units to understand their data needs and deliver solutions accordingly.

• Design, develop, and maintain ETL workflows to extract data from various sources, transform it according to business requirements, and load it into target systems.
• Ensure data integrity and quality throughout the ETL process.
• Fix, communicate and support resolution of any ETL-related issues.

• Utilize AWS S3 for data storage and management.
• Ensure effective data transfer and integration between AWS S3 and other data systems.
• Manage and maintain data security and access controls in AWS S3.

• Develop, design, and maintain interactive Power BI dashboards and reports.
• Create data visualizations that deliver actionable insights to collaborators.
• Optimize Power BI models for performance and usability.

• Work closely with data and process owners, and business collaborators to evaluate reporting needs.
• Communicate findings and insights optimally through presentations and reports.

Essential

• A Bachelor’s degree in Data Science, Computer Science, Information Technology, or a related field.
• 2 years+ experience as a Data Analyst or in a similar role within in an IT capacity.
• High proficiency in Power BI, including DAX, Power Query, and the creation of complex data visualizations.
• Strong ETL (Extract, Transform, and Load) skills, with experience in tools such as SQL Server Integration Services (SSIS), Informatica, Talend, or similar.
• Experience using Power Automate to streamline repetitive processes.
• Experience with AWS S3 for data storage and integration.
• Solid understanding of databases and SQL.
• Ability to communicate at multiple levels within an organization and to confidently talk to and represent data sets.
• Deliver training and support to users on Power BI and data analysis techniques.

• Excellent analytical and problem-solving skills.
• Strong written and verbal communication skills along with the proven ability to communicate complex, technical information to both technical and non-technical audiences.
• Experience of autonomous working with direction and goal setting and ability to prioritize, re-schedule and adapt to changes in a dynamic environment.
• Be valued and respected for collaboration, integrity and enablement.

• Experience working in a global organization where collaborators and team members are geographically dispersed.

Date Posted

Closing Date

AstraZeneca embraces diversity and equality of opportunity.  We are committed to building an inclusive and diverse team representing all backgrounds, with as wide a range of perspectives as possible, and harnessing industry-leading skills.  We believe that the more inclusive we are, the better our work will be.  We welcome and consider applications to join our team from all qualified candidates, regardless of their characteristics.  We comply with all applicable laws and regulations on non-discrimination in employment (and recruitment), as well as work authorization and employment eligibility verification requirements.