Data Engineer

ABOUT AMGEN

Amgen harnesses the best of biology and technology to fight the world’s toughest diseases, and make people’s lives easier, fuller and longer. We discover, develop, manufacture and deliver innovative medicines to help millions of patients. Amgen helped establish the biotechnology industry more than 40 years ago and remains on the cutting-edge of innovation, using technology and human genetic data to push beyond what’s known today.

ABOUT THE ROLE

Role Description:

We seek a skilled Data Engineer tobuild andoptimizeour data infrastructure. As a key contributor, you will collaborate closely with cross-functional teams to design and implement robust data pipelines that efficiently extract, transform, and load data into our AWS-based data lake and data warehouse. Yourexpertisewill be instrumental in empowering data-driven decision making through advanced analytics and predictive modeling.

Roles & Responsibilities:

• Building and optimizing data pipelines, data warehouses, and data lakes on the AWS and Databricks platforms.

• Managing and maintaining the AWS and Databricks environments.

• Ensuring data integrity, accuracy, and consistency through rigorous quality checks and monitoring.

• Maintain system uptime and optimal performance

• Working closely with cross-functional teams to understand business requirements and translate them into technical solutions.

• Exploringand implementing new tools and technologies to enhance ETL platform performance.

Functional Skills:

Must-Have Skills:

• Proficientin SQL for extracting, transforming, and analyzing complex datasets from both relational and columnar data stores. Proven ability to optimize query performance onbig dataplatforms.

• Proficientin leveraging Python,PySpark, and Airflow to build scalable and efficient data ingestion, transformation, and loading processes.

• Ability to learn new technologies quickly. Strong problem-solving and analytical skills. Excellent communication and teamwork skills.

Good-to-Have Skills:

• ExperiencedwithSQL/NOSQL database, vector database for large language models

• Experiencedwith data modeling and performance tuning for both OLAP and OLTP databases 

• Experiencedwith Apache Spark, Apache Airflow

• Experiencedwith software engineering best-practices, including but not limited to version control (Git, Subversion, etc.), CI/CD (Jenkins, Maven etc.), automated unit testing, and Dev Ops

• Experiencedwith AWS, GCP or Azure cloud services

Education andProfessional Certifications

• Bachelor’s degree in computer science and engineering preferred, other Engineering field is considered

• AWS Certified Data Engineerpreferred

• DatabricksCertificate preferred

Soft Skills:

• Excellent analytical and troubleshooting skills.

• Strong verbal and written communication skills

• Ability to work effectively with global, virtual teams

• High degree of initiative and self-motivation.

• Ability to manage multiple priorities successfully. 

• Team-oriented, with a focus on achieving team goals

• Strong presentation and public speaking skills.

EQUAL OPPORTUNITY STATEMENT

Amgen is an Equal Opportunity employer and will consider you without regard to your race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.

We will ensure that individuals with disabilities are provided with reasonable accommodation toparticipatein the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to requestaccommodation.