Sr. Benefit Plans Specialist - Reporting

Company: Wespath
Location: Glenview
Posted on: May 4, 2022

Job Description:

Sr. Benefit Plans Specialist - ReportingLocation:1901 Chestnut AveGlenview, Illinois, 60025United States Category:Benefit PlansDate Needed by:6/1/2022Primary Duties and Responsibilities: Do you want to work for a company who lives into their values of integrity, mutual respect, and teamwork? Do you want to help others while working for a company making an impact on environmental, social and governance issues? Wespath Benefits and Investments, recognized as a 2017-2021 Chicago's Best and Brightest Companies to Work For and a 2018-2021 National Best and Brightest Companies to Work For, is now hiring for a position created to help with our benefit plan reporting needs. As the Senior Benefit Plans Specialist - Reporting you'll help our health, welfare and retirement benefit teams in the compilation and analysis of their data by providing tracking towards key goals or metrics, developing reports for both internal and external audiences, and being a subject matter expert on vendor tools including our health data warehouse. More specifically, as a senior reporting specialist you will have the opportunity to: Create weekly/monthly/quarterly dashboards from internal and vendor systems for our Health/Welfare department and Retirement department. Prepare annual benefit plan reports for external audiences by: Leveraging vendor reports for ongoing execution and enhancements. Compiling data from multiple sources and manipulating to complete calculations and gather reporting information. Programming various tools (e.g., Word, Excel, Power Bi) to output the desired reports. Collaborating with other Benefit Plans stakeholders and the Communications department on the design and content of the deliverable. Develop technical and subject matter expertise for vendor applications, health data warehouse and internal Wespath systems. Support health plan impact analyses (wellness program impacts, cohort analyses, targeted research) by developing metrics, datasets, dashboards and reports as needed.LI-JR1 Senior Benefit Plans Specialist - Reporting Benefits Medical, dental, vision, and well-being benefits on day one 8% employer retirement plan contribution on day one with opportunity for 2% match of the employee contribution 22 days of PTO 11 paid holidays two floating holidays in 2022 Free financial planning assistance by EY Hybrid work arrangement Work from home unless there is a need to be in the office or you want to work from the office Minimum Requirements/Qualifications:Bachelors' degree in business, finance, accounting, mathematics, statistics or economics, related discipline, or equivalent work experience. 2 years of experience in data management/manipulation and data warehousing or database experience, preferably in the financial services, retirement or health benefits industry. Demonstrated experience with data manipulation and the setup and use of database systems. Expert proficiency with Excel and Word. Advanced proficiency with Access, SQL, or other database tools. Preferred Requirements/Qualifications: Data Visualization Experience - Able to use visual elements like charts, graphs, and maps to provide an accessible way to see trends and communicate data. Proficiency in programing Visual Basic for Applications (VBA). Experience with and understanding of retirement, health and welfare plan data. Wespath Benefits and Investments is an Equal Opportunity Employer and does not discriminate in hiring.PDN-95f6a3c6-4927-4e5c-b451-4cbfb645eec2

Keywords: Wespath, Glenview , Sr. Benefit Plans Specialist - Reporting, Advertising , Glenview, Illinois