Data Engineer - R&D Data Catalyst Team
India - Hyderabad
Amgen
Amgen is committed to unlocking the potential of biology for patients suffering from serious illnesses by discovering, developing, manufacturing and delivering innovative human therapeutics.Career Category
Information SystemsJob Description
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.
Data Engineer - R&D Data Catalyst Team
What you will do
Let’s do this. Let’s change the world. In this vital role, you will be responsible for the end-to-end development of an enterprise analytics and data mastering solution using Databricks and Power BI. This role requires expertise in both data architecture and analytics, with the ability to create scalable, reliable, and impactful 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 extraordinarily skilled with data analysis and profiling.
You will collaborate closely with key customers, product team members, and related 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 good background in data warehousing, ETL, Databricks, Power BI, and enterprise data mastering.
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
Develop PowerBI 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 on best 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 and maintain Power BI solutions, ensuring data models and reports are optimized for performance and scalability.
Collaborate with key customers to define data requirements, functional specifications, and project goals.
Continuously evaluate and adopt new technologies and methodologies to enhance the architecture and performance of data solutions.
What we expect of you
We are all different, yet we all use our unique contributions to serve patients. 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.
Basic Qualifications:
Master’s degree and 1 to 3 years of Data Engineering experience OR
Bachelor’s degree and 3 to 5 years of Data Engineering experience OR
Diploma and 7 to 9 years of Data Engineering experience
Minimum of 3 years of hands-on experience with BI solutions (Preferable Power BI or Business Objects) including report development, dashboard creation, and optimization.
Minimum of 3 years of hands-on experience building 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, including model 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.
Good 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-on capabilities with data profiling, data transformation, data mastering
Success in mentoring and training team members
Preferred Qualifications:
Experience in developing differentiated and deliverable solutions
Experience with 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:
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
The highest degree of initiative and self-motivation
Strong verbal and written communication skills, including presentation to varied audiences of complex technical/business topics
Confidence technical leader
Ability to work effectively with global, remote teams, specifically including using of tools and artifacts to assure clear and efficient collaboration across time zones
Ability to handle multiple priorities successfully
Team-oriented, with a focus on achieving team goals
Strong problem solving, analytical skills;
Ability to learn quickly and retain and synthesize complex information from diverse sources
What you can expect of us
As we work to develop treatments that take care of others, we also work to care for your professional and personal growth and well-being. From our competitive benefits to our collaborative culture, we’ll support your journey every step of the way.
In addition to the base salary, Amgen offers competitive and comprehensive Total Rewards Plans that are aligned with local industry standards.
Apply now and make a lasting impact with the Amgen team. careers.amgen.com
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.
We will ensure that individuals with disabilities are provided 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 accommodation.
.* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile Architecture AWS Data analysis Databricks Data governance Data management Data pipelines Data warehouse Data Warehousing Engineering ETL HL7 ITIL Model design Pipelines Power BI R R&D Research Security SQL Testing
Perks/benefits: Career development Competitive pay
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.