Data Analyst - 12 Month Secondment
Job Type: Full time
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
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
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
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.