What are the responsibilities and job description for the Systems Analyst Intermediate Sales and Marketing , Geisinger Health Plan (work from home Pennsylvania resident) position at Geisinger?
- 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.
Qualifications:
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
