Senior Financial Analyst Deferred Margin
Job Description
Senior Financial Analyst supporting Deferred Margin processes for Abbott Nutrition at Abbott Park, IL (onsite).
Responsibilities
- Build master data for net cost and margin factors representing intercompany margin for products sold or planned for sale by ANI/EPD/AVD
- Gather, validate, and manage inputs required for transfer pricing and margin factor calculations, including transfer prices, standard costs, manufacturing usages, supply chain information, currencies, and exchange rates
- Monitor, analyze, and correct Billing Price/Cost variances
- Support data collection in the Central Cost System across Plan and Actual cycles
- Analyze year-to-year changes in margin factors to support planning activities and profitability reviews
- Respond to requests from international affiliates involving supply chain, group costs, and billing price records
- Record deferral and release of Deferred Margin on the Balance Sheet (amount indicated: $0.5B) and Income Statement (amount indicated: $2.0B) to support correct consolidated financial reporting
- Prepare margin journal entries in Hyperion Financial Management (HFM), including Exchange, P&L adjustments, Balance Sheet activity, Standards Revision Variance (SRV), exchange scenarios for @Plan and @Prior Year, plus ad hoc entries
- Provide active and continuous analysis of deferred margin financial impact for ANI/EPD/AVD, including ad hoc support for Commercial Areas and Global Supply Chain organizations
- Analyze complex Deferred Margin inventory account reconciliations, develop recommendations to clear reconciling items, and help implement solutions
- Monitor annual and mid-year inventory Standard Revision Variance calculations related to changes in Transfer Price and Manufacturing Cost; resolve differences with international affiliates
- Influence and provide guidance to support decision-making within the team, management, and/or functional groups on system, process, and data issues
- Support the Deferred Margin function for external auditors
Requirements
- Bachelor’s degree in Accounting or Finance
- Excellent verbal and written communication skills
- Ability to work in an Accounting/Finance role supporting several divisions and international affiliates
Technologies
- Hyperion Financial Management (HFM)
- Microsoft Excel
- Pivot Tables
- VLOOKUP
- SUMIFS
- IF
- IFERROR
Preferred Qualifications
- Quantitative, analytical, and problem-solving skills
- Ability to organize and prioritize in a fast-paced work environment
- Experience partnering with stakeholders contacted during assigned duties
- High proficiency in Excel, including creating and maintaining Pivot Tables and writing formulas using tools such as VLOOKUP, SUMIFS, and conditional IF or IFERROR statements
Compensation & Location
- Location: Abbott Park, IL (onsite)
- Salary: USD 78,000 - 156,000 per year
Benefits
- Free medical coverage for employees via the Health Investment Plan (HIP) PPO
- Retirement savings plan with high employer contribution
- Tuition reimbursement, Freedom 2 Save student debt program, and FreeU education benefit
What You’ll Work On
- Master Data for Net Cost and Margin Factors
- HFM Journal Entries for Deferred Margin and Month End Close support
- Balance Sheet Review & Reconciliations
Similar Jobs
T