Consultant - Data Engineer

Job Title: Consultant - Data Engineer

Career Level: C3

Introduction to role:

Are you ready to disrupt an industry and change lives? At AstraZeneca, we are a global, innovation-driven biopharmaceutical company dedicated to the discovery, development, and commercialization of life-changing medicines. With operations in over 100 countries and headquartered in the United Kingdom, we pride ourselves on fostering a unique workplace culture that encourages innovation and collaboration. Join our Commercial IT Data Analytics & AI (DAAI) team as a Data Engineer and play a pivotal role in enhancing our data platforms built on AWS services. Located at Chennai GITC, you'll design and implement efficient data products, collaborate with experienced engineers, and support our data platform initiatives. Are you passionate about leveraging technology to impact patients and ultimately save lives?

Accountabilities:

As the Data Engineer, your key accountabilities will include:

Technical Expertise:

• Design, develop, and implement scalable processes to extract, transform, and load data from various sources into data warehouses.
• Demonstrate expert understanding of the application development processes of AstraZeneca’s implementation of the data product.
• Design, manage, and fine-tune SQL queries and procedures to achieve optimal performance and scalability.
• Work on JIRAs and provide support on production issues and enhancements whenever required.
• Quality Engineering Standards:
• Monitor and optimize data pipelines, troubleshoot, and resolve any issues that may arise during data processing.
• Maintain quality standards in design, code, and data models, ensuring thorough reviews at each stage of the development life cycle.
• Provide detailed analysis and documentation of processes and flows where necessary.
• Collaboration:
• Work closely with data engineers to understand data sources, transformations, and dependencies thoroughly.
• Collaborate with cross-functional teams, including Product Owners, Business Analysts, and CriticalOps teams to ensure seamless data integration and reliability.
• Innovation and Process Improvement:
• Drive the adoption of new technologies and tools to improve data engineering processes and efficiency.
• Recommend and implement enhancements to improve reliability, efficiency, and quality of data processing pipelines.
  
  
  

Essential Skills/Experience:

Education:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
  
  
  

Skills and Experience:

• Strong experience with SQL, warehousing, and building ETL pipelines (Snaplogic, Informatica).
• Proficient in working with column-level databases like Redshift, Cassandra, BigQuery.
• Solid understanding of data modeling, ETL processes, and data warehousing concepts.
• Deep SQL knowledge to write complex queries for data extraction, transformation, and reporting.
• Excellent communication with the ability to collaborate effectively with technical and non-technical stakeholders.
• Knowledge of database design principles, data modeling, and the ability to translate business requirements into database structures.
• Strong analytical skills with the ability to troubleshoot and deliver solutions in complex data environments.
• Experienced in Agile Development techniques and methodologies.
  
  
  

Desirable Skills/Experience:

• Experience with Databricks/Snowflake.
• Proficiency in scripting and programming languages such as Python.
• Experience with reporting tools like PowerBI.
• Prior significant experience working in Pharmaceutical or Healthcare industry IT environments.
  
  
  

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. With a passion for impacting lives through data, analytics, AI, machine learning, and more, we are at a crucial stage of our journey in becoming a digital and data-led enterprise. Here you can innovate, take ownership, experiment with leading-edge technology, and tackle challenges that might never have been addressed before. Join us in driving cross-company change to disrupt the entire industry!

Ready to make a difference? Apply now to join AstraZeneca's dynamic team!