Cyber Security Reporting Analyst

Job Title: Cyber Security Reporting Analyst

Career Level -D2

Introduction to role

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 designing, 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).

Accountabilities

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.

ETL Processes:

• 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.

Aws s3:

• Apply AWS S3 for data storage and management.

• Ensure effective data transfer and integration between AWS S3 and other data systems.

• Handle and maintain data security and access controls in AWS S3.

Power BI Reporting:

• Develop, design, and maintain interactive Power BI dashboards and reports.

• Create data visualizations that provide actionable insights to stakeholders.

• Optimize Power BI models for performance and usability.

Collaboration and Communication:

• Work closely with data and process owners, and business stakeholders to evaluate reporting needs.

• Communicate findings and insights effectively through presentations and reports.

• Deliver training and support to users on Power BI and data analysis techniques.

Essential Skills/Experience

• 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 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.

Skills and Capabilities

• Excellent analytical and problem-solving skills.

• Strong written and verbal communication skills along with the proven ability to present 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 teamwork, integrity, and enablement.

Desirable Skills/Experience

• Knowledge of cloud-based data warehousing solutions such as Azure Data Factory or AWS Glue.

• Familiarity with programming languages such as Python or R.

• Experience providing and delivering reports and metrics across multiple functions.

• Knowledge of presentation skills and styles.

• Experience in the pharmaceutical or healthcare industry.

• Experience of working in other IT disciplines and across a range of industries and sectors.

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

When we put unexpected teams in the same room, we fuel bold thinking with the power to inspire life-changing medicines. In-person working gives us the platform we need to connect, work at pace, and challenge perceptions. That's why we work, on average, a minimum of three days per week from the office. But that doesn't mean we're not flexible. We balance the expectation of being in the office while respecting individual flexibility. Join us in our outstanding and ambitious world.

At AstraZeneca, our work has a direct impact on patients by redefining our ability to develop life-changing medicines. We empower the business to perform at its peak by combining ground breaking science with leading digital technology platforms. Join us at a crucial stage of our journey in becoming a digital and data-led enterprise. Here you can innovate, take ownership, experiment with leading-edge technology, and tackle challenges that might never have been tackled before. Shape your own path with support all the way.

Ready to make a difference? Apply now!