Business Intelligence (BI) Analyst II

12 hours ago

To Apply for this Job Click Here

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
pay transparency: 30–32/hr W2

IDR is an equal opportunity employer. We provide reasonable accommodations for disabled employees and do not discriminate based on race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, marital status, criminal history, or any other protected category under applicable federal, state, or local laws. We consider all qualified applicants, including those with criminal histories, in compliance with applicable Fair Chance laws. To comply with civil rights laws, we invite applicants to voluntarily self-identify their race, ethnicity, gender, and veteran status. This information is confidential, optional, and will not affect your application. You may access this form here. Pursuant to pay transparency laws, salary ranges and benefits will be disclosed where required by law. Compensation is based on factors such as experience, skills, and qualifications. If you require a reasonable accommodation during the application or interview process, please contact Human Resources at hr@idr-inc.com