Return To Search

Business Intelligence (BI) Analyst II

Location: Denver, CO

Job Type: contract

Company: IDR

Category: Business Intelligence and Analytics

Job Description Apply Now

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

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. IDR is subject to certain governmental recordkeeping and reporting requirements for the administration of civil rights laws and regulations. In order to comply with these laws, we invite employees to voluntarily self-identify their race or ethnicity, gender, and veteran status (if applicable). Submission of this information is voluntary and refusal to provide it will not subject you to any adverse treatment. The information obtained will be kept confidential and may only be used in accordance with the provisions of applicable laws, executive orders, and regulations, including those that require the information to be summarized and reported to the federal government for civil rights enforcement. You may access this form here.

Apply Now