Pfizer FRI CoE Senior Data Specialist in Memphis, Tennessee
The Financial Reporting Initiative (FRI) Program is a global Pfizer initiative tasked with the primary objective of delivering segmented balance sheet results in order to support the external reporting disclosures associated with Pfizer's business units: Pfizer Essential Health and Pfizer Innovative Health, comprised of the legacy Global Innovative Pharma (GIP), Global Vaccines, Oncology and Consumer businesses. The initiative also generates the financial information necessary to support strategic decision making by segmenting and collecting financial statement data for the income statement and cash flow statement. The FRI Program is transitioning from a project to a Center of Excellence (CoE) and this role will be based in the CoE.
The FRI CoE Senior Data Specialist will report to the FRI CoE Data Team Lead in Memphis and support the execution of program activities. The FRI CoE Senior Data Specialist will be responsible for carrying out workstream objectives which focus on Basis of Presentation Segmentation.
In order to support the global segmentation process, the FRI CoE Senior Data Specialist will collaborate cross-functionally within GFS and others, as necessary, to drive the timely creation of program deliverables, achieve program objectives, and ensure FRI responsibilities are fulfilled. This role will also require collaboration to support the on-going activities and initiatives of Pfizer as a whole in support of the OnePfizer mentality.
Obtain an understanding of segmentation methodologies to perform accurate segmentation, work with FRI Basis and Data Team Leads and leadership to adapt methodologies as necessary
Operational Transformation support including independently driving issue resolution, serving as first point of contact for escalations and reviewing analysis/work product prepared by support staff
Collect necessary data from Pfizer colleagues (GFS, Commercial Finance, Technical Accounting, etc.) to perform segmentation of accounts and prepare journal entries
Execute data queries utilizing both a relational database (SQL) and/or ETL tools (ie Alteryx)
Perform maintenance for and troubleshoot issues that originate from a SQL database and/or ETL workflow tools
Research and resolve discrepancies and complex issues as necessary
Link multiple sources of financial data - ERP data from SAP/Oracle with HFM data to produce reconciliation reports
Assist in carve-out preparation by providing raw source data as well as complex data analysis required for segmentation
Compile metrics and ad-hoc reports as requested
Review tasks prepared and completed by staff accountants
Maintain complete and accurate standard operating procedures and related internal control documentation
Maintain complete and accurate task lists and status of open items to prepare status updates as requested by management
Initiate tasks with little to no guidance or support and take initiative to understand complex problems
Participate in special projects and other initiatives that are in addition to existing role and responsibility
Identify issues proactively and communicate to management along with potential range of solutions
Identify and participate in the implementation of continuous improvement projects and monitor the impact on FRI to ensure methodologies and SOPs are updated accordingly
Seek opportunities to participate in site activities
Education and Experience
Bachelor degree in Statistics, Computer Science, Information Systems, Finance/Accounting or related field
CPA eligible preferred
1+ years of relevant functional accounting or finance experience preferred
4+ years of proven experience working with complicated data manipulation and data analysis. Critical thinking and problem solving skills
Public accounting experience preferred
Technical Skills Required
Strong background in SQL preferred (ability to code and troubleshoot stored procedures )
Experience with ETL tools such as Alteryx preferred. If candidate does not possess background in Alteryx, must be willing to learn the tool quickly.
Experience with SAP and HFM preferred
Proficiency in PC skills (Word, PowerPoint) required
Advanced Excel skills preferred
Experience with Tableau is a plus
Excellent oral, written, and overall communication skills
Strong analytical and critical thinking skills
Ability to informally mentor staff accountants
Ability to work independently, manage multiple priorities, and research and resolve problems
Strong business acumen and professionalism with the ability to interface effectively with all levels of management and operations colleagues in all applicable Pfizer Finance and business functional areas
Ability to perform and deliver in areas involving ambiguity
EEO & Employment Eligibility
Pfizer is committed to equal opportunity in the terms and conditions of employment for all employees and job applicants without regard to race, color, religion, sex, sexual orientation, age, gender identity or gender expression, national origin, disability or veteran status. Pfizer also complies with all applicable national, state and local laws governing nondiscrimination in employment as well as work authorization and employment eligibility verification requirements of the Immigration and Nationality Act and IRCA. Pfizer is an E-Verify employer.
Pfizer reports payments and other transfers of value to health care providers as required by federal and state transparency laws and implementing regulations. These laws and regulations require Pfizer to provide government agencies with information such as a health care provider's name, address and the type of payments or other value received, generally for public disclosure. Subject to further legal review and statutory or regulatory clarification, which Pfizer intends to pursue, reimbursement of recruiting expenses for licensed physicians may constitute a reportable transfer of value under the federal transparency law commonly known as the Sunshine Act. Therefore, if you are a licensed physician who incurs recruiting expenses as a result of interviewing with Pfizer that we pay or reimburse, your name, address and the amount of payments made currently will be reported to the government. If you have questions regarding this matter, please do not hesitate to contact your Talent Acquisition representative.
Other Job Details:
- Eligible for Employee Referral Bonus
Pfizer is an equal opportunity employer and complies with all applicable equal employment opportunity legislation in each jurisdiction in which it operates.