Data and Systems Analyst

Own technical administration and support of GMS, including configuration, Salesforce synchronization, troubleshooting and resolution of system issues;

• Serve as the technical Salesforce subject matter expert for Sports & Local Programs, supporting configuration, system workflows, data integrity, troubleshooting and reporting tools;

• Lead technical data-quality controls across GMS and Salesforce, including duplicate detection, synchronization validation, cleanup standards and exception reporting

• Assist the Director, Volunteers, Sports and Local Programs with data entry and record maintenance related to background check tracking and compliance.

• Support organization-wide data integrity efforts, including deduplication support, data entry standards, and routine database cleanup in Salesforce.

• Serve as a backup Salesforce resource for Finance, including support for Omatic Cloud batch processes and related data review.

• Assist with data imports/exports and integration troubleshooting across Omatic Cloud, JotForm, GoFundMe Pro, HubSpot, and other connected systems.

• Design, build, automate and maintain Salesforce/GMS reports and dashboards based on business requirements supplied and validated by Sports & Local Programs and other departments; operational leaders retain responsibility for final interpretation and submission of program reports

• Document technical system procedures and train staff and volunteers on Salesforce and GMS functionality, data standards, synchronization, troubleshooting and changes to system workflows; coordinate operational training with the Sports Manager

• Serve as a backup Salesforce resource to the Senior Director, Business Systems on organization-wide data projects.

• Develop and assume technical ownership of Salesforce configuration, maintenance and troubleshooting for the Coach’s Portal and online registration, as proficiency grows; partner with the Sports Manager on operational requirements and user testing.

• Support UAT (user acceptance testing) of configuration changes and new automation, helping identify root causes of data or workflow issues before escalating.

SECONDARY DUTIES

• As Salesforce capabilities mature, extend data and reporting support beyond Sports & Local Programs to Development, Finance, and other departments.

• Attend committee, staff, and department meetings related to data systems and sports operations.

• Provide support as needed for competitions and events, with some evening and weekend work required.

• Is aware of and complies with SOCT’s policies, procedures, and non-discrimination policy.

• Maintains a positive work environment

• Any other duties that may be assigned by the Senior Director, Business Systems and/or President & CEO.

Bachelor’s degree preferred; equivalent, relevant Salesforce or CRM/database experience may substitute.

• Eagerness to learn Salesforce, GMS, Omatic Cloud, and Dataloader.io required; prior experience with any of these (most likely Salesforce/NPSP) a plus but not required.

• Familiarity with data visualization tools (e.g., Tableau)

• Proficient with Microsoft Office 365, Word, Excel, PowerPoint, Outlook and Teams; familiarity with project management tools such as Asana.[GU1]

• Familiarity with sports competition management (divisioning, event logistics, registration processes) preferred; experience with Special Olympics or a similar sports environment a plus.

• Strong Excel skills, including formulas (VLOOKUP, COUNTIF, FILTER), pivot tables, and data cleanup.

• Experience with data integrations, imports, or sports/event management systems is a plus.

• High attention to detail and a strong commitment to data accuracy and integrity.

• Excellent interpersonal, communication, and presentation skills, with the ability to train staff and volunteers of varying technical skill levels.

• Good organizational skills and ability to prioritize and manage multiple projects and stakeholders.

• Ability to work both independently and collaboratively to accomplish work objectives.

• Must have a valid Connecticut Driver’s License.

• 403(b)
• Dental insurance
• Disability insurance
• Health insurance
• Health savings account
• Life insurance
• Paid holidays
• Paid sick time
• Paid time off
• Vision insurance

Please note, Special Olympics Connecticut is relocating to its new headquarters in Bristol, CT in May of 2027. Currently, we are located in Hamden, CT until then. This position is hybrid and will require some in office days each week