Specialist, Data Management (Database Integration)
About The Position
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.
Requirements
- Bachelor’s degree required in Information Systems, Data Management, Computer Science, or related field.
- 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
Nice To Haves
- Experience working in an association, nonprofit, or member-based organization strongly preferred
- Project management experience a plus
Responsibilities
- 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
Benefits
- flexible work schedules
- generous retirement contributions
- travel subsidies for employees who choose public and active transportation
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
