The Water Environment Federation is seeking a Report Writer and Data Management Specialist to join its Information Technology Team. This position will serve as the point of contact for staff requests on report creation and modifications from the AMS and the Data Analytics Warehouse; resolve database and reporting issues created by staff in our ticketing system; and will perform monthly routine processes for month end closing including financial reconciliation, membership renewals and publication fulfillment.
Creates, maintains and runs ad-hoc queries/reports from AMS and Data Analytics Warehouse as requested by staff and Member Associations.
Trains staff in how to access and use the Data Analytics Warehouse.
Performs regularized monthly procedures including batch processes for month-end financial closing, publication runs, membership renewals and rebate reconciliations.
Monitors and resolves database issues reported by staff in help desk ticketing system.
Performs upload of member data files and subscribers’ files on vendor’s ftp site.
Other duties as assigned.
College degree in Computer Science, Information Technology, or related area.
Ability to manage multiple projects and meet deadlines.
1-3 years of AMS database experience preferred.
1-3 years of experience in Power BI. Must be able to create reports and create environments where multiple data sources are merged together for information extraction.
Proficiency in programming and creating queries in SQL.
Advanced proficiency with MS-Access, MS-Excel, MS-Word, PowerPoint.
Strong ability to interface with staff and develop solutions based on their requests.
Strong mathematical and analytical skills.
Strong communication skills, written and verbal.
Please submit resume with cover letter and salary requirements to WEFrecruitment@wef.org
WEF is an equal opportunity employer
About Water Environment Federation
The Water Environment Federation is a not-for-profit association that provides technical education and training for thousands of water quality professionals who clean water and return it safely to the environment. WEF members have proudly protected public health, served their local communities, and supported clean water worldwide since 1928.