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)

Certification(s) and License(s)

OUR PURPOSE & VALUES: Everything we do is about caring 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 We offer healthcare benefits for full time and part time positions from day one, including vision, dental and domestic partners. Perhaps just as important, from senior management on down, we encourage an atmosphere of collaboration, cooperation and collegiality. We know that a diverse workforce with unique experiences and backgrounds makes our team stronger. Our patients, members and community come from a wide variety of backgrounds, and it takes a diverse workforce to make better health easier for all. We are proud to be an affirmative action, equal opportunity employer and all qualified applicants will receive consideration for employment regardless to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or status as a protected veteran.