Senior Technical Systems & Integration Analyst

CFP Board of Standards Inc.; Washington (District of Columbia); Hybrid; USD 125,000 - 150,000; Full time

Job summary

CFP Board of Standards Inc. in Washington, D.C. is seeking a Sr.

Technical Systems Analyst to serve as a technical expert supporting the enterprise AMS, NetForum and related integrations. You will develop SQL queries, troubleshoot multi-system issues, and assist with authentication services and data workflows. The role requires strong SQL, API, and iPaaS skills, with experience in NetForum, Workato, and CRM tools.

Qualifications

• BA/BS required. Major in Information Technology, Computer Science, Information Systems, mathematics, statistics, accounting, or other degree emphasizing business analysis, technology or quantitative problem-solving preferred
• 7+ years' experience with Microsoft SQL Server writing SQL queries, stored procedures, and other scripts for analysis, reporting, troubleshooting and data validation
• Experience supporting or troubleshooting APIs, or other integration technologies, e.g., iPaaS (Workato preferred)
• Experience with Association Management System (AMS) (NetForum preferred) and/or Customer Relationship Management (CRM) (Salesforce preferred)
• Familiarity with application integrations, enterprise architecture concepts, and data flows across interconnected business systems.
• Excellent critical thinking, with a proactive approach to identifying issues and presenting solutions and options
• Ability to manage multiple priorities, adapt to changing business needs and meet deadlines in a fast-paced environment
• Ability to work independently and collaboratively with cross-functional teams
• Excellent interpersonal and communication skills (both verbal and written)
• Must be available for system maintenance, system outages or emergencies outside of business hours

Responsibilities

• Provides day-to-day support for business applications, including investigation, troubleshooting, resolution, and escalation of application support tickets and production issues
• Analyzes, troubleshoots, and resolves advanced application, integration, authentication, and data issues across multiple platforms, vendors, and environments
• Supports, maintains, and troubleshoots integrations between primary AMS platform (NetForum) and other internal and external systems utilizing Workato iPaaS, APIs, web services, and other modern integration technologies and protocols
• Develops and maintains SQL queries, database scripts, stored procedures, reports, and other technical solutions to support project deliverables and other operational, analytical, and troubleshooting needs
• Supports and troubleshoots authentication solutions using Auth0 Single Sign-On (SSO)
• Proactively identifies opportunities for system and process improvement, and recommends technical solutions to enhance the reliability, efficiency, and scalability of business-critical systems
• Partners with business users to understand requirements, identify root causes of issues, and recommend technical solutions and process improvements
• Collaborates with internal teams and third-party vendors to investigate incidents and software bugs, coordinate issue resolution, and recommend system enhancements
• Assists with the development of test plans, test cases, and testing strategies for enhancements, upgrades, and integrations
• Supports unit testing, system testing, integration testing, and User Acceptance Testing (UAT) activities for NetForum and related business applications, across multiple projects
• Validates system enhancements and defect fixes to ensure solutions meet business requirements and do not negatively impact existing functionality
• Supports application configuration, deployment, release management, and post-production validation activities for AMS
• Maintains technical documentation including system configurations, integration specifications, support procedures, data mappings, and troubleshooting guides
• Provides technical guidance and support to business users regarding application functionality, reporting, data issues, and system capabilities
• Supports change management processes and ensures adherence to organizational standards, security requirements, and best practices
• Performs configuration of AMS and assists staff in changes to and testing of AMS configuration

Skills

SQL development

API integrations

Troubleshooting

Cross-functional collaboration

Education

BA/BS in IT/CS/IS

Tools

NetForum AMS

Workato

Salesforce

Auth0 SSO

Job description

CFP Board of Standards Inc. in Washington, D.C. is seeking a Sr.

Technical Systems Analyst to serve as a technical expert supporting the enterprise AMS, NetForum and related integrations. You will develop SQL queries, troubleshoot multi-system issues, and assist with authentication services and data workflows. The role requires strong SQL, API, and iPaaS skills, with experience in NetForum, Workato, and CRM tools.