Sr. Data Engineer, R&D Data Catalyst Team

Role Description:

The R&D Data Catalyst Team is responsible for building Data Searching, Cohort Building, and Knowledge Management tools that provide the Amgen scientific community with visibility to Amgen’s wealth of human datasets, projects and study histories, and knowledge over various scientific findings . These solutions are pivotal tools in Amgen’s goal to accelerate the speed of discovery, and speed to market of advanced precision medications .

The S r. Data Engineer will be responsible for the end-to-end development of an enterprise analytics and data mastering solution leveraging Databricks and Power BI. This role requires expertise in both data architecture and analytics, with the ability to create scalable, reliable, and high-performing enterprise solutions that research cohort-building and advanced research pipeline . The ideal candidate will have experience creating and surfacing large unified repositories of human data, based on integrations from multiple repositories and solutions , and be exceptionally skilled with data analysis and profiling .

You will collaborate closely with stakeholders , product team members , and related I T teams, to design and implement data models, integrate data from various sources, and ensure best practices for data governance and security. The ideal candidate will have a strong background in data warehousing, ETL, Databricks, Power BI, and enterprise data mastering.

Roles & Responsibilities:

Design and build scalable enterprise analytics solutions using Databricks, Power BI, and other modern data tools.

Leverage data virtualization, ETL, and semantic layers to balance need for unification, performance, and data transformation with goal to reduce data proliferation

Break down features into work that aligns with the architectural direction runway

Participate hands-on in pilots and proofs-of-concept for new patterns

Create robust documentation from data analysis and profiling, and proposed designs and data logic

Develop advanced sql queries to profile, and unify data

Develop data processing code in sql , along with semantic views to prepare data for reporting