Business Analyst Sql R Python Jobs in Long Island, NY

Job Description

Corporate Audit and Assurance Services (MCAAS) plays a key role in maintaining a strong financial control and compliance environment across the organization. MCAAS provides independent, objective assurance to evaluate and strengthen the effectiveness of risk management, controls, and governance processes. Through its audit and assurance work, MCAAS supports transparency, integrity, and accountability in financial operations.

The MCAAS Innovation team is a core part of this effort, using data and technology to support audits across the company. The team includes approximately 9 members based in the US and Europe. By combining analytical expertise with finance, compliance, and systems knowledge and using tools such as Power BI, UiPath, and Dataiku, we deliver real-time risk assessments and control insights. These insights strengthen audit procedures, help identify potential risks, and support recommendations for stronger controls.

In addition to supporting MCAAS directly, the data analytics team collaborates with other finance and analytics groups across the company and industry. This helps us share knowledge, build on existing solutions, and align with best practices. Through these partnerships, we promote continuous learning and ensure our analytics initiatives support broader organizational goals.

In this role, you will contribute to MCAAS's mission by applying strong analytical and leadership skills alongside emerging technologies. You will help advance strategic initiatives, improve risk assessment capabilities, and identify opportunities for process improvement. Your work will support the company's financial goals while upholding high standards of integrity and ethical conduct.

Responsibilities

• Support audit teams by fulfilling data requests from financial, accounting, and compliance systems across the company.

• Drive the strategic integration of AI tools to innovate and streamline the end-to-end audit process, from planning and risk assessment to execution and reporting.

• Develop analytics solutions and dashboards using datasets to provide real-time risk assessments and control insights through Power BI and other Microsoft tools.

• Contribute to team projects and deliver outputs using agile project management methods.

• Build automations that improve efficiency and save time using tools such as UiPath, Dataiku, and Python/R.

• Document technical solutions in line with SDLC requirements and guidance.

• Collaborate with and present to finance and analytics groups to share insights and leverage existing solutions.

• Explore and test new systems and technologies to expand team capabilities and generate new insights.

• Support the execution of financial, operational, SOX 404, IT, integrated, and process audits in domestic and international settings to help maintain a strong internal control environment.

Education Minimum Requirement:

• Bachelor's Degree in Finance, Business Analytics, Computer Science, or another field with a strong focus on data analytics preferred.

Required Experience and Skills:

• Minimum of 1 year of experience in Finance, Internal Audit, or Data Analytics

• Strong data analytics skills, including data transformation, modeling, analysis, and visualization

• Proficiency in Microsoft Excel

• Experience with Power BI or similar business intelligence tools

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

• Familiarity with automation tools such as UiPath and Power Automate

• Familiarity with ETL tools such as Dataiku, Matillion, and Databricks

• Familiarity with coding languages such as SQL, R, Python, or VBA

• Familiarity with agile project management methods and Jira

• Familiarity with AI and agentic AI systems

• Understanding of advanced or predictive analytics

• Understanding of data governance practices and SDLC compliance

• Demonstrated success in a collaborative, team-oriented environment

• Demonstrated ethics and integrity in a professional environment

• Strong interpersonal skills and a customer-focused mindset, with the ability to work effectively with clients and team members

• Strong interest in data, technology, and finance

• Effective written and verbal communication skills

• Travel up to 10%, domestic and international

Preferred Experience and Skills:

• Understanding of financial systems and financial controls

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

• Programming experience in Python, R, or similar languages

Required Skills:

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

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:

Relocation:

VISA Sponsorship:

Travel Requirements:

Flexible Work Arrangements:

Shift:

Valid Driving License:

Hazardous Material(s):

Job Posting End Date:

*A job posting is effective until 11:59:59PM on the day BEFOREthe listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.