Data Engineer - R&D Data Catalyst Team
Amgen
Data Engineer - R&D Data Catalyst Team
Job Description
Join Amgen’s Mission of Serving Patients
What you will do
- 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
- 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
Must-Have Skills
- Databricks
- Power BI
- SQL
- ETL
- Data warehousing
- Data modeling
- Data governance
- Data security
- Data compliance
- AWS
- Data lakes
- Data pipelines
- Integration technologies
- DAX
- Power Query
- Change-data-capture (CDC)
- Analytical and troubleshooting skills
- Communication skills
- Collaboration skills
- Problem solving
- Agile methodologies
What you can expect of us
- Competitive benefits
- Collaborative culture
- Support for professional and personal growth and well-being
- Competitive and comprehensive Total Rewards Plans aligned with local industry standards
Locations
- Hyderabad, India (Remote)
Salary
Salary not disclosed
Estimated Salary Rangehigh confidence
20,000 - 40,000 USD / yearly
Source: xAI estimated
* This is an estimated range based on market data and may vary based on experience and qualifications.
Skills Required
- Databricksintermediate
- Power BIintermediate
- SQLintermediate
- ETLintermediate
- Data warehousingintermediate
- Data modelingintermediate
- Data governanceintermediate
- Data securityintermediate
- Data complianceintermediate
- AWSintermediate
- Data lakesintermediate
- Data pipelinesintermediate
- Integration technologiesintermediate
- DAXintermediate
- Power Queryintermediate
- Change-data-capture (CDC)intermediate
- Analytical and troubleshooting skillsintermediate
- Communication skillsintermediate
- Collaboration skillsintermediate
- Problem solvingintermediate
- Agile methodologiesintermediate
Required 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 (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 (experience)
- 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 (experience)
- Hands-on experience with Databricks, including data engineering, optimization, and analytics workloads (experience)
- Deep understanding of Power BI, including model design, DAX, and Power Query (experience)
- Proven experience designing and implementing data mastering solutions and data governance frameworks (experience)
- Expertise in cloud platforms (AWS), data lakes, and data warehouses (experience)
- Strong knowledge of ETL processes, data pipelines, and integration technologies (experience)
- Good communication and collaboration skills to work with cross-functional teams and senior leadership (experience)
- Ability to assess business needs and design solutions that align with organizational goals (experience)
- Exceptional hands-on capabilities with data profiling, data transformation, data mastering (experience)
- Success in mentoring and training team members (experience)
Responsibilities
- 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
Benefits
- general: Competitive benefits
- general: Collaborative culture
- general: Support for professional and personal growth and well-being
- general: Competitive and comprehensive Total Rewards Plans aligned with local industry standards
Tags & Categories
Data Engineer - R&D Data Catalyst Team
Amgen
Data Engineer - R&D Data Catalyst Team
Job Description
Join Amgen’s Mission of Serving Patients
What you will do
- 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
- 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
Must-Have Skills
- Databricks
- Power BI
- SQL
- ETL
- Data warehousing
- Data modeling
- Data governance
- Data security
- Data compliance
- AWS
- Data lakes
- Data pipelines
- Integration technologies
- DAX
- Power Query
- Change-data-capture (CDC)
- Analytical and troubleshooting skills
- Communication skills
- Collaboration skills
- Problem solving
- Agile methodologies
What you can expect of us
- Competitive benefits
- Collaborative culture
- Support for professional and personal growth and well-being
- Competitive and comprehensive Total Rewards Plans aligned with local industry standards
Locations
- Hyderabad, India (Remote)
Salary
Salary not disclosed
Estimated Salary Rangehigh confidence
20,000 - 40,000 USD / yearly
Source: xAI estimated
* This is an estimated range based on market data and may vary based on experience and qualifications.
Skills Required
- Databricksintermediate
- Power BIintermediate
- SQLintermediate
- ETLintermediate
- Data warehousingintermediate
- Data modelingintermediate
- Data governanceintermediate
- Data securityintermediate
- Data complianceintermediate
- AWSintermediate
- Data lakesintermediate
- Data pipelinesintermediate
- Integration technologiesintermediate
- DAXintermediate
- Power Queryintermediate
- Change-data-capture (CDC)intermediate
- Analytical and troubleshooting skillsintermediate
- Communication skillsintermediate
- Collaboration skillsintermediate
- Problem solvingintermediate
- Agile methodologiesintermediate
Required 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 (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 (experience)
- 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 (experience)
- Hands-on experience with Databricks, including data engineering, optimization, and analytics workloads (experience)
- Deep understanding of Power BI, including model design, DAX, and Power Query (experience)
- Proven experience designing and implementing data mastering solutions and data governance frameworks (experience)
- Expertise in cloud platforms (AWS), data lakes, and data warehouses (experience)
- Strong knowledge of ETL processes, data pipelines, and integration technologies (experience)
- Good communication and collaboration skills to work with cross-functional teams and senior leadership (experience)
- Ability to assess business needs and design solutions that align with organizational goals (experience)
- Exceptional hands-on capabilities with data profiling, data transformation, data mastering (experience)
- Success in mentoring and training team members (experience)
Responsibilities
- 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
Benefits
- general: Competitive benefits
- general: Collaborative culture
- general: Support for professional and personal growth and well-being
- general: Competitive and comprehensive Total Rewards Plans aligned with local industry standards
Tags & Categories