Senior Consultant - Data Engineer

Job Title -Senior consultant - Data Engineer

Career Level - D2

Introduction to role:
AstraZeneca is a global, innovation-driven biopharmaceutical business that focuses on the discovery, development, and commercialization of prescription medicines for some of the world's most serious diseases. The Science & Enabling Units IT is AZ’s global IT capability function supporting key business areas operating out of sites across the US, UK, Sweden, India & Mexico. We are looking for a passionate Data Engineer who will leverage tools and technology best practices to improve delivery performance and data engineering capabilities in the D&A space.

Accountabilities:
- Provide data engineering (ETL, Data Products, Reports) support to R&D IT portfolio
- Deliver cost-effective solutions to support data engineering activities, for example ETL data workflows using Snowflake, Python/Lambda
- Test and quality assess new D&A solutions to ensure they are fit for release: code assurance, Unit and System Integration Testing, Data testing, release management control, and support of UAT processes
- Ensure that business data and information assets are made available as data services and artefacts for consumption by the wider AZ enterprise

Essential Skills/Experience:
- Experience of working with a range of data analytics architectures. These may include traditional warehousing, distributed computing, visualization analytics
- Good experience of ETL & cloud techniques, and tools (we currently use AWS-based Python, Terraform, Glue, Lambda, S3, SQS, APIs, Step Functions)
- Experience in ETL best practices for error handling, optimization, job layout, job design and naming conventions
- First class SQL writing skills
- Familiar with using version control (branching, merging etc), ideally Git. Knowledge of working with project branches, merging them, publishing, and deploying code to runtime environments
- Experience and familiarity with data models and artefacts
- Any DB experience like Snowflake, PostgreSQL, Athena / Glue
- Interpret data, process data, analyze results and provide ongoing support of productionized applications
- Strong analytical skills with the ability to resolve production issues
- Understanding of business area/process in scope
- Willing to work in a cross-cultural environment across multiple time zones. Ability to work effectively independently or as part of a team to achieve objectives.
- Eager to learn and develop new tech skills as required
- Good written and verbal skills, fluent English

Desirable Skills/Experience:
- Domain knowledge (processes & data): Pharma R&D
- Any regulatory experience such as GxP
- Amazon Web Services: Connecting, loading, and reading data from AWS database technologies like Athena, Glue, Aurora, AWS Redshift, PostgresSQL, S3
- MS Power BI knowledge or any other reporting tools
- Agile/Scrum process
- ITIL knowledge
- Experience in Python/lambda/Snowflake

When we put unexpected teams in the same room, we unleash 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 unique and ambitious world.

At AstraZeneca, our work has a direct impact on patients by transforming our ability to develop life-changing medicines. We empower the business to perform at its peak by combining cutting-edge science with leading digital technology platforms and data. Here you can innovate and take ownership while being supported all the way. Diverse minds work cross-functionally and inclusively together to drive exponential growth.

Ready to make a difference? Apply now!

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 authorisation and employment eligibility verification requirements.