Alexandria, VA
Washington, D.C.
Arlington, Virginia
Hybrid (Rockville, MD)
Washington, DC
Coachella Valley
Remote
Rockledge, Florida
Posted: 11-Sep-24
Location: Remote
Type: Full Time (Remote Only)
Categories:
Required Education:
If you’re interested in applying for ACLM’s iMIS Administrator position, please submit your cover letter and resume by email to Theresa Stephan, Director of Human Resources, at tstephan@lifestylemedicine.org. *Resumes submitted without a cover letter will not be considered.
ACLM is seeking a skilled iMIS Administrator to join our team. The ideal candidate will be responsible for the administration, performance, integrity, maintenance and security of our association management system (iMIS). We are a professional association of 11,500+ members and 40 staff. This role involves ensuring data integrity, optimizing database performance, supporting and facilitating integrations and providing technical support to internal staff and external users. The ideal candidate will have extensive experience with iMIS and a strong understanding of database management principles.
- Administers and supports the association management software (iMIS), emphasizing reliability, scalability, and security (iMIS EMS cloud, including RISE).
- Ensure compliance with data protection regulations and ACLM’s company policies.
- Conduct regular security audits and risk assessments.
- Configures and customizes the AMS to meet specific needs, including settings, fields, workflows, automation, analysis, reports, queries, dashboards, and other visualizations.
- Administers e-business functions between the AMS and the website, including supporting the integration of ACLM’s technology platforms:
- Email Marketing: Higher Logic Informz, Feathr
- Community: Higher Logic Community
- Learning Management System: D2L/Brightspace
- Application & Review Software: OpenWater
- SSO: from iMIS platforms above to website
- Data Lake: Association Analytics
- Job Board: SmartJobBoard
- Troubleshoots and corrects issues as they arise.
- Develop and deliver training materials and sessions for users.
- Develop and implement data management policies and procedures.
- Manage data import/export processes, if needed.
- Understands and analyzes business needs and abilities to enhance the AMS system’s efficiency and usage.
- Ensures accuracy and integrity of data by performing thorough audits, validations, and regular data checks and updates and fills in gaps for data hygiene and maintenance. Optimizes as needed to ensure efficient operations.
- Works with staff to identify user needs and develop processes for increased productivity and increased user experience.
- Maintain and enhance existing systems by analyzing business objectives, preparing an action plan, and identifying areas for modification and improvement.
- Analyze data trends and provide insights to support business decisions where applicable.
- Create custom reports using iMIS reporting tools to assist team members.
- Ensure timely delivery of projects within budget constraints.
- Bachelor’s degree or equivalent required.
- Microsoft Certification in SQL Database Administration is highly desirable
- 5+ years’ Microsoft SQL server administration experience.
- 3+ years’ experience managing iMIS or a similar AMS (Association Management System) and administration of MS SQL Server 2019/2022.
- Working knowledge of relational databases and advance knowledge/programming experience with SQL and Crystal Reports and Access; experience with SQL Reporting Services is highly desirable.
- Proven experience with Microsoft .NET technologies including: ASP.NET, ADO.NET.
- Languages: VB.Net, SQL/T-SQL, JavaScript/DHTML, VBScript, HTML, XML.
- Minimum 2-3 years in backend software design in SQL Server, Stored procedures, ASP.NET, VB.NET.
- Knowledge and understanding of the TCP/IP protocol, troubleshooting and support.
- Ability to manage multiple projects simultaneously.
- Ability to work collaboratively across multiple departments within the organization.
- Ability to perform tasks effectively with little supervision.