Data Analysis Excel Jobs in Raleigh, NC (NOW HIRING)

About Us

Founded in 1908, Merz is a successful, family-owned specialty healthcare company with a rich history. As a leading global aesthetics business, our award-winning portfolio of injectables, devices, and skincare products empowers healthcare professionals to enhance confidence through aesthetic medicine. Our purpose is to fuel confidence by helping people look better, feel better, and live better. We believe you do not have to choose between living life and making a living. Live your best life with Merz Aesthetics.

A Brief Overview

This position will serve as the financial business partner and contributor to strategic initiatives with a focus on the US Aesthetics business unit. As an individual contributor, this role will provide expert financial analytics, guidance and strategic support for areas of the company which may include Sales, Marketing, and Administrative functions. This position will develop and nurture relationships with internal stakeholders and establish credibility. This includes the financial analysis of approved strategic initiatives directly supporting fellow Finance team members through completion. This role will support the monthly accrual process, analysis of business results, measure return on commercial investments, and proactively identifying issues and opportunities including process improvements and analytical reporting. This position will support numerous NALT members bridging operational finance activities to deliver analytic insights. Demonstrate a strong bias toward action, accountability and being embedded with the business regularly.

What You Will Do

• Forecasting/Planning
  • Coordination of the end-to-end planning/forecasting process, leveraging project management skillset to execute
  • Support Cash Flow and P&L planning process for all forecast cycles
  • Financial partner for strategic contract fee processing and the commercial samples management processes
  • Support the US Insurance program annual renewal process as liaison to 3rd partner insurance brokerage firm
• Controlling
  • Process all strategic contract fee payment and reconciliation activity
  • Monthly general ledger closing activities and journal entry submissions utilizing SAP
• Reporting
  • Responsible for multiple monthly reporting activities including variance reporting and commercial investment analytics
  • Tableau visualization tool is leveraged for daily/weekly reporting activities
• Data Analysis / Excel Modeling
  • Ad-hoc data analysis for various business functions and advanced financial modeling utilizing Microsoft Excel
  • Manage and analyze large data sets focused on promotional marketing activities and customer loyalty programs
• Collaboration
  • This position reports to the Executive Director FP&A, but will directly support key activities across the broader team and will take direction from other Finance leaders
  • This position will support various client groups including members of the leadership team. This position also interacts with varying levels of employees from multiple departments on special project execution.

Minimum Requirements

• Bachelor of Business Administration (B.B.A.)
• 6+ years in finance role; B.S. in Business, Finance, or Accounting
• Previous experience with the SAP ERP financial system

Preferred Qualifications

• Certified Public Accountant (CPA)
• Previous experience as Senior Financial Analyst or Finance Manager within financial planning department
• Previous experience in Aesthetics / Healthcare industry

Technical & Functional Skills

• Strong Microsoft Excel, Word, PowerPoint, Outlook skills and comfort with a large variety of digital communication tools and AV equipment
• Strong interpersonal and communication skills and attention to detail.
• Previous experience with the SAP ERP financial system.
• Data Modeling skills for various business investment scenarios and/or strategies.
• Data reconciliation skills leveraging pivot tables, sum-if, and lookup functions.
• Communicate effectively with finance contacts from key vendors and/or key customer accounts.
• Project management skills to collaborate cross-functionally for team-based task execution.
• Understanding of basic accounting principles and general ledger structures.
• Understanding the Statement of Cash Flows financial statement structure and data process.