What are the responsibilities and job description for the Business Intelligence (BI) Analyst II position at IDR, Inc.?
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