Specialist, Data Management (Database Integration)

The Database Integration Specialist supports the development, maintenance, and optimization of APTA's data infrastructure through CRM integrations, SQL database operations and reporting solutions. This role is well-suited for a mid-level professional who enjoys working closely with business partners, learning complex systems over time, and contributing to a mission-driven association environment.

The Specialist applies hands-on technical skills to ensure data accuracy, accessibility, and performance across systems, enabling efficient operations and informed decision-making. This role plays a key part in SQL database administration, CRM platform configuration, and maintaining secure, high-performance data systems. The Specialist collaborates regularly with internal teams and external vendors, requiring strong communication skills, curiosity, and a willingness to continuously learn and adapt.

Essential Functions

• Collaborates with developers to troubleshoot and test custom applications, web services, and integrations
• Develops and maintains automated data sharing solutions for external organizations via SFTP
• Supports CRM integrations and utilities such as blast email and volunteer manager platforms
• Monitors SQL database performance, agent jobs, backups, and recovery processes
• Writes SQL scripts and stored procedures to support business needs including list pulls, surveys, and reporting data sources
• Creates formatted reports and dashboards using SSRS and Power BI
• Configures CRM components including forms, views, and workflows using Dynamics automation tools
• Performs bulk data imports and exports using SQL and Dynamics tools
• Troubleshoots CRM-related issues and supports internal users with varying technical skills
• Works to achieve a collaborative, service-oriented approach when working with colleagues

Staff Expectations

• Upholds and fosters APTA staff values
• Complies with all APTA policies and procedures
• Performs other duties as needed to foster achievement of the unit, department, team, and association priorities.

• Bachelor's degree required in Information Systems, Data Management, Computer Science, or related field. Experience working in an association, nonprofit, or member-based organization strongly preferred
• 3-5 years of professional experience in information systems, data management, analytics, or related field
• Proficiency in Microsoft Office 365 (Word, Excel, PowerPoint, Outlook, Teams, SharePoint)
• Experience writing SQL queries and stored procedures
• Experience with reporting tools such as SSRS and/or Power BI
• Familiarity with CRM platforms such as Microsoft Dynamics, Salesforce, or Protech
• Experience with SFTP and data transfer protocols
• Strong interpersonal and professional communication skills, with the ability to explain technical concepts to non-technical audiences (written, presentation and verbal)
• Demonstrated ability to collaborate across departments and with external partners
• Curiosity and a commitment to continual learning
• Strong organizational skills and ability to manage multiple projects and tasks
• Project management experience a plus

About APTA Do you want to contribute to an organization dedicated to improving societal health? Would you like to collaborate with colleagues who are passionate about making a difference? Are you excited to work in a new state-of-the-art building designed to encourage movement, participation, and employee health? Then you want to work for APTA! APTA is the trusted leader for the physical therapy profession, representing more than 100,000 physical therapists, physical therapist assistants, and physical therapy students. Our approximately 150 employees support the association's mission to build a community that advances the profession of physical therapy to improve the health of society. Learn more in our Association Profile. Located in Alexandria, Virginia, APTA has outstanding employee benefits, including flexible work schedules, generous retirement contributions, and travel subsidies for employees who choose public and active transportation.