The American College of Sports Medicine (ACSM) is searching for someone to fill this newly created position, Application Manager.

The Application Manager will be responsible for serving as the organization’s primary resource for the association management system (iMIS) and will regularly liaise with staff and third-party vendors to ensure needed reporting, functionality, and processes are in place to support ACSM operations. The Application Manager will interact with staff at all levels and must have the interpersonal skills required to effectively understand business needs and translate those to data delivery in a timely manner to staff. This position will report to the CIO/COO but does not have any supervisory responsibility. This position will serve as the main point of contact to all organization departments for current and future association management-platform related discussions, data extraction, integrations and system set up.

The Application Manager will adopt a servant leader approach in their work and is committed to being an active part of a productive, efficient, and empowered team. The Application Manager will have a sincere commitment to the mission and members of ACSM. 

POSITION RESPONSIBILITIES:

• Ensures the association management system (iMIS) supports ACSM membership, certification, education and the learning management system and event registration; join and renew/invoicing processes, member onboarding/off boarding processes, and other personalized communications.
• Manages the AMS data to ensure the accuracy of member and prospect records and reports while maintaining overall data integrity, including compliance with applicable data privacy requirements.
• Facilitates query development by gathering end-user requirements and creating advanced queries and reports.
• Extends the database by adding fields/tables, create/execute SQL statements to insert/extract data, create custom views/reports for end-users.
• Assists in extraction of data from the AMS to produce email communications, surveys, and mailing lists.
• Assists in maintenance and monitoring data integrity and consistency to ensure that data is “clean”, duplications are eliminated, addresses are valid, zip+4 is correct, email addresses are legitimate, and data adheres to standards.
• Collaborates with internal staff and 3^rd party vendors on the member/customer web experience including helping configure web pages within the AMS.
• Identifies areas of needed business process improvement and works with appropriate certification, membership, education, marketing, and other staff to implement changes.Works with certification and membership staff to develop ways to increase collection of member demographic information and with the marketing team to leverage data for segmenting and analysis 
• Understands and manages integrations between third-party systems and the AMS.
• Develops and manages database SOPs (i.e., data entry, IQAs, automation module, etc.)
• Conducts training to ensure staff know how to use the database for reports, rosters, financial information, marketing, and other basic operations.
• Serves as troubleshooter for staff as needed; triage technology support queries as needed.
• Perform related duties within the department as assigned or necessary.
• Maintain a rigorous focus on meeting member needs and creating a valuable member experience.

MINIMUM KNOWLEDGE AND SKILL REQUIREMENTS:

Knowledge:

• Create and customize reports for internal business stakeholders

• Highly capable of analysis and problem solving
• Proficiency with reporting software (e.g. SSRS, Crystal Reports, Power BI), Transact SQL, Microsoft Office as well as other software and technology tools.

Skills:

• Excellent written, oral and interpersonal communication skills with ability to communicate and interact effectively with a variety of persons and institutions.
• Ability to work independently and set and manage priorities.
• Possess a positive, enthusiastic attitude and a strong desire to innovate and learn new technologies and techniques.
• Must possess excellent customer service skills, attention to detail, be dependable and hold customer discussions in a professional manner.
• Desire and ability to operate as a team player both on core team and across the organization.

• Organized, detail oriented, ability to work in a fast-paced environment and adapt to changes.
• Problem solving and analytical skills which can be used to take initiative, provide superior customer service, and meet objectives of the department and the organization.

EXPERIENCE AND EDUCATION:

• Bachelor’s in Information Technology or a related area of study required.

• 2+ years’ experience with various reporting and querying tools. Creation and customization experience required.
• 2+ years’ experience writing advanced queries and reports using SQL or Microsoft SQL Server Reporting Services required.
• Experience with Association Management Systems (AMS) iMIS or a CRM equivalent preferred.

• Previous association or non-profit experience preferred.
• Previous experience with formal requirements gathering preferred.

ADDITIONAL REQUIREMENTS:

• Attends ACSM meetings as required
• Maintains current license, certification, or registration as applicable
• Follows dress code policy
• Adheres to Attendance/Scheduling policies
• Demonstrates flexibility in participating in staffing needs
• Understands and adheres to the ACSM Mission

LICENSES/CERTIFICATIONS:

N/A

WORK ENVIRONMENT, REQUIREMENTS, AND CONDITIONS:

The work environment characteristics and physical demands described here are representative of those that must be met by an Application Manager to successfully perform the essential functions of the job.  The College will make reasonable accommodations to the known physical or mental limitations of any otherwise qualified applicant or employee with a disability unless the accommodation will result in undue hardship to the College.

The Application Manager’s typical work week may include more than the standard 40 hours, work from home can be expected, and travel will be required.  The position requires a considerable amount of face to face with the public and professional contact.  The noise level in the work environment is usually quiet to moderate.  While performing the duties and responsibilities of this job, the Application Manager is frequently required to stand, walk/sit; use hands to finger, handle, or feel; reach with hands and arms; read, write, talk and hear.  The Application Manager is occasionally required to climb or balance; and stoop, kneel, crouch or crawl.  The Application Manager must frequently lift and/or move up to 15 pounds.  Vision abilities required by this job include close vision, and ability to adjust focus.

This description is intended to describe the essential job functions, the general supplemental functions, and the essential requirements for the performance of this job. It is not an exhaustive list of all duties, responsibilities, and requirements of a person so classified. Other functions may be assigned, and management retains the right to add or change the duties at any time.

ACSM is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.