Sr Associate Data Engineer

Career Category Information Systems Join Amgen s Mission of Serving Patients At Amgen if you feel like you re part of something bigger it s because you are Our shared mission to serve patients living with serious illnesses drives all that we do Since 1980 we ve helped pioneer the world of biotech in our fight against the world s toughest diseases With our focus on four therapeutic areas -Oncology Inflammation General Medicine and Rare Disease- we reach millions of patients each year As a member of the Amgen team you ll help make a lasting impact on the lives of patients as we research manufacture and deliver innovative medicines to help people live longer fuller happier lives Our award-winning culture is collaborative innovative and science based If you have a passion for challenges and the opportunities that lay within them you ll thrive as part of the Amgen team Join us and transform the lives of patients while transforming your career What you will do Let s do this Let s change the world In this vital role play a key role in a regulatory submission content automation initiative which will modernize and digitize the regulatory submission process positioning Amgen as a leader in regulatory innovation The initiative demonstrates innovative technologies including Generative AI Structured Content Management and integrated data to automate the creation review and approval of regulatory content The role is responsible for sourcing and analyzing data and supporting design building and maintaining the data pipelines and data models including semantic models that enable structured reusable and ontology-compliant data representations to drive business actions and automation The ideal candidate has strong technical skills experience with big data technologies and a deep understanding of data architecture ETL processes and transform raw data into semantically enriched formats that support AI analytics and regulatory submissions Roles Responsibilities Design and build conceptual and logical data models including 3NF schemas and Entity Relationship Diagrams ERDs using tools like Lucidchart Transform structured and unstructured data into reusable semantic bricks aligned with enterprise vocabularies and taxonomies Collaborate with cross-functional teams to support semantic ingestion transformation and integration of models contribute to SPARQL and SQL script generation for ontology-to-relational mapping Identify extract and integrate required business data from Operations systems residing in modern cloud-based architectures Design develop test and maintain scalable data pipelines ensuring data quality via ETL ELT processes Schedule and manage workflows to ensure pipelines run on schedule and are monitored for failures Implement data integration solutions and manage end-to-end pipeline projects including scope timelines and risk Reverse-engineer schemas and explore source system tables to map local representations of target business concepts Navigate application UIs and backends to gain business domain knowledge and detect data inconsistencies Break down information models into fine-grained business-contextualized data components Work closely with multi-functional teams including product teams data architects and business SMEs to understand requirements and design solutions Participate in KT sessions and maintain confluence documentation for semantic processes and architecture Support end-to-end regulatory workflows by ensuring semantic consistency and traceability across data domains Create and maintain data models dictionaries and documentation to ensure accuracy and consistency Adhere to SOPs GDEs and standard methodologies for coding testing and reusable component design What we expect of you We are all different yet we all use our unique contributions to serve patients Basic Qualifications Master s degree and 3 to 7 years of Computer Science IT or related field experience OR Bachelor s degree and 5 to 9 years of Computer Science IT or related field experience OR Diploma and 7 to 11 years of Computer Science IT or related field experience Preferred Qualifications Functional Skills Must-Have Skills Hands-on experience with data practices technologies and platforms such as Databricks Python Gitlab LucidChart etc Proficiency in data analysis tools eg SQL and experience with data sourcing tools Understanding of data governance frameworks tools and standard methodologies Knowledge of and experience with data standards FAIR and protection regulations and compliance requirements e g GDPR CCPA Data Modelling experience with proficiency in conceptual logical data modelling Understanding of ontology design and semantic modelling Ability to work in agile environments and collaborate across matrixed teams Knowledge of data lifecycle management data governance and metadata standards Strong understanding of data modeling data warehousing and data integration concepts Knowledge of Python R Databricks cloud data platforms Good-to-Have Skills Proficiency in SPARQL SQL Lucidchart and TopBraid Composer Experience with semantic layer platforms e g MarkLogic RDF stores Understanding of GxP compliance and pharmaceutical data standards Familiarity with regulatory data domains e g CMC Batch Lot Composition Experience with ETL tools and various Python packages related to data processing machine learning model development Professional Certifications Preferable to have Semantic Web Developer Certification W3C Certified Knowledge Engineer CKE Certified Data Engineer Data Analyst preferred on Databricks Soft Skills Excellent critical-thinking and problem-solving skills Strong communication and collaboration skills Demonstrated awareness of how to function in a team setting Demonstrated presentation 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 to participate 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 an accommodation As an organization dedicated to improving the quality of life for people around the world Amgen fosters an inclusive environment of diverse ethical committed and highly accomplished people who respect each other and live the Amgen values to continue advancing science to serve patients Together we compete in the fight against serious disease Amgen is an Equal Opportunity employer and will consider all qualified applicants for employment without regard to race color religion sex sexual orientation gender identity national origin protected veteran status disability status or any other basis protected by applicable law