Bella Currin

IDR is seeking a Business Intelligence (BI) Analyst II to join one of our top clients for a remote opportunity. This role focuses on production support within a complex BI application and data warehouse environment—analyzing, troubleshooting, and resolving ETL/workflow failures, performing deep data research, and implementing fixes to improve long-term stability and performance.

Position Overview for the Business Intelligence (BI) Analyst II:

• 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 for the Business Intelligence (BI) Analyst II:

• 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.

Nice to have:

• Development experience in an operations-focused role.
• Cloud data warehouse experience.

#LI-Remote