IT Operations Business Intelligence (BI) Analyst

Endava

3h • Hybrid

About The Position

The IT Operations Business Intelligence (BI) Analyst II will provide production support in a complex application and data warehouse environment. This role involves analyzing, troubleshooting, and resolving failures, as well as providing clarity through in-depth data research and implementing fixes. The Analyst II will collaborate with various IT teams to resolve complex issues and deliver optimal solutions, with a strong focus on process improvement. The position also entails continuously enhancing the stability and long-term performance of BI systems, developing and updating documentation, technical procedures, and knowledge articles. The analyst is expected to increase proficiency and scope of involvement through guided and self-initiated learning. Participation in an on-call rotation is a required aspect of this role.

Requirements

• Experience with Informatica or similar ETL tools
• Experience with ActiveBatch or comparable enterprise scheduling tools
• Hands-on experience supporting ETL data movement in a production environment, including analyzing, troubleshooting, and resolving failures
• Ability to use workflow monitoring tools to identify failure points and trace issues back through workflow components
• Experience interpreting workflow and session logs to determine root cause
• Strong ability to write and interpret SQL across databases such as Oracle, Netezza, and DB2
• Ability to collaborate with cross-functional teams to resolve issues and improve processes
• Experience supporting routine and ad-hoc changes, including deployments
• Proactive in process improvement, documentation, and knowledge sharing
• Experience managing a ticket queue, including prioritization and escalation
• Understanding of SDLC processes
• Ability to navigate Linux/Unix environments, including directories, file permissions, and environment variables
• Ability to read shell scripts and use tools such as the VI editor
• Willingness to participate in an on-call rotation (one week every six weeks), including after-hours and weekend support, and resolving critical workflow failures

Nice To Haves

• Cloud data warehouse experience is a plus
• Development experience in an operations or support role is a plus

Responsibilities

• Provide production support in a complex application and data warehouse environment
• Analyze, troubleshoot and resolve failures
• Provide clarity with in-depth data research
• Implement fixes
• Collaborate with teams across IT to resolve complex issues and provide optimal solutions, with an emphasis on process improvement
• Work to continuously enhance the stability and long-term performance of BI systems
• Develop and update documentation, technical procedures, and knowledge articles
• Increase proficiency and scope of involvement on all activities through guided and self-initiated learning
• Participate in on-call rotation

Benefits

• Robust healthcare and benefits including Medical, Dental, vision, Disability coverage, and various other benefit options
• Flexible Spending Accounts (Medical, Transit, and Dependent Care)
• Employer Paid Life Insurance and AD&D Coverages
• Health Savings account paired with our low-cost High Deductible Medical Plan
• 401(k) Safe Harbor Retirement plan with employer match with immediately vest

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed