Systems Analyst Intermediate Sales and Marketing , Geisinger Health Plan (work from home Pennsylvania resident)

About the position

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.

Responsibilities

• 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.
• 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.

Requirements

• Bachelor's Degree (Required)
• Minimum of 3 years in Information Technology (Required)
• Minimum of 3 years in Healthcare (Preferred)
• Skills: Computer Literacy, Critical Thinking, Organizing, Teamwork, Working Independently

Benefits

• Healthcare benefits for full time and part time positions from day one, including vision, dental and domestic partners.
• Encouragement of an atmosphere of collaboration, cooperation and collegiality.