Senior SQL Analyst

Job not on LinkedIn

🕒 May 22

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Goodwill Industries International

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 1902

🤝 Non-profit

📚 Education

🌍 Social Impact

💰 $4.5M Grant on 2019-07

Non-profit • Education • Social Impact

Goodwill Industries International is a nonprofit organization that supports a network of over 150 local Goodwill organizations across the United States. It focuses on providing job training, career resources, and support services to individuals looking to overcome barriers to employment. By facilitating donations and thrift shopping, Goodwill aims to create opportunities for individuals to improve their lives and contribute to their communities, emphasizing sustainability and social impact.

📋 Description

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

🎯 Requirements

• 4 or more years' experience with Relational Database Management Systems and hands-on experience writing SQL queries. • 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.