Senior Specialist, Sr. SQL Analyst, Case Management

Role Description

Goodwill Industries International manages a shared case management system for our network of members. This system is a SQL Server based architecture. The application has moved to the latest Azure medallion architecture. As our usage has grown, and the architecture more advanced, we have a need for senior SQL Server skills for optimizing our landscape of over 50 databases.

The Senior SQL Analyst is responsible for querying, validating, and analyzing data within the organization’s case management system. This role focuses on SQL-driven data extraction, data quality assurance, and analytical support for operational reporting, compliance, and strategic decision-making. Responsibilities include:

• Translate business requirements into technical solutions using MS SQL Server and custom internal programming.
• Accountable for report design, report optimization using SQL, SSRS, Fabric, and PowerBI for compliance reporting and business specific reports.
• Evaluate improvements in database design to facilitate complex report generation.
• Complete new implementations while identifying opportunities for simplification.
• Ensure data integrity and establish reporting confidence.
• Obtain strong product expertise and identify business improvements.
• Act as technology subject matter expert in system functionality, and business process subject matter expert.

Qualifications

• Advanced SQL (joins, aggregations, subqueries, CTEs)
• Data validation and reconciliation techniques
• Reporting and analytics support
• Microsoft Excel (advanced functions)
• Application and system administration
• Ability to prioritize user support requests
• Excellent communication and critical thinking skills
• High degree of organization, individual initiative, and personal accountability
• Experience with non-profit case management product or project development experience a plus
• Established background in testing software or services in partnership with mission leaders, program leaders, and grant managers
• Ability to operate in various roles within a cross-functional team of super users, grant managers, case managers, and program directors
• 4 or more years' experience with Relational Database Management Systems and hands-on experience writing SQL queries
• Strong understanding of relational data models and normalized data structures
• Willingness to gain strong technical understanding of the case management system
• Excellent analytical skills and data management abilities
• Excellent customer service skills
• Identify and raise technology or business process improvements

Requirements

• Bachelor’s degree in Information Systems, Computer Science, Data Management, or a related field, or equivalent experience
• Microsoft SQL Certifications a plus
• 4 or more years of experience in application support, system administration, or technical operations
• Advanced SQL and relational databases (joins, aggregations, subqueries)
• Experience working with case management, human services, or social services data
• Exposure to data validation, reporting support, or quality assurance activities

Company Description