Lead OneStream Financial Systems Analyst Job Listing at Medical Mutual in United States of America (Job ID 2500049)

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.6 million Ohioans 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.   

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 and help our members achieve their best possible health and quality of life.   

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

Education and Experience

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

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:

• Top Workplace in Northeast Ohio. Year after year we've received this recognition!
• On-site wellness center at most locations. Enjoy personal trainers, towel service, locker room, weight room, elliptical machines, and a variety of classes!
• On-site cafeteria serving hot breakfast and lunch, at most locations. Choices ranging from salad bar, made to order, hot and cold sandwiches, or a variety of entrees cooked fresh daily. Convenience store at most locations
• Employee discount program. Discounts at many places in and around town, just for being a Medical Mutual team member
• Business Casual attire

Excellent Benefits and Compensation:

• Competitive compensation plans
• Employee bonus program
• 401(k) with company match and an additional company contribution
• Excellent medical, dental, vision, and disability insurance

An Investment in You:

• Career development programs and classes
• Mentoring and coaching to help you advance
• Education reimbursement up to $5K per year

About Medical Mutual:

We strive to create peace of mind. Our customers can trust us to do things right and to help them get value from their health plan. We're the largest health insurer in Ohio and for over 85 years, we've been serving our members and the Ohio communities where they live and work. Medical Mutual is a Top Place to Work in Northeast Ohio with exceptional career opportunities that offer challenge, growth and a great work/life balance. We want talented, innovative, and driven people to help us continue to be the best health insurance choice of Ohioans and help make Ohio the best it can be! Our headquarter building is located in the heart of downtown Cleveland and we have multiple offices throughout the state. Join us at one near you!

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