Senior Financial Analyst - FIN000D6
DESCRIPTION/RESPONSIBILITIES:
Departmental Posting and Preferences:
1) Overall Tasks/Duties:
* Segment Consolidation Coordination (admin dashboards, monthly- day 6, day 9 populating and submitting, ad hoc and planning P/Ls from HPB, historic and final submissions) and ensuring same look and feel for all of our standard reporting/ad hoc requests.
* Hyperion / HPB Consolidation / Admin support (ensuring Hyperion and system inputs and dependencies, scenarios and all allocations coordination are formatted or pulled). This would include FI/ASC/SL and BCN Hyperion or analysis that came. HPB reporting for BCN RTB, MBR or meeting support. Admin PO and/or HPB functional admin support.
* Ad Hoc - consolidating FPM decks, CP or Pricing decks or edits, format and content editor. Support calendars and timing on all cycles, aligning with HPB consolidation and any Segment specific PO needed reporting or targeting. Run our SharePoint site and file coordination with Actuary. May also support IBU/EAB as well.
2) Preferred Knowledge, Skills and Abilities:
* Proficient in Hyperion
* Highly proficient in Microsoft Excel (Macros, Pivot tables, v-lookups)
* Proficient in Microsoft PowerPoint
* Experience with ThinkCell
* Strong attention to detail and accuracy
* Experience consolidating data across multiple sources
* Comfortable working in a shared services role, supporting and interacting with multiple stakeholders
Standard Posting
Responsible for monitoring, analyzing and reporting financial information including revenue and expenses by account, customer and product segments. These duties may include variance analysis, account reconciliation, transaction processing and publishing of various financial reports and financial statements.
* Prepares financial information and reviews for accuracy and completeness.
* Performs detailed analysis when necessary.
* Other deliverables may include account reconciliations, impact studies, audit findings, budgets and business cases.
* Assists with the preparation of various financial or regulatory reports and/or statements for management and/or parties external to BCBSM (e.g., auditors, customers, providers, BCBSA, FEP, OFIS, etc).
* Prepares financial reporting for a division, customer or segment that may include linking financial information from various sources to provide meaningful financial reports or to assure appropriate data reconciliation.
* Financial data may include financial statements detail, corporate, division and cost center BPR information, cost allocation information, general ledger transaction activity, settlement activity, membership, billing and revenue activity.
* May process financial transactions including journal entries, invoices, cost allocations, etc. Assists with drafting of policies and develops desk level procedures for the department to help assure clarity in department practices and adequate internal controls.
* Interfaces with various departments, management and individuals' external to BCBSM. Responds to ad-hoc requests and inquiries.
* Performs other assignments, duties or functions as assigned by management.
All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, , national origin, orientation, age, gender identity, protected veteran status or status as an individual with a disability.
