Job Summary

Provides application support to the Commercial Sales and Medicare division including the Call Center staff. Provides reporting and data analysis, as appropriate, in order to support Commercial and Medicare Sales in addition to Sales and Marketing Management. Trains sales staff on specific applications, assists with the development and implementation of database enhancements and facilitate the integrity of appropriate databases.

Job Duties

• Assists with conceptual and logical database design based on functional areas and business rules.
• Acquires, maintains and articulates a thorough understanding of the business' functional process and data requirements.
• Serves as the initial point of contact for the Commercial and Medicare Sales end user community by providing first-level support for assigned applications.
• Works with IT and database administrative staff and application developers to ensure application meets stated functional requirements.
• Writes SQL to accommodate ad hoc all relevant data requests.
• Provides User and IT liaison service to determine new requirements and to resolve difficulties over data access or performance.
• Maintains data including existing data and replenishment of data, de-dups.
• data, manages purchased data lists, routinely audits data for accuracy.
• Works in conjunction with all appropriate internal departments specific to data retrieval, analysis and reporting, e.g. Actuarial Support and QI.
• Works with Commercial and Medicare Sales and Sales and Marketing Management in the development of reports that assist in identifying sales opportunities that will produce net income for the health plan.
• Develops and manages Sales training content, process maps and Sales maps used in the Onyx Help Menu.
• Creates mailing lists for all direct mail campaigns including prospective commercial group by renewal effective date and Gold enrollment for newly eligible Medicare beneficiaries.
• Creates and maintains the codes necessary to track sales and marketing data.
• Works cooperatively with other team members to assure that the RFP fields reported upon and summarization thereof in all reports are created accurately and in a timely manner.
• Assists other team members in assuring that a draft lay-out for preliminary communication on all requested RFP reports is communicated to and agreed upon by the requestor and customer in the time frame specified on the RFP request form.
• Responsible for facilitating completion of formal sales proposals as initiated by national employee benefit consulting firms.

Work is typically performed in an office environment. Accountable for satisfying all job specific obligations and complying with all organization policies and procedures. The specific statements in this profile are not intended to be all-inclusive. They represent typical elements considered necessary to successfully perform the job.

Position Details

Additionally, the successful candidate will:

• Serve as assistant project manager for Medicare Annual Enrollment Period Data and Document Collection Project
  • Provides support to vendors and EMO/FMO partners
  • Ensures all data and documents are completed accurately and submitted by due date
  • Review products for plan data accuracy, conduct quality assurance, and provide approval of sites

• Serve as Product Owner for enrollment platform Connecture
  • Train internal and external stakeholders, provide access to all users and troubleshoot access issues, meet regularly with Connecture

• Maintain master file of daily Health Risk Assessment (HRA) files; Compilation of HRA data for distribution to clinical colleagues
• Manage lead generation projects, specifically Medicare T65, by running and maintaining reports, with equal distribution/assignment of leads among sales teams
• Create and maintain reports and dashboards in Salesforce
• Analyze membership data, performing VLOOKUP, and provide a monthly report to Case Management
• Provide dedicated operational support for Inside Sales operations, including CMS test calls

Education

Bachelor's Degree- (Required)

Experience

Minimum of 3 years-Information Technology (Required), Minimum of 3 years-Healthcare (Preferred)

Skills

Critical Thinking; Computer Literacy; Working Independently; Teamwork; Organizing

About Geisinger

Founded more than 100 years ago by Abigail Geisinger, the system now includes ten hospital campuses, a 550,000-member health plan, two research centers and the Geisinger Commonwealth School of Medicine. With nearly 24,000 employees and more than 1,700 employed physicians, Geisinger boosts its hometown economies in Pennsylvania by billions of dollars annually. Learn more at geisinger.org or connect with us on Facebook, Instagram, LinkedIn and Twitter.

Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws.

Our Vision & Values

Everything we do is about making better health easier for our patients, our members, our students, our Geisinger family and our communities.

KINDNESS: We strive to treat everyone as we would hope to be treated ourselves.

EXCELLENCE: We treasure colleagues who humbly strive for excellence.

LEARNING: We share our knowledge with the best and brightest to better prepare the caregivers for tomorrow.

INNOVATION: We constantly seek new and better ways to care for our patients, our members, our community, and the nation.

SAFETY: We provide a safe environment for our patients and members and the Geisinger family.

Our Benefits

We offer healthcare benefits for full time and part time positions from day one, including vision, dental and prescription coverage.