Data Engineer

<h2><b>Career Category</b></h2>Engineering<h2></h2><h2><b>Job Description</b></h2><div><div><p><b><span>Data Engineer</span></b><span> </span></p></div><div><p><b><span> </span></b><span> </span></p></div><div><p><b><span>Role Name: </span></b><span><span>Data Engineer</span><span> </span></span><span> </span></p></div><div><p><b><span>Department Name: </span></b><span><span>XXX</span></span><span> </span></p></div><div><p><b><span>Role GCF: </span></b><span><span>4</span></span><span> </span></p></div><div><p><b><span>Hiring Manager Name: Chunhai He</span></b><span> </span></p></div><div><p><span> </span></p></div><div><p><u><span>ABOUT AMGEN</span></u><span> </span></p></div><div><p><span><span>Amgen harnesses the best of biology and technology to fight the world’s toughest diseases, and make people’s lives easier, </span><span>fuller</span><span> and longer. We discover, develop, </span><span>manufacture</span><span> and deliver innovative medicines to help millions of patients. Amgen helped </span><span>establish</span><span> the biotechnology industry more than 40 years ago and </span><span>remains</span><span> on the </span><span>cutting-edge</span><span> of innovation, using technology and human genetic data to push beyond </span><span>what’s</span><span> known today.</span></span><span> </span></p></div><div><p><span><span> </span></span><span> </span></p></div><div><p><u><span>ABOUT THE ROLE</span></u><span> </span></p></div><div><p><u><span>Role Description:</span></u><span> </span></p></div><div><p><span><span>We seek a skilled Data Engineer to </span><span>build and</span><span> </span><span>optimize</span><span> 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 </span><span>expertise</span><span> will be instrumental in empowering data-driven decision making through advanced analytics and predictive modeling.</span></span><span> </span></p></div><div><p><u><span>Roles &amp; Responsibilities:</span></u><span><span> </span></span><span> </span></p></div><div><ul><li><p><span><span>Building and </span><span>optimizing</span><span> data pipelines, data warehouses, and data lakes on the AWS and Databricks platforms.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Managing and </span><span>maintaining</span><span> the AWS and Databricks environments.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Ensuring data integrity, accuracy, and consistency through rigorous quality checks and monitoring.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Maintain system uptime and </span><span>optimal</span><span> performance</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Working closely with cross-functional teams to understand business requirements and translate them into technical solutions.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Exploring</span><span> and implementing new tools and technologies to enhance ETL platform performance.</span></span><span> </span></p></li></ul></div></div><div><div><p><u><span>Functional Skills:</span></u><span> </span></p></div><div><p><b><span>Must-Have Skills:</span></b><span> </span></p></div><div><ul><li><p><span><span>Proficient </span><span>in SQL for extracting, transforming, and analyzing complex datasets from both relational and columnar data stores. Proven ability to </span><span>optimize</span><span> query performance on </span><span>big data </span><span>platforms.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>P</span><span>roficien</span><span>t</span><span> in </span><span>leveraging</span><span> Python, </span><span>PySpark</span><span>, and Airflow to build scalable and efficient data ingestion, transformation, and loading processes.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Ability to learn </span><span>new technologies</span><span> quickly. Strong problem-solving and analytical skills. Excellent communication and teamwork skills.</span></span><span> </span></p></li></ul></div><div><p><b><span>Good-to-Have Skills:</span></b><span> </span></p></div><div><ul><li><p><span><span>Experience</span><span>d</span><span> </span><span>with</span><span> SQL/NOSQL database, vector database for large language models</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>E</span><span>xperience</span><span>d</span><span> with data modeling and performance tuning for both OLAP and OLTP databases </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Experienc</span><span>ed</span><span> with Apache Spark, Apache Airflow</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Experience</span><span>d</span><span> 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</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Experience</span><span>d</span><span> with AWS, GCP or Azure cloud services</span></span><span> </span></p></li></ul></div><div><p><u><span>Education and </span><span>Professional Certifications</span></u><span> </span></p></div><div><ul><li><p><span><span>Bachelor’s degree in computer science and engineering preferred, other Engineering field is considered</span><span> </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>AWS Certified Data Engineer</span><span> preferred</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Databricks </span><span>Certifi</span><span>cate preferred</span></span><span> </span></p></li></ul></div><div><p><u><span>Soft Skills:</span></u><span> </span></p></div><div><ul><li><p><span><span>Excellent analytical and troubleshooting skills.</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Strong verbal and written communication skills</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Ability to work effectively with global, virtual teams</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>High degree of initiative and self-motivation.</span></span><span> </span></p></li></ul></div></div><div><div><ul><li><p><span><span>Ability to manage multiple priorities successfully. </span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Team-oriented, with a focus on achieving team goals</span></span><span> </span></p></li></ul></div><div><ul><li><p><span><span>Strong presentation and public speaking skills</span><span>.</span></span><span> </span></p></li></ul></div><div><p><span> </span></p></div><div><p><u><span>EQUAL OPPORTUNITY STATEMENT</span></u><span> </span></p></div><div><p><span><span>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.</span></span><span> </span></p></div><div><p><span><span>We will ensure that individuals with disabilities are provided with reasonable accommodation to </span><span>participate</span><span> in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request </span><span>accommodation</span><span>.</span></span><span> </span></p></div><div><p><span> </span></p></div></div><p style="text-align:inherit"></p><p style="text-align:inherit"></p><p style="text-align:inherit"></p>.