DS CoE Finance Analyst

Posted:
8/5/2024, 5:00:00 PM

Location(s):
Reigate and Banstead, England, United Kingdom ⋅ England, United Kingdom

Experience Level(s):
Junior ⋅ Mid Level ⋅ Senior

Field(s):
Finance & Banking

Org Marketing Statement

Pfizer Inc: Working together for a healthier world. Founded in 1849, Pfizer is the world's premier biopharmaceutical company taking new approaches to better health. We discover, develop, manufacture and deliver quality, safe and effective prescription medicines to treat and help prevent disease for both people and animals. We also partner with healthcare providers, governments and local communities around the world to expand access to our medicines and to provide better quality health care and health system support. At Pfizer, colleagues in more than 90 countries work every day to help people stay happier and healthier longer and to reduce the human and economic burden of disease worldwide.

Role Description

The Decision Support Center of Excellence (DS CoE) Finance Analyst position is a Finance position responsible for undertaking data validation and financial management reporting and analysis in order to support our Finance customers. Key stakeholders will be Finance Managers / Senior Finance Managers. The DS CoE Finance Analyst is responsible for, but not limited to, conducting the following key activities:

  • Plan, Budget and Forecast modelling
  • Financial Reporting analytics
  • Presentation development and preparation
  • Data Validation
  • Report consolidation and submission

This role will require strong analytical ability, coupled with sufficient knowledge of business / finance analysis tools and methodologies. Analysts will be expected to respond to requests from Supervisors or Managers in an efficient and timely manner.

Resources Managed

  • No direct reports

Responsibilities

Plan, Budget and Forecast modelling:

  • Collect Data – Gather data from internal Pfizer systems and data external non-Pfizer systems and sources necessary for OP Plan and LE
  • Prepare Data - Format data for entry into model or analysis, load data into appropriate tool
  • Run Models – Input assumptions and data, run model
  • Validate Revenue and Expense Data
  • Analyze Output - Highlight significant variances to budget, actuals and prior year, pinpoint specific type of variance categorize variances as system/technical or business related, follow-up with suspected system/technical related variances, create variances report, categorizing variances by type, amount and specific location
  • Root Cause Research - Research business related variances, identify variance as manual accounting error or legitimate business movement, follow-up with GFS or market colleagues to resolve variance
  • Write Commentary – Prepare memo (email) to finance leadership, describe trends for the reporting period for each report, including an explanation of remaining variances
  • Support Finance as needed – Gathering assumptions, updating business

Financial Reporting analytics:

  • Collect Data - Gather data from external Non-Pfizer systems and sources necessary for reporting or analysis
  • Develop Standard Reports – Determine if reporting need is already met by Standard Reporting Package, Document Reporting Parameters, Construct Shared View of New Report in Reporting Tool, Review Output with Report Requestor, Adjust as Necessary, Save View in Reporting Tool and Add to List of Standard Reports
  • Validate Data - Compare the following data types across systems/data warehouses: revenue, COGS, OPEX, Overall PNL; highlight discrepancies in data, determine source of data discrepancies, classify reconciling items as mapping error (if applicable type) and if necessary, follow up with account team for applicable system to resolve
  • Run Reports - Confirm that data is available and validated, access reporting systems/tools, select appropriate parameters, run/refresh report (Essbase) or export to Excel and modify as necessary
  • Analyze, Research and Prepare Commentary on Output
  • Prepare reports: Compile and submit financial analysis reports
  • Support presentation preparation - Replace content with content from current Op Plan and LE

Presentation Development and Preparation:

  • Prepare Recurring Presentations - update recurring presentations with new data and commentary, review and finalize presentations
  • Prepare Ad Hoc Presentations – prepare ad hoc presentations as needed per request from manager

Data Validation:

  • Maintain KPI's to reflect current data
  • Additional data validation tasks as outlined elsewhere

Report Consolidation and Submission:

  • Consolidate Results - Receive Offline reports and commentary or export data from reporting tool, consolidate data into central report
  • Submit Results - In email or by posting to shared drive, submit results of report with commentary
  • Review Output with Customers - Review report and commentary with business partners

Qualifications

  • Bachelor's degree from an accredited college or university, with finance/accounting or related experience
  • Excellent analytical skills, attention to detail, and time management skills
  • Excellent written and verbal communication skills
  • Basic understanding of finance IT system architecture may be required.
  • Management Reporting and Analysis process experience preferred
  • Advanced Microsoft Office capabilities, particularly Excel, PowerPoint and Word
  • Competency with spreadsheets & financial modelling (comfort with data manipulation and financial systems)
  • Ability to identify business issues/opportunities and to frame business questions
  • Knowledge of various financial systems and financial reporting aspects is preferred
  • Basic knowledge of Generally Accepted Accounting Principles (GAAP) and International Financial Reporting Standards (IFRS)

Equal Employment Opportunity

Pfizer's aim is to provide equality of opportunity in the recruitment process by avoiding discrimination on the grounds of: age, disability, gender reassignment, race, religion or belief, sex, sexual orientation, marriage & civil partnership, pregnancy & maternity, political persuasion or trade union membership. At Pfizer we are creating an organisation and promoting a culture that respects each individual's unique character and life experiences, and reflects the diversity of our customers and markets. We will achieve this through fostering and sustaining an environment in which every colleague feels valued and supported, thus enabling superior business results.

Foreign nationals whose eligibility to work requires sponsorship or maintenance of valid immigration status may not be eligible for this position.

Relocation Package Not Available

Closing Statement

This position holds a UK Grade 07

We will only accept applications from colleagues via the formal route within Workday. Please do not submit paper or e-mail applications.

In line with good development planning, colleagues should discuss their suitability and/or readiness for a vacancy with their line manager prior to application. Colleagues are required to inform their manager if they are invited to attend interview. Where a line manager is not able to support an application either for suitability, readiness or business reasons, and a colleague continues to make an application, it is possible that an offer may not be made or may be withdrawn.

Applications not received by the closing date will only be accepted in exceptional circumstances and will require the support of your senior management team. All applicants must have the relevant authorisation to live and work in the UK.

Management retains right to change the job specifications and provisions of this job as appropriate.

 
Work Location Assignment: Flexible

Purpose 

Breakthroughs that change patients' lives... At Pfizer we are a patient centric company, guided by our four values: courage, joy, equity and excellence. Our breakthrough culture lends itself to our dedication to transforming millions of lives.  

Digital Transformation Strategy

One bold way we are achieving our purpose is through our company wide digital transformation strategy. We are leading the way in adopting new data, modelling and automated solutions to further digitize and accelerate drug discovery and development with the aim of enhancing health outcomes and the patient experience.

Flexibility  

We aim to create a trusting, flexible workplace culture which encourages employees to achieve work life harmony, attracts talent and enables everyone to be their best working self. Let’s start the conversation!  

Equal Employment Opportunity 

We believe that a diverse and inclusive workforce is crucial to building a successful business. As an employer, Pfizer is committed to celebrating this, in all its forms – allowing for us to be as diverse as the patients and communities we serve. Together, we continue to build a culture that encourages, supports and empowers our employees.

DisAbility Confident

We are proud to be a Disability Confident Employer and we encourage you to put your best self forward with the knowledge and trust that we will make any reasonable adjustments necessary to support your application and future career. Our mission is unleashing the power of our people, especially those with unique superpowers. Your journey with Pfizer starts here!

Finance & Accounting