The Opportunity

With a goal of expanding NCTE’s data-driven focus, the Data and AMS Integration Specialist will directly impact NCTE’s data-driven insights and actions. This position will lead data governance, reporting, and analysis needs while also rapidly creating new insights through data for the organization. This role will be responsible for the life cycle of product knowledge, transactions, and demographics data in NCTE’s Association Management Software (AMS), collaborating with NCTE’s Director of IT, Senior Director of Operations, and others, when needed. This role will lead efforts to address and prevent errors that impact database transactions, the user experience related to the AMS, or reporting accuracy. The Data and AMS Integration Specialist will be expected to lead efforts in forming data governance standards in the current AMS (Aptify) and migrating those standards to any future AMS platforms. This role will serve as the central source for reporting membership, journals, and publication trends from database transactions, ensuring department leaders are able to make data-driven strategic decisions to help grow the organization and reach a broader audience of literacy educators.

SPECIFIC RESPONSIBILITIES INCLUDE:  

Reporting & Data Governance

• Create useful data sets in a growing variety of analytics, apps, algorithms for core business objectives
• Imagine and create business rules including the creation, validation, and remediation of existing reports in the organization’s AMS (Aptify) to ensure recurring reporting, lists, and future utilization contains data with fidelity
• Ensure data privacy and security.
• Coordinate with the Marcomm team to provide lists on schedule with external communications
• Securely provide lists to a third-party when list rental requests are approved
• Maintain weekly membership and journal subscriber trend reports, while forming a plan to shift to dashboard reporting
• Provide monthly reports to key leaders, highlighting volume trends on membership, journals, and publications transactions, including influencing factors such as top sellers or campaign codes used
• Collaborate with the Digital Marketing Manager to accelerate the use and depth of insight from Google Analytics as related to a variety of transactional trends observed through the AMS

Database Administration

• Assist with the configuration and maintenance of NCTE’s AMS (Aptify)
• Create new products in Aptify, collaborating with the Finance team and product owners
• Troubleshoot errors in the system to ensure that external programming support is providing a clear understanding of the issue, minimizing external programming costs
• Provide management of SQL Server Agent, scheduling, and monitoring routine database jobs
• Recommend, document, and communicate data definitions, data-related business rules, data trends, and testing methods
• Thoroughly test any upgrades, migrations, new features, etc., with documented results and organized communication to staff and technical partners
• Assist with design and interconnectivity of web-database applications
• Coordinate data exchanges between NCTE and its partners through API integrations and data imports from various platforms
• Provide training and procedural documentation to staff and key contractors to ensure consistent use of the database, according to data governance standards

 ADDITIONAL EXPECTATIONS INCLUDE:

• Thirst for discovering new data points that lead to positive change in serving teachers and students
• Ability to create and implement data rules with a strong focus on enhancing the accuracy and access to data and reporting to inform strategic organizational programs and content
• Capacity to reject status quo and create new data-driven opportunities
• Commitment to continuous learning in the position through a variety of means
• Strong collaboration with all staff including the Director of IT, Senior Director of Operations, Digital Marketing Manager, Director of Marketing and Membership, and other colleagues is essential
• Clear communication with third-party technical partners, ensuring the effective use of IT budget
• Embraces innovation, monitoring emerging technologies in the software industry, and recommending enhancements to the IT Project Manager and Director of Operations
• Strong focus on enhancing the accuracy and access to data and reporting to inform strategic organizational programs and content
• Working outside of traditional work hours to support project deliverables and database activities may occur. To ensure balance, NCTE encourages use of its flextime policy.
• Domestic travel for in-person meetings may occur 2 to 4 times annually.

The Data and Integration Specialist will encompass the following qualifications:

• 3+ years’ experience in systems analysis and/or support
• Bachelor’s degree from an accredited college/university in Data Science, Data Analytics, Technology, Computer Science or Engineering
• Experience with Association Management Software platforms (Aptify preferred)
• Basic SQL experience