Sr. Data Engineer, R&D Data Catalyst Team

Role Description: 

The R&D Data Catalyst Teamis responsiblefor  buildingData 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 acceleratethespeedof discovery, and speed to market of advanced precision medications.    

The Sr. Data Engineer willbe responsible for the end-to-enddevelopmentof an enterprise analytics and data mastering solution leveraging Databricks and Power BI. This role requiresexpertise in both data architecture and analytics, with the ability to createscalable, reliable, and high-performingenterprisesolutions thatresearch cohort-building and advanced researchpipeline. The ideal candidate will have experience creating and surfacinglargeunifiedrepositories 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, andrelated IT 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 indata warehousing, ETL,Databricks, Power BI, and enterprise data mastering. 

Roles & Responsibilities:  

• Design and buildscalable 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 documentationfrom data analysis and profiling, and proposed designs and data logic  

• Develop advancedsql queries to profile, and unify data   

• Develop data processing code insql, along with semantic views to prepare data for reporting  

• DevelopPowerBI Models and reporting packages 

• Design robust data models, and processing layers,that support both analytical processing and operational reporting needs. 

• Design and develop solutions based onbest practices for data governance, security, and compliance within Databricks and Power BI environments. 

• Ensure the integration of data systems with other enterprise applications, creating seamless data flows across platforms. 

• Develop andmaintain Power BI solutions, ensuring data models and reports areoptimized for performance and scalability. 

• Collaborate with stakeholders to define data requirements,functionalspecifications, and project goals. 

• Continuously evaluate and adoptnew technologies and methodologies to enhance the architecture and performance of data solutions. 

Basic Qualifications and Experience: 

• Master’s degree with4 to 6 years of experience in Product Owner / Platform Owner / ServiceOwner  OR  

• Bachelor’s degree with8 to 10 years of experience in Product Owner / Platform Owner / Service Owner  

Functional Skills: 

Must-Have Skills: 

• Minimum of3 years of hands-on experience withBI solutions (Preferrable Power BI or Business Objects) including report development, dashboard creation, and optimization. 

• Minimum of6 years ofhands-onexperiencebuilding Change-data-capture (CDC) ETL pipelines, data warehouse design and build,and enterprise-level data management. 

• Hands-on experience with Databricks, including data engineering, optimization, and analytics workloads. 

• Deep understanding of Power BI, includingmodel design, DAX, and Power Query. 

• Proven experience designing and implementing data mastering solutions and data governance frameworks. 

• Expertise in cloud platforms (AWS), data lakes, and data warehouses. 

• Strong knowledge of ETL processes, data pipelines, and integration technologies. 

• Strong communication and collaboration skills to work with cross-functional teams and senior leadership. 

• Ability to assess business needs and design solutions that align with organizational goals. 

• Exceptional hands-oncapabilities with data profiling, data transformation, data mastering  

• Success in mentoring and training team members 

Good-to-Have Skills: 

• Experience in developing differentiated and deliverable solutions 

• Experiencewith human data, ideally human healthcare data 

• Familiarity with laboratory testing, patient data from clinical care, HL7, FHIR, and/or clinical trial data management 

Professional Certifications(please mention if the certification is preferred or mandatory for the role): 

• ITIL Foundation or other relevant certifications (preferred) 

• SAFe Agile Practitioner (6.0) 

• Microsoft Certified: Data Analyst Associate (Power BI) or related certification. 

• Databricks Certified Professional or similar certification. 

Soft Skills: 

• Excellent analytical and troubleshooting skills 

• Deep intellectual curiosity 

• Highest degree of initiative and self-motivation 

• Strong verbal and written communication skills, includingpresentationto varied audiencesof  complex technical/business topics 

• Confidencetechnical leader  

• Ability to work effectively with global, virtual teams, specifically including leveraging of tools and artifacts to assure clear and efficient collaboration acrosstime zones 

• Ability to manage multiple priorities successfully 

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

• Strong problem solving, analytical skills;  

• Ability to learn quickly andretain and synthesize complex information from diverse sources