Principal Data Engineer – Data & Analytics (Global Supply Chain)

Role Description:

This role acts as technical architect and hands-on leadfor Data Engineering practices across the Smart Supply Chain initiative within Amgen.Additionally, responsible for designing, building, maintaining, analyzing, and interpreting data to provide actionable insights that drive business decisions.

This role involves working with large datasets, developing reports, supporting and executing data governance initiativesand, visualizing data to ensure data is accessible, reliable, and efficiently managed. The ideal candidate has strong technical skills, experience with big data technologies, and a deep understanding of data architecture and ETL processes and will architect, build, and optimize enterprise-grade data pipelines using Databricks and AWS-native services.

Roles & Responsibilities:

1. Design, develop, and maintain data solutions for data generation, collection, and processing
2. Be a key team member that assistsin design and development of the data pipeline
3. Create data pipelines and ensure data quality by implementing ETL processes to migrate and deploy data across systems
4. Contribute to the design, development, and implementation of data pipelines, ETL/ELT processes, and data integration solutions
5. Take ownership of data pipeline projects from inception to deployment, manage scope, timelines, and risks
6. Collaborate with cross-functional teams to understand data requirements and design solutions that meet business needs
7. Develop and maintain data models, data dictionaries, and other documentation to ensure data accuracy and consistency
8. Implement data security and privacy measures to protect sensitive data
9. Leverage cloud platforms (AWS, Databricks preferred) to build scalable and efficient data solutions
10. Collaborate and communicate effectively with product teams
11. Collaborate with Data Architects, Business SMEs, and Data Scientists to design and develop end-to-end data pipelines to meet fast paced business needs across geographic regions
12. Identify and resolve complex data-related challenges
13. Adhere to best practices for coding, testing, and designing reusable code/component
14. Explore new tools and technologies that will help to improve ETL platform performance
15. Participate in sprint planning meetings and provide estimations on technical implementation
16. Continuously monitor data governance activities and report on compliance, data quality issues, and the effectiveness of governance initiatives

Basic Qualifications and Experience:

1. 12 - 17 years of experience in Computer Science, IT or related field

Functional Skills:

Must-Have Skills

1. Hands on experience with big data technologies and platforms, such as Databricks, Apache Spark (Databricks (PySpark, SparkSQL, Delta Lake) and AWSservices (S3, EMR, Lambda, Glue, UC, Athena, Redshift, EKS), workflow orchestration, performance tuning on big data processing and the ability to work with large, complex datasets
2. Hands-on experience in orchestrating large-scale data pipelines, performance tuning, lineage tracking, and observability frameworks.
3. Proficiency in data analysis tools (eg.SQL, Python) and experience with data visualization tools (Tableau, Power BI)
4. Excellent problem-solving skills Experience with DevOps practices, version control (Git), CI/CD (Jenkins), and Infrastructure as Code.

Good-to-Have Skills:

1. Experience with ETL tools such as Apache Spark, and various Python packages related to data processing, machine learning model development
2. Strong understanding of data modeling, data warehousing, and data integration concepts
3. Working knowledge of unstructured data processing, vector stores, and AI-enablement for downstream analytics.
4. Strong understanding of SAP data models(ECC tables) and Supply Chain data domains.
5. Experience working in Agile/SAFe environments with distributed global teams.

Professional Certifications:

1. Certified Data Engineer (preferred on Databricks or cloud environments)
2. Machine Learning Certification (preferred)

Soft Skills:

1. Excellent critical-thinking and problem-solving skills
2. Strong communication and collaboration skills
3. Demonstrated awareness of how to function in a team setting
4. Demonstrated presentation skills