Sr. Data Engineer – Master Data Management

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.

ABOUT THE ROLE

Role Description:

In this role, you will be part of a high performing team, which includes Master Data Management experts responsible for maintaining high-quality, consistent, accurate and controlled Master Data for the Enterprise.  This role involves working with large datasets, developing reports, supporting and executing data governance initiatives and, visualizing data to ensure data is accessible, reliable, and efficiently managed. The ideal candidate has strong technical skills, experience with MDM technologies, and a deep understanding of data architecture and ETL processes

Roles & Responsibilities:

• Recommend best practices to maintain master data across their lifecycle
• Develop and execute Enterprise Master Data Management strategy and roadmap, for Healthcare Customer Master,  Affiliations, Product, Plan Payer domains
• Provide expertise for match & merge, survivorship rules, business rules, standards, and other MDM related activities
• Work with data stewards to design match, merge, unmerge rules and exception resolution workflow
• Configure master data rules and analyze UI/workflow requirements
• Configure MDM business and data stewardship user interface
• Configure MDM workflow for exception resolution and task-based routing
• Configure MDM data model, audit trail and security
• Configure and create necessary staging and master data structures
• Define hierarchy structures, attributes and relationships across master data domains and elements
• Support testing and deployment
• Create data pipelines and ensure data quality by implementing ETL processes to migrate and deploy data across systems
• Provide technical leadership and guidance to development teams, ensuring alignment to best practices and standards.
• Work closely with Data Stewards and troubleshoots errors in Informatica MDM and IDQ.
• Participate in project planning, estimation, and risk assessment.
• Mentor junior team members and contribute to knowledge sharing.
• Create comprehensive technical documentation, including design specifications, architecture diagrams, and user guides.
• Follow Agile software development methods to design, build, implement, and deploy.
• Collaborate and communicate effectively with product teams

Basic Qualifications and Experience:

• Doctorate Degree OR
• Master’s degree with 4 - 6 years of experience in Computer Science, IT or related field  OR
• Bachelor’s degree with 6 - 8 years of experience in Computer Science, IT or related field  OR
• Diploma with 10 - 12 years of experience in Computer Science, IT or related field

Functional Skills:

Must-Have Skills:

• Proficiency in Informatica MDM or Reltio MDM platform
• Proficient in one of the coding languages (Python, Java, Scala)
• Has hands on experience writing SQL using any RDBMS (Redshift, Postgres, MySQL, MongoDB, Oracle, etc.).
• Hands on experience using Databricks/Jupyter or similar notebook environment and AWS Services like EC2, S3, Unity Catalog, Athena, RDS, Lambda, and API gateway
• Experience with Schema Design & Dimensional data modeling.
• Experience with software DevOps CI/CD tools, such Git, Jenkins, Linux, and Shell Script

Good-to-Have Skills:

• Knowledge of data protection regulations and compliance requirements (e.g., GDPR, CCPA)
• Experience with bio-pharma master data and transactional information (commercial, medical, clinical, etc.)
• Experience with pharma/healthcare business processes (commercial, medical, clinical, etc.)
• Experience with software DevOps CI/CD tools, such Git, Jenkins, Linux, and Shell Script
• Experience with Spark, Hive, Kafka, Kinesis, Spark Streaming, and Airflow.
• Strong understanding of data modeling, data warehousing, and data integration concepts
• Experience working with test-driven development and software test automation
• Manage team of diverse skill sets (programmer, cloud analyst, BI developer, reporting, operations, etc.)
• Up to speed with latest technologies related (but not limited to) to cloud platform services, visualization, data management
• Ability to distill complex concepts into easy-to-understand frameworks and presentations

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

Shift Information:

This position requires you to work a later shift and may be assigned a second shift schedule. Candidates must be willing and able to work during evening shifts, as required based on business requirements.

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.