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