Reference Code: DA-1112
The American Academy of Physical Medicine and Rehabilitation (AAPM&R), a national medical society representing over 8,000 physicians has an immediate opening for a Database Analyst.
This position is responsible for maintaining the integrity of the Academy’s database enterprise environment, including but not limited to iMIS, integrated marketing management software, learning management system (LMS), and Sharepoint, writing/revising reports necessary for data extraction, testing new online initiatives prior to implementation, and ensuring smooth iMIS interface with the Web site and other online initiatives. Position serves as primary staff resource for data management and report generation. Position will also serve in a supporting role by coordinating and executing critical components of the E-commerce and Online Experience business requirements.
Essential Duties and Responsibilities:
- Monitor staff and online changes to data records on a regular basis to ensure compliance with data-entry procedures and preserve data integrity. Provide staff with training on data-entry and/or procedures if needed.
- Write and maintain documentation on all customizations and the database as it currently exists.
- Serves as the primary staff resource for identification of requirements, developing, pulling, and furnishing/uploading data lists or reports to staff and vendors as needed. Ensures the accuracy of all reports and queries. Utilizes appropriate reporting software (SQL Server Reporting Services or Crystal reports) to write and revise custom reports as necessary.
- Serves as primary resource to project managers on all online initiatives relating to any Academy database where information may be accessed or extracted (including but not limited to iMIS). Provides support in the development, testing, and implementation of web services and stored procedures dependant on integration with membership database.
- Work with Systems Administrator to provide recommendations for organizing, storing, modifying, and extracting information to improve and maintain existing data and database.
- Serve as the Academy’s data content and application contact with our iMIS provider and consultant, collaborating with the Academy’s primary technical contact (System Administrator).
- Database responsibilities to include developing and implement guidelines and procedures governing enterprise-wide data collection; develop and implement data naming conventions and documentation; develop and implement specialized training for effective use of data and reporting resources; develop standards for handling ad hoc reporting and ensure compliance throughout user community; optimizes the data environment in order to efficiently access enterprise data; address and execute data security requirements.
- Monitors and executes necessary updates and troubleshooting linked to the Academy’s marketing management software.
- Coordinates ongoing content updates of the AAPM&R Web sites (www.aapmr.org, www.phyzforum.org, and more) from multiple sources. Also supports content updates to the Foundation for PM&R Web site (www.foundationforpmr.org). Works with Webmaster and other appropriate staff to maintain content and infrastructure standards of the Academy Web sites. This includes managing content submitted within a content management system. Document and update procedures/processes, maintain and enforce standards for publishing content on the Web sites. Pull Web site usage reports, hits statistics, and other analysis reports as needed.
- Coordinates content creation and database and application updates related to the Academy’s learning management system (LMS), Isoph Blue and public facing web site (www.me.aapmr.org). Prepare content by setting up, configuring, testing and approval of the courses and events in the LMS before making available to end users. Create online assessments and surveys using the appropriate LMS tools. Coordinate web site updates, along with sales catalogs and inventory management with the education department team. Test, document and troubleshoot errors or issues that occur within or from the LMS that affect a user’s online experience. Assist as needed with LMS reports to supply information on course usage and completion.
- Assists in the maintenance and development of e-commerce and iMIS/Web interfaces, with specialized emphasis on Sharepoint Web environment. Works closely with web and technology staff to provide troubleshooting assistance on live Web services such as web logins, physician locator feature, online membership directory, CME claims, meeting registrations, etc. Perform functional testing and quality assurance (QA) checks on new web-based products, upgrades and data-driven applications. Works with Academy staff and vendors on Web hosting, updates, upgrades, and testing.
- Understands customer experience issues, provides issue resolution services to members, nonmembers and staff experiencing Web site related difficulties.
- Provides backup or secondary assistance with the Academy’s electronic distribution of information to members and other external audiences, as needed.
Required Knowledge, Skills and Abilities:
- Experience in Sharepoint / MOSS, data warehousing, data mining and SQL Reporting Services 2008 is a big plus
- Preferred three years experience with iMIS or similar CRM application
- Three years experience with SQL Server Database in a production environment (SQL 2000, 2005, 2008)
- Three years of understanding and implementation of schemas, and the ability to interpret and write complex Structured Query Language (SQL) queries, views, functions, and stored procedures
- Three or more experience with Crystal Report Writing (must include version 8.5)
- Experience in data extract/linking through ODBC using Access and Excel. Understanding of relational data structures; Strong knowledge of spreadsheet and reporting software to enable providing output from a variety of data sources
- SQL Web integration experience
- .NET and Coldfusion coding experience is highly desirable
- Experience with HTML and content management systems desired
- Demonstrated experience developing technical guidelines and written procedures
- Demonstrated experience providing technical assistance to staff
- Strong analytical, project management and problem solving skills with an eye for detail required.
- Strong project management skills with ability to prioritize and manage multiple tasks
- Ability to be self-taught; highly motivated to learn new skills
- Good communication and interpersonal skills with ability to effectively collaborate within and across departments in order to achieve both departmental and organizational goals.
- Maintains high professional standards of integrity, ethics, and commitment to the goals of AAPM&R.
Education and Experience:
- Bachelor’s Degree in computer science or relevant field
- Three or more years of working experience.
Estimated Travel:
Less than 5%
AAPM&R offers an excellent work environment, competitive salary, and a very comprehensive benefits package. Additionally, we are an Equal Opportunity Employer (EOE).
For consideration, please note this position's reference code and visit our "How To Apply" page.