Business Intelligence (BI) Analyst II

IDR, Inc. is seeking a Business Intelligence (BI) Analyst II for a remote opportunity to provide production support within a complex BI application and data warehouse environment. The role involves analyzing, troubleshooting, and resolving ETL/workflow failures while collaborating with IT teams to enhance system stability and performance.

Responsibilities:

• Provide production support for BI systems in a complex application and data warehouse environment
• Analyze, troubleshoot, and resolve critical ETL/workflow failures; determine failure points and drive root-cause resolution
• Utilize workflow monitoring tools to identify failures, then trace components and interpret workflow/session logs
• Perform in-depth data research to provide clarity, validate fixes, and support process improvement initiatives
• Collaborate with cross-functional IT teams to resolve complex issues and recommend optimal solutions
• Support routine and ad-hoc changes/deployments for source teams, including proactive support activities
• Manage ticket queue; resolve issues and escalate appropriately with clear communication
• Develop and maintain technical documentation, procedures, and knowledge articles
• Participate in an on-call rotation (one week every sixth week)

Requirements:

• Experience with Informatica (or equivalent ETL tool)
• Experience with ActiveBatch (or comparable enterprise scheduling tool)
• Hands-on experience supporting ETL data movement in a production operations role (troubleshooting and resolving failures)
• Ability to interpret SQL syntax across multiple database platforms (e.g., SQL Server, Oracle, Netezza, DB2, etc.)
• Understanding of SDLC processes
• Linux/Unix skills, including navigating directories, understanding file permissions/environment variables, reading shell scripts, and using vi
• Development experience in an operations-focused role
• Cloud data warehouse experience