Systems Analyst Intermediate Sales and Marketing , Geisinger Health Plan (work

Job SummaryProvides application support to the Retail Sales (Individual and Medicare) lines of business, which includes Inside and Field Sales staff. Provides reporting and data analysis, as appropriate, in order to support Retail Sales in addition to Sales and Marketing Management. Trains a variety of 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 DetailsAdditionally, 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 callsEducationHigh School Diploma or Equivalent (GED)- (Required)ExperienceMinimum 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.We are an Affirmative Action, Equal Opportunity Employer Women and Minorities are Encouraged to Apply. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of disability or their protected veteran status.