Government Programs Data Analyst Job Listing at Medical Mutual in OH (Job ID 2400578)

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.

Supports business decisions through the use of data mining and analytics and identifying and resolving routine or standard issues through the reconciliation of large data sets. Serves as a resource regarding subject matter, data analytics, and regulatory reporting in assigned government programs functional area including but not limited to Medicare enrollment, revenue, government files processing, reconciliation, regulatory reporting, encounter data. 

This position has the option to work fully remote; Ohio residents preferred. 

Responsibilities

Government Programs Data Analyst I

• Utilizes data mining and analytical knowledge to understand large data sets. Develops reporting to meet business needs.  Provides clear, easy to understand summary documents and reports for management.   Maintain technical specifications, unit test plans, and dataflow diagrams. Follows quality assurance guidelines including the documentation, review and approval of all project related artifacts. 
• Prepares analysis to identify trends and issues, troubleshoot errors, validates data against other data sources, requirements and/or technical specifications, and work with data exchange processes and workflows between Company, government entities, and delegated entities to ensure accurate and complete data. 
• Collaborates with various departments to identify issues and errors that involve internal and external systems, government data, and regulatory guidance; supports data-related analytical projects to drive business decisions and efficiencies; ensures timely and accurate reporting, supports corrections of issues and errors, demonstrates best practices, support audits and attestations. 
• Builds knowledge of regulatory requirements and industry best practices as it relates to data.  Attends CMS training sessions and other appropriate industry meetings.
• Performs other duties as assigned.

Government Programs Data Analyst II

• Utilizes data mining and analytical knowledge to understand large data sets. Develops reporting to meet business needs.  Provides clear, easy to understand summary documents and reports for management.   Maintain technical specifications, unit test plans, and dataflow diagrams. Follows quality assurance guidelines including the documentation, review and approval of all project related artifacts. 
• Prepares analysis  to identify trends and issues, troubleshoot errors, validates data against  other data sources, requirements and/or technical specifications, and work with data exchange processes and workflows between Company, government entities, and delegated entities to ensure accurate and complete data.
• Collaborates with various departments to identify issues and errors that involve internal and external systems, government data, and regulatory guidance; supports data-related analytical projects to drive business decisions and efficiencies; ensures timely and accurate reporting, supports corrections of issues and errors,  demonstrates best practices, support audits and attestations. 
• Builds and maintains up to date knowledge of regulatory requirements and industry best practices as it relates to data.  Attends CMS training sessions and other appropriate industry meetings.

Performs other duties as assigned.

Government Programs Data Analyst III

• Utilizes data mining and analytical knowledge to understand large data sets. Develops reporting to meet business needs.  Provides clear, easy to understand summary documents and reports for management.   Creates and maintains technical specifications, unit test plans, and dataflow diagrams. Follows quality assurance guidelines including the documentation, review and approval of all project related artifacts. 
• Prepares analysis to identify trends and issues, troubleshoot errors, and propose methods for resolution.  Validates data against other data sources, requirements and/or technical specifications , and works with data exchange processes and workflows between Company, government entities, and delegated entities to ensure accurate and complete data. 
• Collaborates with various departments to identify and resolve routine to more complex issues and errors that involve internal and external systems, government data, and regulatory guidance.  Executes and may lead small to medium size data-related analytical projects to drive business decisions and efficencies. Ensures timely and accurate reporting, correction of issues and errors,  implements best practices, support audits and attestations.
• Participates in the development and implements data analytics, reconciliation, and reporting policies and procedures. Supports, trains and mentors more junior analysts.  Functions well within a matrix organization (e.g.– supporting multiple leaders).
• Maintains up to date knowledge of regulatory requirements and industry best practices  as it relates to data.  Attends CMS training sessions and other appropriate industry meetings.
• Performs other duties as assigned.

Sr. Government Programs Data Analyst

• Collaborates with various departments to identify and resolve complex  issues and errors that involve internal and external systems, government data, and regulatory guidance; leads and executes complex data-related analytical projects to drive business decisions and efficencies; ensures timely and accurate reporting, correction of issues and errors, implements best practices. May support audits and attestations. 
• Utilizes data mining and analytical expertise to understand large data sets. Provides clear, easy to understand summary documents and reports for all levels of management.  Creates technical specifications, unit test plans, and dataflow diagrams. Follows quality assurance guidelines including the documentation, review and approval of all project related artifacts. 
• Prepares analysis  to identify trends and issues, identifies areas for improvement and/or impact of initiatives and strategic plans, troubleshoot errors and propose methods for resolution, validates data against  other data sources, requirements and/or technical specifications , and work with data exchange processes and workflows between Company, government entities, and delegated entities to ensure accurate and complete data. 
• Develops and implements data analytics, reconciliation, and reporting policies and procedures. Supports, trains and mentors fellow analysts. Functions well within a matrix organization (e.g.– supporting multiple leaders).
• Maintains up to date knowledge of regulatory requirements and industry best practices  as it relates to data.  Attends CMS training sessions and other appropriate industry meetings.
• Performs other duties as assigned.

Lead Government Programs Data Analyst

• Cultivates collaborative and successful working relationships with internal and external groups to identify and resolve complex issues and/or data discrepancies that involve internal and external systems, government data, and regulatory guidance. Actively suggests analytics opportunities and best practices.   Uses data mining and analytical expertise to drive business decisions and efficencies; ensures timely and accurate reporting, correction of issues and errors, implements best practices, support audits and attestations.
• Provides clear, easy to understand summary documents and reports for all levels of management.   Creates technical specifications, unit test plans, and dataflow diagrams. Follows quality assurance guidelines including the documentation, review and approval of all project related artifacts.   Develops and implements policies and procedures.
• Leads more junior data analyst professionals. Ensures the successful development and implementation of initiatives. Provides peer review, training and oversight.  Conducts formal and informal training pertaining to new analytic approaches, data sources, and production system capabilities. May provide input instaffing, professional development, and performance management. 
• Serves as an expert resource to management and other departments on data and analyses.   Maintains up to date knowledge of regulatory requirements and industry best practices  as it relates to data.  Attends CMS training sessions and other appropriate industry meetings. 
• Performs other duties as assigned.

Qualifications

Government Programs Data Analyst I

Education and Experience

• Bachelors degree in Health Informatics, Healthcare or Business Administration, Statistics or related field.  Advanced degree preferred.
• 0-1 year experience in statistical analysis or data analysis which includes relational database structure, SQL programming, and DB2 in a mainframe environment. 
• Health plan experience preferred.
• Medicare or Medicaid managed care experience preferred.

Professional Certification(s)

• Relevant Certification and/or Licensure preferred (or working towards).

Technical Skills and Knowledge

• Basic knowledge of government programs regulations, requirements best practices.
• Basic knowledge of various data mining, reporting, and reconciliation tools and methodologies.
• Basic to intermediate proficiency with data display and narratives in support of business decisions.

Government Programs Data Analyst II

Education and Experience

• Bachelors degree in Health Informatics, Healthcare or Business Administration, Statistics or related field.  Advanced degree a plus.
• 2 years experience as a Government Programs Data Analyst or equivalent experience in statistical analysis or data analysis which includes relational database structure, SQL programming, and DB2 in a mainframe environment. 
• Health plan experience a plus.
• Medicare or Medicaid managed care experience a plus.

Professional Certification(s):

• Relevant Certification and/or Licensure preferred.

Technical Skills and Knowledge

• Knowledge of government programs regulations, requirements best practices.
• Knowledge of various data mining, reporting, and reconciliation tools and methodologies.
• Intermediate proficiency with data display and presentation tools such as Microsoft Office applications (especially Access and Excel), SAS, SQL, R, Python, data visualization tools (Tableau, PowerBI), business objects, and data warehousing.

Government Programs Data Analyst III

Education and Experience

• Bachelors degree in Health Informatics, Healthcare or Business Administration, Statistics or related field.  Advanced degree preferred.
• 3 years experience as a Government Programs Data Analyst or equivalent experience in statistical or data analysis.
• Health plan experience preferred.
• Medicare or Medicaid managed care experience preferred.

Professional Certification(s)

• Relevant Certification and/or Licensure preferred (or working towards).

Technical Skills and Knowledge

• Strong knowledge of government programs regulations, requirements best practices.
• Knowledge of various data mining, reporting, and reconciliation tools and methodologies.
• Intermediate to advanced proficiency with database reporting and query writing and Microsoft Office applications (especially Access and Excel), SAS, SQL, data visualization tools (Tableau, PowerBI), business objects, and data warehousing.
• Ability to write policies that are compliant with Federal laws.

Sr. Government Programs Data Analyst

Education and Experience

• Bachelors degree in Health Informatics, Healthcare or Business Administration, Statistics or related field.  Advanced degree preferred.
• 5 years experience as a Government Programs Data Analyst or equivalent experience in statistical analysis or data analysis.
• Health plan experience preferred.
• Medicare or Medicaid managed care experience preferred.

Professional Certification(s)

• Relevant Certification and/or Licensure strongly preferred.

Technical Skills and Knowledge

• Comprehensive knowledge of government programs regulations, requirements best practices.
• Knowledge of various data mining, reporting, and reconciliation tools and methodologies.
• Advanced proficiency with database reporting and query writing and Microsoft Office applications (especially Access and Excel), SAS, SQL, data visualization tools (Tableau, PowerBI), business objects, and data warehousing.
• Ability to document standard operating procedures and/or write policies.

Lead Government Programs Data Analyst

Education and Experience

• Bachelors degree in Health Informatics, Healthcare or Business Administration, Statistics or related field.  Advanced degree preferred.
• 7 years progressive experience in statistical and/or data analysis which includes  project management.   
• Health plan experience preferred.
• Medicare and/or Medicaid managed care experience preferred.

Professional Certification(s)

• Relevant Certification and/or Licensure strongly preferred

Technical Skills and Knowledge

• Comprehensive knowledge of government programs regulations,  requirements, and best practices and the ability to apply advanced concepts to Company operations.
• Expert knowledge of various data mining, reporting, and reconciliation tools and methodologies.
• Comprehensive knowledge and advanced proficiency with relational database structure/reporting and query writing, DB2 in a mainframe environment and Microsoft Office applications (especially Access and Excel), SAS, SPSS, SQL, Business Objects, QMF for Windows, and data warehousing.
• Ability to document standard operating procedures and/or write policies 
• Ability to function well within a matrix organization (e.g. supporting multiple leaders).
• Ability to communicate and present to all levels in the organization, including executive management.

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.