Senior Financial Analyst

Blue Cross Blue Shield of Michigan - Detroit, MI3.9

30+ days ago
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.Qualifications

Bachelor's Degree in Accounting, Finance or related field required.
Two (2) to four (4) years experience in related field.
Strong analytical, organizational and problem-solving skills.
Good verbal and written communication skills.
Ability to work under general supervision in an environment where there are certain deadlines.
Proficient in current industry standard PC applications and systems (e.g., Excel, Word, etc.).
Working knowledge of PeopleSoft general ledger and mainframe systems.
General knowledge of Generally Accepted Accounting Principles (GAAP).
Other related skills and/or abilities may be required to perform this job.
All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, gender identity, protected veteran status or status as an individual with a disability.

Job Finance Treasury & AccountingPrimary Location DetroitOrganization Finance Health Plan Bus-1130Schedule Full-time