Senior Specialist, Sr. SQL Analyst, Case Mng
About The Position
Goodwill Industries International manages a shared case management system for its network of members, built on a SQL Server-based architecture that has transitioned to the latest Azure medallion architecture. As usage has expanded and the architecture evolved, there is a need for senior SQL Server expertise to optimize a 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 providing analytical support for operational reporting, compliance, and strategic decision-making. The position involves translating business requirements into technical solutions using MS SQL Server and custom internal programming. Key accountabilities include report design and optimization using SQL, SSRS, Fabric, and PowerBI for compliance and business-specific reports, evaluating improvements in database design for complex report generation, and contributing to new implementations while identifying simplification opportunities. The role also ensures data integrity, establishes reporting confidence, and develops strong product and business process expertise, acting as a technology subject matter expert.
Requirements
- 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.
- 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.
- Bachelor’s degree in Information Systems, Computer Science, Data Management, or a related field, or equivalent experience.
- 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.
Nice To Haves
- 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.
- Microsoft SQL Certifications a plus.
Responsibilities
- Develop and maintain complex SQL queries to extract, analyze, and validate grant and case management data.
- Develop sophisticated Stored Procedures, User-Defined Functions, and Triggers using set-based logic to replace inefficient procedural code.
- Analyze code written by vendor and write scripts for upload integration functionality.
- Validate and reconcile data across system environments, releases, and configuration changes.
- Report generation utilizing SQL queries, SSRS, Microsoft Fabric and Power BI.
- Establish and enforce Referential Integrity constraints and implement Row-Level Security (RLS) and data masking where necessary.
- Support operational, compliance, grant, and leadership reporting requirements.
- Analyze core case management data domains including demographics, enrollments, services, and outcomes.
- Investigate data discrepancies and partner with administrators and business users to resolve root causes.
- Create reusable queries, views, and technical documentation to support standardized reporting.
- Participate in Code Reviews for the team, establishing Best Practices for SARGable queries and efficient SQL patterns.
- Assist in the development and maintenance of data standards, field definitions, and data dictionaries.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
