Hybrid Financial Systems Analysis Consultant at Blue Cross Blue Shield of Michigan Mutual Insurance Company

Responsible for leading the configuration of technology solutions to deliver financial reporting to internal customers; ensure that the designated financial systems (e.g. Hyperion, etc.) are operating effectively to support the annual budgeting, forecasting and long-term financial modeling system. Provide regular status updates to leadership and manage vendors.

• Function as the central contact for designated financial system platforms (e.g. Hyperion, Essbase) and related enterprise  products which may include data maintenance, business rules and formula development, structural interfaces, security maintenance, systems integration, inquiry administration, vendor management development and presentation of updates to senior leadership.
• Conduct analysis on enterprise and segment financial data to assess trends, variance and scenario planning and present results and recommendations to senior leadership and segment owners to conduct strategic planning.
• Manage multiple projects including the development and implementation of strategic cross functional project plans including tasks, timelines, resources, roles, responsibilities, testing, communication and training for financial system enhancements.
• Regularly review and develop recommendations for improvement of designated system (e.g. Hyperion) structure and reports; present recommendations to finance senior leadership.
• Assess the financial reporting needs of the segment and functional areas through leadership engagement to understand the necessary enhancements and utilize financial reporting systems to create, update and deliver consistent financial reporting solutions to business leadership. Serve as liaison between IT and Finance for role development, responsibilities and system guidelines.
• Design, develop and deliver all financial system documentation and support including desk procedures, user support material and end user training.
• Other duties as assigned.

EDUCATION AND/OR EXPERIENCE

• Bachelor's degree in Accounting, Finance, IT or related field required. MBA preferred.
• Five to Seven years experience in Accounting/Finance in the health insurance industry.
• Accounting / Finance certification preferred (i.e., CPA, CMA, CFM)
• Three years experience in Hyperion planning and strategic finance applications, and Essbase.
• One year experience in Oracle Data Integrator and leading cross functional projects with enterprise scope.

OTHER SKILLS AND ABILITIES

• Working knowledge of financial transactions flow and corresponding financial statement impact.
• Demonstrated aptitude for development of flow charts, process flows, project plans, problem solving, solution creation and generation of contributions to business.
• Ability to develop and adhere to project plans, direct resources and manage multiple and changing priorities.
• Proficient in current industry and standard PC application systems (e.g. Microsoft Office Suite) and Hyperion.
• Experience applying technology to business problems, structuring recommendations for system configuration and design and execute test plans. Sufficient technical knowledge to successfully communicate requirements and solutions to technical and non-technical audiences.

DEPARTMENTAL PREFERENCES

• Capital planning and Forecasting experience