Business Intelligence (BI) Analyst II
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.pay transparency: 30–32/hr W2