Solutions Architect

Solutions Architect

Consistent with the Christian mission and vision of the YMCA of Middle Tennessee, the Solutions Architect provides technical and consultative leadership to help the YMCA select, design, integrate, and improve technology solutions. This position serves as a key liaison between business stakeholders, Information Technology, software vendors, consultants, and implementation partners. The Solutions Architect works with departments to understand business needs, translate those needs into technical requirements, and ensure technology solutions work effectively together across the organization.

Responsibilities

• Model the YMCA core values of Caring, Honesty, Respect, and Responsibility.
• Partner with departments to understand business processes, challenges, and technology needs.
• Serve as a liaison between business stakeholders, Information Technology, software vendors, consultants, and implementation partners.
• Translate business needs into clear functional and technical requirements.
• Translate complex technical information and vendor recommendations into practical language for nontechnical stakeholders.
• Evaluate technology solutions and vendor recommendations for organizational fit, integration capabilities, security, data accessibility, scalability, and long-term sustainability.
• Design, develop, and support reliable integrations between cloud-based and on-premises systems using RESTful APIs, ETL processes, web services, connectors, and structured data formats.
• Identify opportunities to simplify processes, automate repetitive work, and reduce duplicate data entry.
• Design, build, maintain, or support workflow automations and integrations.
• Develop, optimize, and support Microsoft SQL Server databases, T-SQL queries, data transformations, and related reporting and analytics solutions.
• Identify practical opportunities to use artificial intelligence and emerging technologies to improve YMCA operations and employee experiences.
• Develop or modify scripts, queries, integrations, automations, or lightweight applications when appropriate.
• Troubleshoot complex issues involving applications, SQL Server databases, APIs, integrations, data synchronization, vendors, and automation.
• Participate in software selection, requirements gathering, vendor demonstrations, solution design, implementation, testing, and post-implementation reviews.
• Maintain documentation of systems, integrations, data flows, technical decisions, and vendor responsibilities.
• Perform other duties as assigned.

Requirements

<> Required Skills

• Passion, enthusiasm, and commitment to the mission and cause of the YMCA.
• Bachelor's degree in computer science, information systems, technology, or a related field, or an equivalent combination of education and relevant experience.
• Experience working with multiple enterprise software platforms, cloud-based applications, and software vendors or implementation partners.
• Ability to gather business requirements and translate them into practical technical and data solutions.
• Strong communication skills with the ability to work effectively with technical and nontechnical stakeholders.
• Strong analytical, troubleshooting, documentation, and organizational skills.
• Minimum 3–5 years of hands-on development experience (backend web development in a production business environment.
• Demonstrated proficiency in T-SQL query development, including complex joins, subqueries, Common Table Expressions (CTEs), views, stored procedures, functions, triggers, and transaction management.
• Experience designing, developing, optimizing, and troubleshooting SQL queries, including performance tuning, indexing strategies, query execution plans, and database optimization.
• Experience with database administration and maintenance, including backups, recovery processes, index maintenance, statistics management, data integrity validation, and database health monitoring.
• Proven experience designing and supporting data integrations between cloud-based software platforms and on-premises systems.
• Strong understanding of ETL design principles, including data mapping, transformation logic, scheduling, exception handling, reconciliation, and operational monitoring.
• Experience consuming, developing, and troubleshooting RESTful APIs, including API keys, OAuth, OAuth2, JWT, and other token-based authentication methods.
• Ability to work with and transform data in JSON, XML, CSV, and other structured data formats commonly used in system integrations.

<> Preferred Skills

• Experience with artificial intelligence, generative AI, or AI agents.
• Experience with Microsoft Azure, Microsoft 365, Power Platform, Power Automate, Power BI, or Microsoft Copilot.
• Experience with REST APIs, JSON, webhooks, Python, JavaScript, PowerShell, C#, or similar technologies.
• Experience with integrating enterprise systems such as human resources, finance, membership, customer relationship management, or learning platforms.
• Experience with cloud data platforms, identity management, or single sign-on.
• Experience in a nonprofit, YMCA, or multi-location organization.

This position may require elevated security permissions to systems containing sensitive or confidential information. All system activity is subject to periodic system audits. The position is expected to protect confidential organizational, employee, system, security, and vendor information. Failure to comply with security or confidentiality requirements may result in disciplinary action, up to and including termination.

While performing the duties of this job, the employee may be required to stand, walk, sit, reach, climb stairs, stoop, kneel, talk, or hear. The employee must be able to lift up to 25 pounds.

This description is a summary of the functions of this position. Other duties may be assigned as needed. The YMCA of Middle Tennessee reserves the right to review and adjust this job description as business needs dictate.