Data Engineer

Introduction to role

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, you will be responsible for designing and supervising 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 outstanding attention to detail, sophisticated computational and programming skills, and the capacity to rapidly develop and act upon in-depth knowledge of our business, products, and processes. You must be self-directed and comfortable supporting the data needs of business users, data analysts, and data scientists.

Accountabilities

- Design, improve 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 sophisticated, large-scale data solutions that are scalable, robust, secure, and resilient.
- Collaborate with the Data Management team in implementing and leading data strategies that optimize 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 build aggregates/cubes/marts for data solutions, based on end-user requirements.
- Assess new data sources to better understand availability and quality of data.
- Build, design, and maintain reusable datasets for AI projects.
- Provide governance and best practices of data structures, data integrity, and querying.
- Handle and continuously improve support processes and deliverables related to information delivery - working in partnership with the Managed Services team.
- Responsible for identifying, capturing, and leading system defects and root cause assessments.
- Mentor and train personnel within and outside of the information delivery group for data requests.

Essential Skills/Experience

- 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 sophisticated software applications, algorithms, querying, and automated processes to cleanse, integrate and evaluate datasets and models.
- Experience using programming languages like Python and technologies such as dbt, Fivetran, Glue, S3, GitHub (CI/CD), Apache Airflow (MWAA), Snowflake (including features such as data sharing, events, lake-house patterns, and other Snowflake utilities), SonarQube.
- Solid understanding of analytic data architecture and data modeling 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 crafting solutions for handling, processing, and storing large files with various structures.
- Familiarity with data governance, data quality, testing 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 encouraging a collaborative team environment.

Desirable Skills/Experience

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

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 outstanding and ambitious world.

Joining Alexion means embracing an opportunity where work isn’t ordinary. We are a beacon in the global Biopharmaceutical landscape. Our closeness to patients brings us closer to our work and each other. Combined with our brave pioneering spirit – we are truly unique in R&D and healthcare. At Alexion, grow and innovate in a business with a rapidly expanding portfolio. Enjoy the atmosphere, entrepreneurial spirit, and autonomy of a leading biotech. You’ll join an energizing culture where people build connections to explore new insights. As a meaningful member of our team, you'll meet the needs of some of the most under-served patients in the world. You will be empowered with tailored development programs designed not just for skill enhancement but for fostering a deep understanding of our patient's journeys. You’re supported by outstanding leaders ready to lift you in marketing, compliance, and beyond.

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