IT Operations Business Intelligence (BI) Analyst

Job Description

The IT Operations Business Intelligence (BI) Analyst II will provide production support in a complex application and data warehouse environment; analyze, troubleshoot and resolve failures; provide clarity with in-depth data research; and implement fixes.  The Analyst II will 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.  Participation in on-call rotation is required.

Qualifications

Required:
Experience with Informatica 

Experience with ActiveBatch or comparable enterprise scheduling applications.

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

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

Additional Information

All your information will be kept confidential according to EEO guidelines.

Additional Employee Requirements  
Participation in both internal meetings and external meetings via video calls, as necessary. 
Ability to go into corporate or client offices to work onsite, as necessary. 
Prolonged periods of remaining stationary at a desk and working on a computer, as necessary. 
Ability to bend, kneel, crouch, and reach overhead, as necessary. 
Hand-eye coordination necessary to operate computers and various pieces of office equipment, as necessary. 
Vision abilities including close vision, toleration of fluorescent lighting, and adjusting focus, as necessary. 
For positions that require business travel and/or event attendance, ability to lift 25 lbs, as necessary. 
For positions that require business travel and/or event attendance, a valid driver’s license and acceptable driving record are required, as driving is an essential job function.
*If requested, reasonable accommodations will be made to enable employees requiring accommodations to perform the essential functions of their jobs, absent undue hardship.   
USA Benefits (Full time roles only, does not apply to contractor positions)
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   

At Endava, we’re committed to creating an open, inclusive, and respectful environment where everyone feels safe, valued, and empowered to be their best. We welcome applications from people of all backgrounds, experiences, and perspectives—because we know that inclusive teams help us deliver smarter, more innovative solutions for our customers. Hiring decisions are based on merit, skills, qualifications, and potential. If you need adjustments or support during the recruitment process, please let us know.