What are the responsibilities and job description for the Applications Support Analyst II - 100% remote position at Calance?
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.
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.