Consultant - Data Engineer

Job Title: Consultant - Data Engineer

Career Level - C2

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, data ETL workflows using Snowflake, Python/Lambda, DBT.
• 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.
• Experience with & knowledge of DBT, Snowflake, Python and AWS.
• Experience in ETL standard processes 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 Aurora, Athena, Snowflake.
• 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 optimally independently or as part of a team to achieve objectives.
• Eager to learn and develop new tech skills as the need arises.
• 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, PostgreSQL, S3, Snowflake.
• MS Power BI knowledge or any other reporting tools.
• Agile/Scrum process.
• ITIL knowledge.
• Experience in Python/lambda/DBT.

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

AstraZeneca is at a crucial stage of its journey in becoming a digital and data-led enterprise. Here 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. Join us to innovate, take ownership and run with it in a multifaceted environment where you can shape your own path with support all the way.

Ready to make an impact? Apply now!