Financial Systems Analyst Job Listing at Medical Mutual in OH (Job ID 2500194)

Description

Founded in 1934, Medical Mutual is the oldest and one of the largest health insurance companies based in Ohio. We provide peace of mind to more than 1.2 million members through our high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement, and individual plans.

This position has the option to be fully remote with the expectation to be on site for meetings in Brooklyn, OH monthly; Ohio residents preferred.

Financials Systems Analyst III

Job Summary:

Under general supervision, updates and maintains financial systems and related reporting. Recommends, creates and implements tools, processes and procedures to address specific business needs. Provides user training and support and acts as a liaison with IT to resolve systems issues.   

Responsibilities:

• Analyzes existing processes and system functionality; assesses needs of user and optimizes system data to provide information needed; analyzes data to ensure accuracy.
• Performs financial reconciliations of source systems to the General Ledger.
• Creates systematic solutions for department projects.  Analyzes user requirements; designs, tests and implements.
• Provides user training and ongoing support on financial systems databases and software. Acts as a liaison with IT to resolve system issues.
• Creates analyses and reports for management decision support, regulatory filings and other business needs.
• Performs other duties as assigned.

Sr. Financials Systems Analyst

Job Summary:      

Performs a lead role in the preparation of internal financial statements, audited financial statements and regulatory reporting through complex general accounting activities, analysis and staff oversight.

Responsibilities:

• Designs, tests and runs queries to generate monthly reports for premium, claims and enrollment to be used by several operating areas for financial reporting. Generates additional data reporting for various departmental needs including reinsurance reporting, group level analysis and TPA billing.
• Creates new tools and reports for Finance management to address specific business needs. Analyzes existing processes and functionality as they apply to business areas of interest; assesses data needs of user and utilizes current system data or develops new queries to provide information needed; analyzes data to ensure accuracy; provides ongoing support to users.
• Creates systematic solutions for Finance department projects. Requires ability to analyze user requirements; designs, tests and implements systematic solutions; provides ongoing support to users.
• Creates quarterly and annual reports for premium, claims and enrollment to be used in preparing the related regulatory filings required by state, the NAIC, and HHS.
• Performs other duties as assigned.

Lead Financials Systems Analyst

Job Summary:      

Performs a lead role in the preparation of internal financial statements, audited financial statements and regulatory reporting through complex general accounting activities, analysis and staff oversight.

Responsibilities:

• Designs HCR data collection and reporting tools. Facilitates meetings with data users and utilizes problem solving skills to create solutions that meet user needs. Supports user issues and questions regarding the data and use of the tool.
• Creates new tools and reports for Finance management to address specific business areas requiring analysis.  Requires ability to analyze existing processes and functionality as they apply to business areas of interest; assesses data needs of user and utilizes current system data or develops new queries to provide information needed; analyzes data to ensure accuracy; provides ongoing support to users. Assists in reviewing and streamlining processes for the finance department.
• Creates systematic solutions for Finance department and Executive management projects.  Requires ability to analyze user requirements; designs, tests and implements systematic solutions; provides ongoing support to users.
• Creates monthly, quarterly and annual reports for premium, claims and enrollment to be used in preparing the related regulatory filings required by state, the NAIC, and HHS.
• Designs, tests and runs queries to generate monthly reports for premium, claims and enrollment to be used by several operating areas for financial reporting. Creates additional raw data for various financial reporting needs including Alliance tax analysis, group level analysis and TPA billing.
• Performs other duties as assigned.

Qualifications

Financials Systems Analyst III

Education and Experience:

• Bachelor's degree in Accounting, Information Systems or Business administration.
• 3 years experience in financial systems analysis, preferably in a health plan or the financial services industry.
• Experience with Oracle Financial systems strongly preferred.

Professional Certification(s):

• Certified Public Accountant (CPA) preferred.

Technical Skills and Knowledge:

• Strong working knowledge of DB2, SQL, SQL Server, Microsoft Visual Basic, SAS and familiarity with mainframe-based accounting systems.
• Basic knowledge of Generally Accepted Accounting Principles.
• Intermediate to advanced Microsoft Office skills including Access.
• Ability to interpret and articulate standard business and financial concepts.

Sr. Financials Systems Analyst

Education and Experience:

• Bachelor's degree in Accounting, Information Systems or Business administration.
• 5 years progressive finance experience.
• Master's degree preferred.

Professional Certification(s):

• N/A

Technical Skills and Knowledge:

• Strong working knowledge of DB2, SQL, SQL Server, Microsoft Visual Basic, QMF for windows and familiarity with mainframe-based accounting systems.
• Intermediate MS Office Skills including MS Access.
• Proven ability to interpret and articulate complex business and financial concepts.
• Experience and in-depth knowledge of financial matters at a corporate level.

Lead Financials Systems Analyst

Education and Experience:

• Bachelor's degree in Accounting, Information Systems or Business administration.
• 8 years progressive experience in financial operations.
• Master's degree preferred.

Professional Certification(s):

• N/A

Technical Skills and Knowledge:

• Strong working knowledge of DB2, SQL, SQL Server, Microsoft Visual Basic, QMF for windows and familiarity with mainframe-based accounting systems.
• Intermediate MS Office Skills including MS Access.
• Proficiency in the application of state and federal financial, legal, and regulatory requirements.
• Experience and in-depth knowledge of financial matters at a corporate level.
• Proven ability to interpret and articulate complex business and financial concepts.

Medical Mutual is looking to grow our team! We truly value and respect the talents and abilities of all of our employees. That's why we offer an exceptional package that includes:

A Great Place to Work:

• We will provide the equipment you need for this role, including a laptop, monitors, keyboard, mouse and headset.
• Whether you are working remote or in the office, employees have access to on-site fitness centers at many locations, or a gym membership reimbursement when there is no Medical Mutual facility available. Enjoy the use of weights, cardio machines, locker rooms, classes and more.
• On-site cafeteria, serving hot breakfast and lunch, at the Brooklyn, OH headquarters.
• Discounts at many places in and around town, just for being a Medical Mutual team member.
• The opportunity to earn cash rewards for shopping with our customers.
• Business casual attire, including jeans.

Excellent Benefits and Compensation:

• Employee bonus program.
• 401(k) with company match up to 4% and an additional company contribution.
• Health Savings Account with a company matching contribution.
• Excellent medical, dental, vision, life and disability insurance — insurance is what we do best, and we make affordable coverage for our team a priority.
• Access to an Employee Assistance Program, which includes professional counseling, personal and professional coaching, self-help resources and assistance with work/life benefits.
• Company holidays and up to 16 PTO days during the first year of employment with options to carry over unused PTO time.
• After 120 days of service, parental leave for eligible employees who become parents through maternity, paternity or adoption.

An Investment in You:

• Career development programs and classes.
• Mentoring and coaching to help you advance in your career.
• Tuition reimbursement up to $5,250 per year, the IRS maximum.
• Diverse, inclusive and welcoming culture with Business Resource Groups.

About Medical Mutual:

Medical Mutual's status as a mutual company means we are owned by our policyholders, not stockholders, so we don't answer to Wall Street analysts or pay dividends to investors. Instead, we focus on developing products and services that allow us to better serve our customers and the communities around us.

There's a good chance you already know many of our Medical Mutual customers. As the official insurer of everything you love, we are trusted by businesses and nonprofit organizations throughout Ohio to provide high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement and individual plans. Our plans provide peace of mind to more than 1.2 million Ohioans.

We're not just one of the largest health insurance companies based in Ohio, we're also the longest running. Founded in 1934, we're proud of our rich history with the communities where we live and work.

We maintain a drug-free workplace and perform pre-employment substance abuse and nicotine testing.

#LI-CS1 #LI-REMOTE