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.

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

By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively “Judge”) to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.