Small 50-60 close knit staff, 9000 member specialty association. Average staff tenure is 10 years. Great benefits & working environment.
Office open with most staff currently working 3 days per week in the office and 2 days per week working remotely. This is not a fully remote position. Must be able to reliable commute to the office 3 days per week.
POSITION: Data Analyst
STATUS: Exempt
REPORTS TO: CFO/Associate Executive Director, Operations and Business
OVERVIEW:
The Data Analyst reports to the CFO/Associate Executive Director, Operations & Business and is responsible for supporting the organization’s Association Management System (Personify) and reporting systems. The Data Analyst will develop reports according to business requirements as requested by business units using Crystal Reports and SAP Business Objects.
The Data Analyst will research, analyze, and create simple to complex SQL queries and stored procedures to extract information from the Personify SQL Server database. The Data Analyst will also use Personify developer resources to modify screens and implement simple functionality changes within the AMS including adding fields and modifying views.
Furthermore, the Data Analyst serves as a liaison with Personify support placing support tickets, facilitating answers and deployment of fixes to the database. The Data Analyst will also facilitate integrations between the AMS and external systems.
Finally, the Data Analyst will research, develop, and maintain complex analytics reporting/dashboards (using technologies such as Microsoft Power BI and integrating data from various sources in addition to the AMS), for the Senior Management Team to use for data-driven decision-making.
KEY ACCOUNTABILITIES:
Create and modify queries and reports utilizing SQL Server/TSQL, Crystal Reports, and SAP Business Objects. Work directly with departments on requirements for operational reports and data files.
Build and maintain analytical reporting/dashboards.
Perform extraction, transformation, and loading of data from disparate sources and ensure its integrity.
Develop and maintain email notifications including underlying complex data selection stored procedures and html coding.
Assist with database and application upgrades including acceptance testing and implementing new database functionality.
Facilitate integrations between the AMS and external systems.
Develop scripts proactively to monitor and report data integrity.
Using Personify’s development tools, provide user interface and simple functionality enhancements.
Administer configuration of Personify’s public facing eBusiness environment, currently DNN, code provided content in HTML as needed, and troubleshoot issues.
Modify Business Object Universes within AMS to enable other staff to pull reliable data using Business Objects.
Create documentation on processes and procedures used in performance of assigned duties.
Serve as liaison with Personify support.
Perform other similar or related duties as requested or assigned by the CFO/Associate Executive Director, Operations and Business.
QUALIFICATIONS:
Bachelor’s degree with concentration in IT or two to three years related experience and/or training
Working knowledge and experience with SQL Server databases and TSQL queries, triggers, and procedures
Advanced proficiency with Microsoft Excel
Proficiency with Crystal Reports and SAP Business Objects
Proficiency with Microsoft Power BI or similar data analytics software
Experience working with Association Management Systems preferred (preferably Personify)
About American Assn of Oral & Maxillofacial Surgeons
Established in 1918, the American Association of Oral and Maxillofacial Surgeons (AAOMS), the professional organization representing more than 9,000 oral and maxillofacial surgeons in the United States, supports its members' ability to practice their specialty through education, research, and advocacy. AAOMS members comply with rigorous continuing education requirements and submit to periodic office examinations, ensuring the public that all office procedures and personnel meet stringent national standards.
