Sr. Specialist, Data Analysis (Hybrid - Rahway, NJ)

Job Description

Our Finance team brings financial perspectives into overall strategic and tactical decision making. We use state-of-the-art techniques for financial analysis, planning, accounting, reporting, and performance evaluation. This allows the organization to continue advancing medical innovation and improve lives. 

Position Overview: 

Our Company's Corporate Audit and Assurance Services (MCAAS) plays a pivotal role in ensuring a strong financial control and compliance environment within our organization. MCAAS is responsible for providing independent and objective assurance services to evaluate and enhance the effectiveness of our Company's risk management, control, and governance processes. Through its comprehensive audit and assurance activities, MCAAS helps the company maintain transparency, integrity, and accountability in its financial operations. 

The MCAAS Innovation team, a vital component of MCAAS, is at the forefront of leveraging data and technology to support audits across the company. Our team consists of approximately 10 members strategically situated across the US, Europe, and APAC regions. We utilize our strong analytical skills, finance, compliance, and system knowledge, and tools like Power BI, UiPath, and Dataiku to generate real-time risk assessments and control insights. These insights enhance the effectiveness of our audit procedures, enabling us to identify potential risks and recommend robust control measures. By leveraging cutting-edge technologies and our expertise in data analysis, we contribute to the overall success of MCAAS in maintaining a strong financial control and compliance environment. 

In addition to our direct support to MCAAS, our data analytics team actively collaborates with other finance and data analytics groups across our Company and the industry. This collaboration allows us to share knowledge, leverage existing solutions, and align with industry best practices. By working closely with these teams, we foster a culture of continuous learning and improvement, ensuring that our data analytics initiatives are aligned with the broader goals and objectives of the organization. 

As a member of the MCAAS Innovation team, you will play a crucial role in contributing to MCAAS's mission of upholding a robust financial control and compliance environment at our Company. By utilizing your strong analytical and leadership skills and leveraging emerging technologies, you will help drive strategic initiatives, enhance risk assessment capabilities, and identify opportunities for process improvement. Your contributions will directly impact the company's ability to achieve its financial goals while maintaining the highest standards of integrity and ethical conduct. 

Responsibilities:

• Support audit teams with data requests from different financial, accounting, and compliance systems within the company. 

• Lead and create analytical projects and dashboards with various datasets to drive real-time risk assessments and control insights utilizing Power BI and other Microsoft applications. 

• Lead and participate in team projects working with different team members and deliver outputs within agile project management methods. 

• Develop automations to drive time savings and process efficiencies with technologies like UiPath, Dataiku, and Python/R. 

• Document technical solutions as per SDLC and guidance. 

• Collaborate with and present to other finance and data analytics groups to share common learnings and leverage existing solutions. 

• Experiment and sandbox with new systems and technology to drive new learnings and greater support capabilities. 

• Participate in the execution of financial, operational, SOX 404 and IT audits, integrated audits, and process audits, both domestic and abroad to maintain a strong internal control environment at our Company. 

Position Qualifications: 

Required Education:

• BS in Finance, Business Analytics, or Computer Science preferred, but any academic curriculum focus on data analytics is accepted. 

​Required Experience and Skills: 

• Minimum of 2 years of work experience in Finance, Internal Audit or Data Analytics 

• Strong data analytical skills, including transformation, modeling, analysis, and visualization. 

• Strong experience with Microsoft Excel. 

• Strong experience with Power BI or related business intelligence software 

• Strong experience with SAP COMET, ATLAS, FSA, BPC, Veeva and other ERP systems 

• Proficiency in Automation tools including UiPath and Power Automate 

• Proficiency in ETL tools such as Dataiku, Matillion, Databricks 

• Proficiency in coding languages such as SQL, R, Python or VBA 

• Experience in Agile project management methods and Jira tool. 

• Knowledge of advanced / predictive data analytics. 

• Knowledge of general data governance practices and compliance with SDLC. 

• Proven success in a collaborative, team-oriented environment. 

• Demonstrate Enterprise Leadership Skills focused on Emotional Intelligence, Execution Excellence, Ownership and Accountability, Coaching and Development, and Motivation and Inspiration. 

• Excellent interpersonal skills, customer focused mindset, including the ability to interact effectively with client and team members. 

• Strong passion for data, technology, and finance 

• Effective written and verbal communications skills. 

• Demonstration of ethics and integrity within a professional work environment. 

• Travel: Up to 10% of the time, both domestic and international. 

Preferred Experience and Skills: 

• Strong understanding of our Company financial system structure and financial controls. 

• Experience with financial auditing, financial controls, and/or compliance. 

• Programming knowledge with Python, R, or related languages. 

#eligibleforerp

Required Skills:

Business Data Analytics, Business Intelligence (BI), Business Intelligence Software, Data Analytics, Data Governance, Data Management, Data Modeling, Data Visualization, Emerging Technologies, Finance Analytics, Measurement Analysis, Microsoft Excel, Microsoft Power Business Intelligence (BI), Risk Assessments, Risk Management, Stakeholder Relationship Management, Tactical Management, Waterfall Model

Preferred Skills:

Current Employees apply HERE

Current Contingent Workers apply HERE

US and Puerto Rico Residents Only:

Our company is committed to inclusion, ensuring that candidates can engage in a hiring process that exhibits their true capabilities. Please click here if you need an accommodation during the application or hiring process.

As an Equal Employment Opportunity Employer, we provide equal opportunities to all employees and applicants for employment and prohibit discrimination on the basis of race, color, age, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status, or other applicable legally protected characteristics.  As a federal contractor, we comply with all affirmative action requirements for protected veterans and individuals with disabilities.  For more information about personal rights under the U.S. Equal Opportunity Employment laws, visit:

EEOC Know Your Rights

EEOC GINA Supplement​

We are proud to be a company that embraces the value of bringing together, talented, and committed people with diverse experiences, perspectives, skills and backgrounds. The fastest way to breakthrough innovation is when people with diverse ideas, broad experiences, backgrounds, and skills come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another’s thinking and approach problems collectively.

Learn more about your rights, including under California, Colorado and other US State Acts

The salary range for this role is

$117,000.00 - $184,200.00

This is the lowest to highest salary we in good faith believe we would pay for this role at the time of this posting. An employee’s position within the salary range will be based on several factors including, but not limited to relevant education, qualifications, certifications, experience, skills, geographic location, government requirements, and business or organizational needs.

The successful candidate will be eligible for annual bonus and long-term incentive, if applicable.

We offer a comprehensive package of benefits.  Available benefits include medical, dental, vision healthcare and other insurance benefits (for employee and family), retirement benefits, including 401(k), paid holidays, vacation, and compassionate and sick days. More information about benefits is available at https://jobs.merck.com/us/en/compensation-and-benefits.

You can apply for this role through https://jobs.merck.com/us/en (or via the Workday Jobs Hub if you are a current employee). The application deadline for this position is stated on this posting.

San Francisco Residents Only: We will consider qualified applicants with arrest and conviction records for employment in compliance with the San Francisco Fair Chance Ordinance

Los Angeles Residents Only: We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance

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:

No relocation

VISA Sponsorship:

No

Travel Requirements:

10%

Flexible Work Arrangements:

Hybrid

Shift:

Not Indicated

Valid Driving License:

No

Hazardous Material(s):

N/A

Job Posting End Date:

08/17/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.