The Opportunity
The Senior Analyst of International Deferred Margin is part of the Corporate Financial Services (CFS) organization. The primary objectives of Deferred Margin team are the accurate accounting, planning and forecasting of intercompany profit to support ANI EPD AVD performance and entity accounting, as well as the development and distribution of sales related data throughout the ANI EPD AVD organization This group manages the elimination and release of roughly $2 Billion of intercompany profit annually to ensure that the financial statements reflect the true consolidated cost to Abbott as opposed to the legal cost used in tax reporting.
Deferred margin reporting brings a new set of dimensions / complexities that need to be properly defined, understood, and articulated to the organizations that it supports.
The primary responsibilities of this position supporting Abbott Nutrition / Established Pharmaceutical Division / Abbott Vascular divisions include :
Master Data for Net Cost and Margin Factors HFM Journal Entries for Deferred Margin Balance Sheet Review & Reconciliations
Master Data for Net Cost and Margin Factors
Master Data : Generate net cost and margin factors that represent the intercompany margin in products that are currently sold or plan to be sold by ANI / EPD / AVD.
This activity requires knowledge, collection and validation of transfer prices, standard costs, manufacturing usages, supply chain information, currencies, and exchange rates.
Monitor, analyze and correct Billing Price / Cost variances.
Provide analysis of year-to-year changes in margin factors to support planning activities and profitability reviews.
Resolve affiliate product profitability issues associated with intercompany margin.
HFM Journal Entries for Deferred Margin
Record the deferral and release of Deferred Margin on the Balance Sheet ($.5Billion) and Income Statement ($2Billion) to ensure that Abbott reports proper consolidated financials.
Due to the dynamic nature of the intercompany structure and billing flows, process improvements are frequently required to adapt existing processes to the new environment
Provide active and continuous support of the margin financial impact for ANI / EPD / AVD, ad hoc analysis to support Commercial Areas and Global Supply Chain organizations, and recognize the financial impact of decisions
Balance Sheet Review & Reconciliations
Analyze complex Deferred Margin inventory account reconciliations - develop recommendations to clear reconciling items, and implement solutions.
Monitor the annual and mid-year inventory Standard Revision Variance calculations due to changes in Transfer Price and Manufacturing Cost, resolve differences with international affiliates
Influence and provide guidance for decision making within the team, management, and or functional groups for system, process, or data issues
Support Deferred Margin data with external auditors
Educational / Experience Requirements :
Minimum of a Bachelor’s degree in Finance or Accounting
2-4 years experience in general or international accounting
Interested to work in an Accounting / Finance role supporting several divisions and international affiliates
Skills Required to Excel in Role
Quantitative, analytical, and problem solving skills
Organize and prioritize in a fast-paced work environment
Partner with persons contacted in the course of performing the assigned duties
Excellent verbal and written communication skills
Expected Technical Skills :
High proficiency in Microsoft Excel including creating / maintaining Pivot Tables and formula writing (ie VLOOKUP, SUMIFS, and ability to write conditional IF or IFERROR statements)
Ability to summarize / analyze large data sets with the aid of Microsoft Access or Microsoft Excel or Power Query
Proficiency in the financial reporting tool Hyperion Financial Management's (HFM) and its Smart View Excel Add-in
Data entry in Mainframe system