Senior SQL Analyst

Vaga não está no LinkedIn

🕒 Maio 22

Candidatar-se

Encontrar Vagas Remotas Similares

Receber Emails de Vagas Remotas

📊 Verifique sua pontuação de currículo para esta vaga

Melhore suas chances de conseguir uma entrevista verificando sua pontuação de currículo antes de se candidatar.

Enviar Currículo

Goodwill Industries International

SiteLinkedInTodas as Vagas

51 - 200 funcionários

Fundada em 1902

🤝 Sem Fins Lucrativos

📚 Educação

🌍 Impacto Social

💰 $4.500.000 Grant em 2019-07

Non-profit • Education • Social Impact

A Goodwill Industries International é uma organização sem fins lucrativos que apoia uma rede de mais de 150 organizações locais da Goodwill nos Estados Unidos. Ela se concentra em oferecer treinamentos profissionais, recursos de carreira e serviços de apoio a indivíduos que buscam superar barreiras para o emprego. Facilitando doações e compras em brechós, a Goodwill visa criar oportunidades para que as pessoas melhorem suas vidas e contribuam para suas comunidades, enfatizando a sustentabilidade e o impacto social.

Descrição

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

🎯 Requisitos

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