Solutions Architect

YMCA of Middle Tennessee

Tennessee

On-site

USD 102,000 - 127,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Generous paid time off
Free YMCA membership
Discounts on youth programs

Job summary

The YMCA of Middle Tennessee seeks a Solutions Architect to lead technical strategy, integrations, and data solutions across cloud and on‑prem environments. You will translate business needs into actionable technical requirements and collaborate with IT, vendors, and stakeholders to ensure reliable, scalable systems.

Ideal candidates have broad cloud, data, and automation experience, with strong SQL skills and familiarity with REST APIs.

Qualifications

  • Bachelor’s degree in computer science, information systems, technology, or a related field.
  • 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 with technical and nontechnical stakeholders.
  • Minimum 3–5 years of hands-on development in a production environment.
  • Proficiency in T-SQL and complex queries (joins, CTEs, views, stored procedures).
  • Experience designing, optimizing, and troubleshooting SQL queries and database performance.
  • Experience with data integrations between cloud-based and on-premises systems.
  • Understanding ETL design principles (mapping, transformations, scheduling, monitoring).
  • Experience consuming RESTful APIs with OAuth/JWT and token-based auth.
  • Ability to work with JSON, XML, CSV in data integrations.

Responsibilities

  • Model YMCA core values in daily work and decisions.
  • Partner with departments to understand processes, challenges, and tech needs.
  • Serve as liaison between stakeholders, IT, vendors, and partners.
  • Translate business needs into clear technical requirements.
  • Translate technical details into practical language for nontechnical audiences.
  • Evaluate tech solutions for fit, security, data access, and scalability.
  • Design and support reliable integrations between cloud and on-prem systems.
  • Identify opportunities to automate and reduce manual data entry.
  • Develop and optimize SQL Server databases and data reporting features.
  • Explore AI opportunities to improve operations and employee experience.
  • Create scripts, integrations, automations, or lightweight apps as needed.
  • Troubleshoot complex API, database, and data sync issues.

Skills

Cloud integration
RESTful APIs
SQL/T-SQL
Data integration
ETL design
AI / Generative AI
Vendor liaison

Education

Bachelor’s degree in CS / Information Systems / Tech

Tools

Microsoft Azure
Power BI
Power Automate
Microsoft Copilot

Job description

Position Summary:
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.

Job Responsibilities

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.
Qualifications

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.

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
Additional Information

Flexible hours and a wide range of job opportunities

  • Seasonal opportunities
  • Part-time or full-time job opportunities
  • Open seven days a week / More flexible work schedule
  • 12 wellness center locations
  • More than 140 school partner sites
  • Corporate Office
  • Benefits package including generous paid time off for full time staff
  • Participation in Y Retirement plan and 403 (b) savings account upon eligibility
  • Free membership at all 12 wellness center locations
  • Discounts on youth programs, summer camps and sports instruction

Career development
We are dedicated to helping our team members reach their professional goals and feel valued. We offer a comprehensive leadership development and certification system that promotes learning at all career stages.

We also provide Employee Resource Groups, which provide a space for people to network, mentor one another, participate in personal and professional development and more—all while building meaningful connections.

Committed to Being an Engaging Y
The YMCA seeks to foster a people-centered workforce where all individuals feel valued and supported in strengthening the communities we serve.

  • Salary Range: $101,621 to $127,026 annually (depending on experience)
  • Working Hours: Standard business/office hours Monday through Friday (with Weekends as needed)
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Executive Director, Robertson County YMCA
Executive Director, Robertson County YMCA

YMCA of Middle Tennessee • United States

On-site
USD 77,000 - 96,000
Flexible hours
Seasonal opportunities
Open seven days a week
+2
Senior Executive Director, Green Hills
Senior Executive Director, Green Hills

YMCA of Middle Tennessee • Tennessee Ridge (TN)

On-site
USD 90,000 - 150,000
Free gym membership
PTO and retirement plan
403(b) savings
Youth & Family Coordinator (East Communities)
Youth & Family Coordinator (East Communities)

Greater Austin YMCA • Austin (TX)

On-site
USD 23,000 - 29,000
Health Insurance
Retirement plan
Paid Time Off
+1
Health & Wellness Director (TownLake)
Health & Wellness Director (TownLake)

Greater Austin YMCA • Austin (TX)

On-site
USD 51,000 - 55,000
Health Insurance
Retirement Plan
Paid Time Off
+1
Health & Wellness Director (TownLake)
Health & Wellness Director (TownLake)

Austin YMCA • Austin (TX)

On-site
USD 51,000 - 55,000
Health Insurance
Retirement Savings Plan
Paid Time Off
+1
Youth & Family Coordinator (East Communities)
Youth & Family Coordinator (East Communities)

Austin YMCA • Austin (TX)

On-site
USD 23,000 - 29,000
Health Insurance
Retirement Savings Plan
Paid Time Off
+1
Youth & Family Coordinator (Southwest)
Youth & Family Coordinator (Southwest)

Greater Austin YMCA • Austin (TX)

On-site
USD 23,000 - 29,000
Health Insurance
Retirement Savings Plan
Paid Time Off
+1
Interim Human Resources Director
Interim Human Resources Director

YMCA of Snohomish County • Everett (WA)

Hybrid
USD 98,000 - 111,000
Benefits
AFTER SCHOOL LEAD
AFTER SCHOOL LEAD

Valparaiso Family YMCA • Valparaiso (IN)

On-site
USD 12,000 - 18,000
Free Y membership and discountedFamily
Child Watch hours available free of CH
Certification assistance
Sports Director
Sports Director

YMCA of McCook • Wilcox Trailer Court (NE)

On-site
USD 38,000 - 42,000
Free YMCA Membership
Discounted YMCA Programs
Retirement Plan
+3