IT Business Systems Analyst

The Andrews Group is recruiting for Eversight, a global nonprofit eye bank making sight possible for individuals experiencing illness, injury, or blindness. The IT Business Systems Analyst will own critical business applications, manage vendors and integrations, support application administration and data quality, and provide analytics support through Tableau and data warehouse reporting.

Responsibilities:

• Serve as application owner for critical operations application and related integrated enterprise applications
• Oversee critical application development by vendor, co-ordinate releases, testing, deployments, and user communications
• Oversee application configuration, administration, and access management and other related administrative duties
• Respond too, and manage support tickets, escalations, and co-ordinate with development/support teams on fixes and enhancements
• Manage SQL data hygiene, validation and Support SQL based data validation and troubleshooting activities
• SQL Query troubleshooting
• Monitor application performance, reliability, and user satisfaction
• Manage application security and compliance
• Maintain application documentation, procedures, and knowledge repositories
• Coordinate application requirements across Operations teams
• Partner with Analytics to ensure application data and requirements align with established enterprise data definitions and governance standards
• Provide Tableau and data warehouse support to analytics teams including building dashboards and reports to drive actionable insights

Requirements:

• 5+ years supporting enterprise business applications
• Strong experience managing vendor-supported software platforms
• Experience managing application releases, testing, and user acceptance activities. Knowledge of SDLC and industry-wide best practices and standards
• Proficiency with T-SQL , including the ability to write queries for troubleshooting, validation, and root-cause analysis (SELECT queries, JOINS, Aggregations, Reading views, Understanding stored procedures)
• Data Analysis: Tracing data movement, investigating discrepancies, validating records, Understanding source-to-report flow
• Experience supporting reporting and analytics platforms such as Tableau or Power BI
• Experience troubleshooting application, data, workflow, and integration issues across multiple systems
• Working knowledge of APIs, data integrations, authentication, and application architecture concepts, SSO familiarity, Batch file processing
• Ability to translate business issues into detailed technical requirements and vendor support cases
• Experience validating data quality and supporting data warehouse/reporting environments