This is what you will do:

The Data Engineer role is a key member of the Data Team, reporting to the Director of Data Engineering Services, and has close interaction with Functional Leads, Data Architects, Data Analysts and Data Scientists.  

In this role, the individual will be responsible for designing and overseeing the creation of automated data pipelines, implementing best practices for data analytics, supervising data model solutions, and offering strategic insights based on data queries. This will require an individual with exceptional attention to detail, advanced computational and programming skills, and the capacity to rapidly develop and act upon in-depth knowledge of our business, products, and processes.

They must be self-directed and comfortable supporting the data needs of business users, data analysts and data scientists.

You will be responsible for:

• Design, enhance and optimize ELT processes.
• Work with Data Analysts and different stakeholders to determine the data requirements of the various Alexion functions and implement design concepts to support the implementation of data product self-service solutions. Document the requirements and solution outcome.
• Proven ability to design, articulate, and deliver complex, large-scale data solutions that are scalable, robust, secure, and resilient.
• Collaborate with Data Management team in implementing and managing data strategies that optimizes metadata, lineage, and quality standards in building FAIR data products.
• Support development and availability of information assets in the form of data services and products for internal and external consumption to ensure consistency and strategic alignment of all BI and analytics needs.
• Ability to understand and develop ELT processes with our set of tools, Python, and SQL queries to create aggregates/cubes/marts for data solutions, based on end user requirements.
• Assess new data sources to better understand availability and quality of data.
• Create, design, and maintain reusable datasets for AI projects.
• Provide governance and best practices of data structures, data integrity, and querying.
• Manage and continuously improve support processes and deliverables related to information delivery - working in partnership with the Managed Services team.
• Responsible for identifying, capturing, and managing system defects and root cause assessments.
• Mentor and train personnel within and outside of the information delivery group for data requests.

You will need to have:

• A Bachelor's Degree or Master’s degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline is preferred.
• 5 years or more of experience in data engineering, business analysis and data management.
• Experience designing and developing methods, processes, and systems to consolidate and analyze structured and unstructured data, from diverse sources including “big data” sources.
• Experience developing and using advanced software applications, algorithms, querying and automated processes to cleanse, integrate and evaluate datasets and models.
• Experience using programming language like Python and technologies such as dbt, Fivetran, Glue, S3, GitHub (CI/CD), Apache Airflow (MWAA), Snowflake (including features such as data sharing, events and lake-house patterns, and other Snowflake utilities), SonarQube.
• Solid understanding of analytic data architecture and data modelling concepts and principles, including data lakes, warehouses and marts.
• Previous experience working with upstream source systems, e.g.: Veeva CRM, Salesforce, Google Analytics, SAP, third party data providers.
• Expertise in designing solutions for handling, processing, and storing large files with various structures.
• Familiarity with data governance, data quality, and testing and tools like Collibra, Soda, Experian.
• Project management skills and the ability to communicate effectively with both technical and non-technical stakeholders.
• Team leadership skills like providing constructive feedbacks and fostering a collaborative team environment.

We would prefer for you to have:

• Pharmaceutical or Life Sciences industry experience 
• AWS Architecture Framework knowledge and certification
• SnowPro Core certification

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.