Data Analyst - 12 month secondment

Horizon Place, Luton

Finance at AstraZeneca has a clear vision to become trusted partners, creating value and leading change. As such, Finance has a pivotal role to play in shaping our long-term financial health, partnering to deliver great results through insight, delivering excellence in financial operations and safeguarding AstraZeneca’s assets and reputation.

In Finance Architecture, Change & Transformation (FACT), we support this ambition by being trusted partners for change excellence and building long-term capabilities to make us future-fit. This is where you could come in. Working in Finance Transformation is fast-paced, dynamic and challenging. We are looking for people who want to seize the opportunity to take an exciting step in their personal development journey and play a fundamental part of delivering a world-class finance organisation.

The Data Analyst will support AstraZeneca’s Finance Architecture, Change & Transformation agenda as a member of the Data Services Team delivering quality assurance across Finance Transformation projects with an initial focus to support our journey to enhance Clinical Trial Cost Management insights.

The Data Analyst will be responsible to create relevant profiling, data quality KPI tracking, data mapping and data verification/reconciliation solutions enabling the analysis team to successfully perform the data enhancement role. The role owner will therefore closely collaborate with the various data colleagues assigned to the project while utilising best practice Data Service capabilities, solutions and processes.

To be successful candidates will need to have strong experience in developing tailored KPI tracking, profiling, mapping and reconciliation solutions. Technical skills in Alteryx, SQL, Access, Excel and Python will be beneficial. In addition good experience of data analysis, mapping and transformation is essential. Further, great attention to detail, work in a highly organised & structured manner paired with good collaboration skills and the ability to work against tight deadlines is important to the role.

Key accountabilities are to create relevant profiling, data quality KPI tracking, data mapping and data verification/reconciliation solutions enabling the analysis team to successfully perform the data enhancement role while also owning the execution of verifications and reconciliations of CTCM information. The role owner will therefore cover the following:

• Design, build and execute appropriate profiling and analysis solutions supporting the business analysis team

  • Establish profiling capability & profile source data in-line with to-be data demands

  • Liaise with Design / Business SME and technical teams on results and gain clarifications on questions & identify possible Cleanse gaps

• Design, build and execute Data Quality KPIs reporting

  • Agree Data Quality reporting KPI Metrics to validate the Data, its sources and correctness of Data usage

  • Build Relevant KPI Dashboards and ongoing quality tracking mechanism

  • Execute KPI reports on a regular basis and provide to relevant data colleagues for further action

• Design and build an automated mapping solution

  • Build mapping capability which creates automated mappings based on set rules

  • Establish a solution, which creates mapping collection reports per study lead, integrates workflows managing the information/report collections to migrate back into a master mapping file

  • Create key validation mechanisms to prove mapping completeness and quality

• Design, Build and execute data verifications and reconciliation proving successful data migration while enabling successful change management through the provision of relevant reconciliations reports supporting the change impact articulation/documentation

  • Understand existing Logical/Physical Model and Verification Requirements

  • Create Data Testing environment and build necessary workflows to source relevant data

  • Build robust verification solution and reports

  • Execute comprehensive testing of the solution and support SIT and UAT proving expected and actual results are within relevant parameters

• Liaise with business and project stakeholders to gain agreement at all stages, where relevant

• Support ongoing quality assurance capability build for mappings and transformation

• Identify BAU Transition opportunities - Data Operating Model

• Transition relevant verification capability into BAU

Essential

• Data Analysis experience of +3 years

• Extensive Data Profiling experience

• Extensive experience of creating complex data mappings and transformations

• Proven track record in establishing robust data verifications and reconciliations

• Strong data solution development skills especially in SQL, Access, Excel and Python

• Highly analytical with strong attention to detail & problem solving attitude

• Ability to present complex data context in a concise way to stakeholders on all levels of the organisation

• MS Access / Excel / Powerpoint- Intermediate

Desirable:

• Finance accounting degree

• Expert knowledge of Alteryx or Talend workflows

• Experience of working in a global organisation with complex/geographical context

• Experience of data cleansing and data migration

• Experience of data storytelling

• Excellent Stakeholder management and influencing skills

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.