Solutions Architect

Quick Facts

• Role: Solutions Architect

• Focus: Technology solution design, integration, and improvement across enterprise systems

Description

The Solutions Architect provides technical and consultative leadership to help the organization select, design, integrate, and improve technology solutions. This role bridges business stakeholders and Information Technology to translate business needs into functional and technical requirements and ensure systems work effectively together. You will also design integrations, build and optimize SQL Server/data solutions, evaluate vendors, and troubleshoot complex issues across applications and data flows.

Responsibilities

• Partner with departments to understand business processes, challenges, and technology needs

• Act as liaison between business stakeholders, IT, software vendors, consultants, and implementation partners

• Translate business needs into functional and technical requirements

• Communicate complex technical information and vendor recommendations in plain language for nontechnical stakeholders

• Evaluate solutions for organizational fit, integration capabilities, security, data accessibility, scalability, and long-term sustainability

• Design and support integrations between cloud 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 reporting/analytics solutions

• Identify practical opportunities to apply artificial intelligence and emerging technologies to improve operations and employee experiences

• Develop/modify scripts, queries, integrations, automations, or lightweight applications when appropriate

• Troubleshoot complex issues involving applications, SQL Server, 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

Requirements

• Passion, enthusiasm, and commitment to the YMCA mission and cause

• Bachelor's degree in computer science, information systems, technology, or related field, or equivalent combination of education and relevant experience

• Experience working with multiple enterprise software platforms, cloud-based applications, and software vendors/implementation partners

• Ability to gather business requirements and translate them into practical technical and data solutions

• Strong communication skills with technical and nontechnical stakeholders

• Strong analytical, troubleshooting, documentation, and organizational skills

• Minimum 3–5 years of hands-on development experience in backend web development in a production business environment

• Demonstrated proficiency in T-SQL (joins, subqueries, CTEs, views, stored procedures, functions, triggers, transaction management)

• Experience designing, developing, optimizing, and troubleshooting SQL queries (performance tuning, indexing, execution plans, database optimization)

• Database administration and maintenance experience (backups, recovery, index maintenance, statistics management, data integrity validation, health monitoring)

• Proven experience designing/supporting data integrations between cloud software and on-premises systems

• Strong ETL design principles (mapping, transformations, scheduling, exception handling, reconciliation, operational monitoring)

• Experience consuming/developing/troubleshooting RESTful APIs with token-based authentication (API keys, OAuth, OAuth2, JWT)

• Ability to work with structured data formats (JSON, XML, CSV, etc.)

Benefits

Not specified in the provided posting.