Role Overview
As a professional specializing in SAP BW HANA Analytics, you will design and develop analytical applications leveraging data modeling, data architecture, ETL, and end-user reporting & analytics. You will utilize your skills in SAP BW on HANA, SAP NATIVE HANA Modelling, SAP SLT and Reporting tools to deliver solutions.
Your primary responsibilities will include: The role focuses on delivering scalable analytical solutions and partnering with stakeholders across Global Finance, Architecture & Delivery, Regional IT, and Local Finance to advance analytics-driven transformation.
Key Responsibilities
Design, develop BW Artifacts (ADSO, Open ODS View, CompositeProvider, Transformations, Process Chains, InfoObjects, DataSources (including ODP/ODQ), BEX Queries and reports, Dashboards and analytical Solutions to support Financial Analytics and Reporting.
Work on data extraction from SAP source systems (ECC/S/4HANA).
Hands on Experience on SAP HANA models(Graphical & SQL-based Calculation Views)
Contribute to end‑to‑end data modelling, performance enhancements, and solution maintenance across SAP BW and HANA.
Ensure data consistency, integrity, and performance optimization.
Prepare and maintain technical and functional documentation.
Support testing activities including unit testing, integration testing, and UAT.
Develop and enable reporting solutions in SAP Analysis for Office and Power BI ensuring seamless integration with SAP HANA models.
Engage with business and technical stakeholders to understand requirements and translate them into scalable technical solutions.
Collaborate with business stakeholders to understand reporting requirements and deliver solutions.
What You Should Have
Primary Skills: SAP BW,SQL, Native HANA
Secondary Skills: SAP Dataspheres/Sap BOBJ/SAP Analytics cloud
3–5 years of hands-on experience in SAP BW/BI/BO and SAP Native HANA Modeling(Graphical/SQL).
Strong expertise in SAP BW data modeling, including InfoObjects, DSOs, InfoCubes, InfoProviders, and BEx Queries/reporting.
In-depth knowledge of SAP HANA technologies, including Calculation Views, stored procedures, and table functions.
Hands-on experience with SAP SLT.
Experience with SAP data extraction mechanisms such as ODP, generic extractors, and Data Sources.
Functional understanding of FP&A, Manufacturing, Sales, and Capex processes.
Experience working in an Agile development environment and using tools such as Jira.
Proven ability to improve system performance through SQL tuning and indexing.
Nice to Have
Knowledge of Power BI Reporting is an added advantage
Familiarity with compliance, security, and best practices specific to highly regulated industries (e.g., healthcare, pharmaceutical).
Who we are
We are well known company Inc., Rahway, New Jersey, USA in the United States and Canada. For more than a century, bringing forward medicines and vaccines for many of the world's most challenging diseases. Today, our company continues to be at the forefront of research to deliver innovative health solutions and advance the prevention and treatment of diseases that threaten people and animals around the world.
What we look for
Imagine getting up in the morning for a job as important as helping to save and improve lives around the world. Here, you have that opportunity. You can put your empathy, creativity, digital mastery, or scientific genius to work in collaboration with a diverse group of colleagues who pursue and bring hope to countless people who are battling some of the most challenging diseases of our time. Our team is constantly evolving, so if you are among the intellectually curious, join us—and start making your impact today.
Additional location(s) Compensation Information
Required Skills
Business Needs, Business Needs, Business Requirements Analysis, Computer Engineering, Computer Science, Custom Application Development, Data Engineering, Data Extraction, Data Integrity, Data Modeling, Data Visualization, Design Applications, Enterprise Reporting, Integration Testing, Knowledge Sharing, Performance Tuning, SAP BW on HANA, SAP HANA, SAP HANA Cloud, Software Configurations, Software Development, Software Development Life Cycle (SDLC), Solution Architecture, SQL Databases, System Designs {+ 7 more}
Preferred Skills
Current Employees apply HERE
Current Contingent Workers apply HERE
Secondary Language(s) Job Description
#MSDHYDIT
Search Firm Representatives Please Read Carefully
Merck & Co., Inc., Rahway, NJ, USA, also known as Merck Sharp & Dohme LLC, Rahway, NJ, USA, does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company without a valid written search agreement in place for this position will be deemed the sole property of our company. No fee will be paid in the event a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place, introductions are position specific. Please, no phone calls or emails.
Employee Status
Regular
Relocation
Domestic
VISA Sponsorship
No
Travel Requirements
No Travel Required
Flexible Work Arrangements
Hybrid
Shift
Not Indicated
Valid Driving License
No
Hazardous Material(s)
n/a
Job Posting End Date
- 11/20/2026
- A job posting is effective until 11:59:59PM on the day BEFORE the listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.
