Title: Analyst, Applications Support II
Duration: 9 month contract
Location: Denver, CO, 80202(Remote)
Description:
Role Summary:
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.
Skills:
· Informatica or equivalent ETL Application
· ActiveBatch or comparable Enterprise Scheduling Application
· ETL Data Movement in a Production Operation Role - Analyze, troubleshoot and resolve failures
· Utilize Workflow monitor to determine failure point
· Backtrack to Workflow Manager to further analyze components of a failed workflow viewed in monitor
· Interpret workflow/session logs to determine root cause of failure
· Ability to interpret SQL syntax from various database sources – SQL, Oracle, Netezza, DB2, etc.
· Coordinate and Collaborate with teams to resolve issues and enhance existing processes
· Provide support to source teams to implement Routine or Ad-hoc changes, and deployments
· Provide proactive support activities and process documentation
· Manage ticket queue and resolve or escalate issues
· Knowledge of SDLC process
· Development experience in an operation role is a plus
· Cloud data warehouse experience is a plus
Linux/Unix:
· Ability to navigate directories
· Understand file permissions and environmental variables
· Ability to read Shell Scripts, VI Editor usage