Solutions Architect
About the role
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. The ideal candidate has broad experience with cloud-based software, system integrations, data and databases, and automation. Experience with artificial intelligence and working knowledge of programming or scripting are strongly preferred.
Responsibilities
- Develop and optimize complex automated solutions
- Design and support reliable integrations between cloud-based and on-premises systems
- Troubleshoot API, database, and data synchronization issues
- Maintain high levels of data accuracy, security, availability, and performance
- Work directly with business stakeholders and software vendors to implement and support enterprise data solutions
Requirements
- 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 Qualifications
- 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