Job Description
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.
Qualifications
- 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 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.
- The ideal candidate will be able to independently:
- 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.
- 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.
Essential Functions
- 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.
Cause-Driven Leadership Competencies
Communication & Influence Collaboration Critical Thinking & Decision Making Innovation Required Certifications
- Before start of 1st shift: New Hire Orientation training
- Within six months of hire: Complete course training and Certify in Adult Mental Health First Aid USA from the National Council for Mental Wellbeing
