Senior SQL Analyst

Emploi pas sur LinkedIn

🕒 il y a 1 mois

Postuler Maintenant

Trouver des Emplois à Distance Similaires

Recevoir des emails pour des emplois à distance

📊 Vérifiez votre score de CV pour ce poste

Améliorez vos chances d'obtenir un entretien en vérifiant votre score de CV avant de postuler.

Télécharger le CV

Goodwill Industries International

Site WebLinkedInTous les Emplois

51 - 200 employés

Fondée en 1902

🤝 À but non lucratif

📚 Éducation

🌍 Impact social

💰 €4 500 000 Grant en 2019-07

Non-profit • Education • Social Impact

Goodwill Industries International est une organisation à but non lucratif qui soutient un réseau de plus de 150 organisations Goodwill locales à travers les États-Unis. Elle se concentre sur la fourniture de formation professionnelle, de ressources de carrière et de services de soutien aux individus cherchant à surmonter les obstacles à l'emploi. En facilitant les dons et le shopping d'occasion, Goodwill vise à créer des opportunités pour les individus d'améliorer leur vie et contribuer à leurs communautés, en mettant l'accent sur la durabilité et l'impact social.

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.

🎯 Exigences

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