Senior Consultant - Data Engineering

Job Title: Senior Consultant - Data Engineer

Career Level: D2

Introduction to role

Are you ready to tackle the challenges of data engineering in a dynamic environment? As a Senior Consultant - Data Engineer, you'll be at the forefront of building and maintaining scalable, high-performance data solutions that drive data-driven decision-making. Your expertise will be crucial in data ingestion, transformation, and orchestration across cloud-based platforms. Collaborate with multi-functional teams to ensure seamless integration and reliability of data pipelines and services. Dive into cloud architecture and software engineering efforts to support the end-to-end delivery of data products. Are you up for the challenge?

Accountabilities:

• Build and optimize scalable data pipelines for ingestion, transformation, and analysis to ensure performance and reliability.
• Develop and maintain efficient ETL/ELT processes using clean, testable, and production-ready code.
• Design and manage data models that align with business requirements and support analytical use cases.
• Collaborate with multi-functional teams (software engineers, data scientists, product managers) to deliver integrated data solutions.
• Implement and manage cloud-based data infrastructure, demonstrating services like AWS for storage, processing, and orchestration.
• Create APIs and microservices to enable seamless data integration across platforms and systems.
• Optimize databases and queries for performance and maintain high-quality, reliable data workflows.
• Ensure data quality, validation, and compliance with security and privacy standards.
• Document data pipelines, models, and processes for maintainability and knowledge sharing.
• Stay up to date with modern data engineering tools and practices, contributing to ongoing improvements in architecture and delivery.

Essential Skills/Experience

• Minimum 6+ years of experience in delivering data and software engineering solutions.
• Hands-on experience with ETL/ELT tools like SnapLogic, FiveTran, or similar.
• Strong expertise in Snowflake, DBT, and modern data warehouse technologies.
• Skilled in data modelling, data transformation, and handling large-scale data systems.
• Good understanding of data pipeline design, including dimensional modelling and schema development.
• Familiar with Data Mesh and Data Product concepts, with experience in managing reusable data assets.
• Experience with data orchestration tools like Apache Airflow or MWAA.
• Proficient in Power BI or similar tools for building dashboards and data visualizations.
• Knowledge of DevOps/DataOps, including CI/CD pipelines and GitHub for version control.
• Familiar with Docker and Kubernetes for containerization and deployment.
• Experience with automated testing for data (unit, integration, regression testing).
• Strong programming skills in Python or similar languages.
• Experience with SQL and both relational (MySQL, PostgreSQL) and NoSQL databases.
• Exposure to full-stack development using JavaScript frameworks (Node.js, ReactJS, Python Fast API).
• Solid experience working with AWS services (S3, EC2, RDS, Lambda, EKS, ECS).
• Strong communication skills and ability to work closely with stake holders to translate requirements into solutions.
• Comfortable working in Agile environments, with the ability to adapt quickly to change.
• Excellent problem-solving and analytical thinking, with a proactive approach to identifying and resolving issues.

Desirable Skills/Experience

• Bachelor's or master's degree in a relevant field such as Health Sciences, Life Sciences, Data Management, Information Technology or equivalent experience.
• Experience working in the pharmaceuticals industry
• Certification in AWS Cloud or any data engineering or software engineering-related certification
• Awareness of use case specific GenAI tools available in the market and their application in day-to-day work scenarios.
• Possess working knowledge of basic prompting techniques and continuously improve these skills.
• Stay up to date with developments in AI and GenAI, applying new insights to work-related situations

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, your work directly impacts patients by transforming our ability to develop life-changing medicines. We empower our teams to perform at their peak by combining cutting-edge science with leading digital technology platforms. Join us at a crucial stage of our journey as we become a digital and data-led enterprise. With a passion for innovation and backed by significant investment, we drive cross-company change to disrupt the industry. Here, you can explore new technologies, experiment with leading-edge solutions, and tackle challenges that have never been addressed before. Our supportive environment encourages learning and growth while making a positive impact on lives worldwide.

Ready to make a difference? Apply now to join our team!

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.