Data Engineer

We seek a skilled Data Engineer to build and optimize our 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. Your expertise will be instrumental in empowering data-driven decision making through advanced analytics and predictive modeling.

About Amgen

• Career Category Engineering Job Description 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.

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.
• Exploring and implementing new tools and technologies to enhance ETL platform performance.

Requirements

• Must-Have Skills: Proficient in SQL for extracting, transforming, and analyzing complex datasets from both relational and columnar data stores.
• Proven ability to optimize query performance on big data platforms.
• Proficient in 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.
• Certifications 5 to 9 years of experience and Bachelor’s degree in computer science and engineering preferred, other Engineering field is considered AWS Certified Data Engineer preferred Databricks Certificate preferred
• 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 .

Preferred

• Experienced with SQL/NOSQL database, vector database for large language models
• Experienced with data modeling and performance tuning for both OLAP and OLTP databases
• Experienced with Apache Spark, Apache Airflow Experienced with 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 Experienced with AWS, GCP or Azure cloud services