Posted Feb 13
American Association for Cancer Research

Coordinator, Database Management

Philadelphia, PA, United States Full Time

Job Category: Full-Time /Exempt

Department: Membership

Reports To: Director of Membership
Senior Manager, Database Operations

Organizational Profile:

The American Association for Cancer Research (AACR), with more than 37,000 members residing in 108 countries, is the first and largest organization in the world dedicated to advances in all areas of high-quality, innovative cancer research. Its mission is to prevent and cure all cancers. The programs and activities of the AACR foster the exchange of new knowledge among scientists and physicians in the cancer field as well as in related biomedical sciences. AACR publishes eight peer-reviewed scientific journals and an award-winning magazine for cancer patients and their loved ones; convenes topical scientific conferences and an annual meeting that draws more than 19,400 participants; offers educational workshops that train young investigators in a variety of scientific and clinical areas; funds fellowships, career development awards, and research grants for both senior and junior investigators; raises public awareness of the progress in and reasons for hope in the biology, detection, diagnosis, treatment, and prevention of cancer; engages actively in advocacy for increased federal research funding and other national policies that accelerate progress against cancer; and interacts with regulatory agencies to support regulatory science and policy.

Job Summary:

The Coordinator, Database Management, provides technical, procedural, statistical and instructional support to staff, and serves as a technical liaison for the association’s medical research membership base. The Coordinator also assists with the maintenance, development, and administration of membership data, utilizing technical and customer service skills, via the member system of record and integrated systems.

Major Duties and Responsibilities:

  • Administers ELT processing for systems that integrate with the association’s system of record.
    •Performs testing of system releases and system upgrades, assists with the operation of contact and correspondence E-Systems and integration systems, and develops related documentation.
    •Active involvement in the training of association staff, by developing materials and hosting product information sessions geared to various levels, increasing knowledge and use of database tools, and fielding access and usage questions from association colleagues and customers.
    •Supports management by liaising with other association departments to meet business needs, provide information, and troubleshoot conference, event and profile issues. In addition, assist with dues and billing concerns, and seasonal special requests.
    •Generates reports and statistics that are used to develop strategic campaigns and collaborative events for the association.
    •Developing training materials for staff of specific departments and conducting training at various levels to address the business requirements and ensure the database meets the identified needs.
    •Review, develop and process data query requests, using association software, SQL, Access, Excel and other tools.
    •Alternate liaison for members contacting the association via the member website, the main functional gateway to membership benefits, and membership and customer service.
    •Performs other essential tasks and duties required of this position in order to support the Director as needed.

  • Job Qualifications:

  • Advanced proficiency working with Microsoft Excel, (VBA, pivot tables, formulas, macros, etc.).
    •Advanced proficiency working with Microsoft Access, (queries, VBA, reports, macros, etc.).
    •Advanced knowledge of Microsoft Office Suite (Word, Visio, PowerPoint).
    •3-5 years of SQL experience and a proven aptitude for analysis of data and creation of queries.
    •Highly organized, with superior problem resolution and analytical skills.
    •2+ years’ experience with release testing, including system and UAT.
    •Knowledge of iMIS or association software a plus.
    •Ability to articulate requests and describe analysis results in a simple and clear language.
    •Ability to prepare standard operating procedures (SOPs) on acquired knowledge for tasks and processes.
    •Excellent written and verbal communication skills.
    •Ability to follow instructions.
    •Strong customer service and interpersonal skills.
    •Experience with web-based applications.
    •High level of accuracy in the performance of tasks and functions.
    •The ability to adapt to change and balance competing demands.
    •Ability to manage and prioritize multiple projects simultaneously and adapt to rapidly changing schedules, priorities and workflows.
    •Ability to productively and effectively function while unsupervised, and as part of a team.

  • Skillsets:

  • Strong understanding of relational databases, including database structure.
    •Advanced knowledge of Access and Excel.
    •Association software experience a plus.
    •VBA and Power BI experience a plus.
    •Knowledge of ETL processing.
    •Strong proficiency in creating trending reports and dashboards.

  • Education and Training:

  • Bachelor’s degree.

  • How To Apply:

    Please submit your cover letter and resume (including salary history) to:
    Human Resources
    P.O. Box 40138
    Philadelphia, PA 19106
    Fax: (215) 440-1045

    Equal Opportunity Employer

    Sign up for Job Alerts

    Latest Jobs

    Share this Job

    More from American Association for Cancer Research

    Similar Jobs