Applications Support Analyst II - 100% remote
Posted 1 day ago by Calance
Negotiable
Undetermined
Remote
Remote or Denver, Colorado
Summary: The Applications Support Analyst II will provide production support in a complex application and data warehouse environment, focusing on troubleshooting and resolving failures while enhancing BI systems' stability and performance. The role requires collaboration with IT teams to implement optimal solutions and improve processes, alongside developing documentation and participating in an on-call rotation. Continuous learning and proficiency enhancement are also emphasized in this position.
Key Responsibilities:
- Provide production support in a complex application and data warehouse environment.
- Analyze, troubleshoot, and resolve failures in BI systems.
- Collaborate with IT teams to resolve complex issues and implement optimal solutions.
- Develop and update documentation, technical procedures, and knowledge articles.
- Participate in on-call rotation and provide support during critical workflow failures.
- Manage ticket queue and resolve or escalate issues as necessary.
Key Skills:
- Informatica or equivalent ETL Application experience.
- ActiveBatch or comparable Enterprise Scheduling Application knowledge.
- ETL Data Movement experience in a Production Operation Role.
- Ability to interpret SQL syntax from various database sources (SQL, Oracle, Netezza, DB2, etc.).
- Knowledge of SDLC process.
- Linux/Unix navigation and shell script reading skills.
- Development experience in an operation role is a plus.
- Cloud data warehouse experience is a plus.
Salary (Rate): undetermined
City: Denver
Country: United States
Working Arrangements: remote
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Applications Support Analyst II
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
On-call rotation required One week every sixth week: details include:
On-call begins Monday at noon MST for one week. Analyze, troubleshoot and resolve critical workflow failures.
We have one fulltime resource that covers the nightshift from Friday evening through Wednesday morning. On-call covers Saturday and Sunday, Wednesday and Thursday after business hours. In addition, when our nighttime person takes PTO.