Business Intelligence (BI) Analyst II
Job ID: 501348 Posted 10 hours ago
Denver, Colorado
Contract
Business Intelligence and Analytics
30-32/hr
Job Details
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
To Apply for this Job Click Here
I want more jobs like this in my inbox.
Share This Job
Similar Jobs
Why Us?
IDR has been in business for over 25 years and offers access to hundreds of companies across the country to work for. For many of the contractors that work for us, there are some unique benefits to being a part of the IDR team. One specific benefit is that we believe our contractors are part of something bigger than yourself. We are an employee-owned company and in an ESOP (Employee Stock Ownership Plan), as the share price of our company grows, so does your equity in our company. Our contractors, as well as our internal employees, can participate in this plan after one year of service. In addition to joining our ESOP program, you will also receive weekly pay, 401k access, and access to three different benefit plans that cover 50% of the individual premiums along with access to unlimited behavioral health sessions with a licensed counselor.
About Us
IDR, Inc. is an award-winning, employee-owned staffing firm with headquarters in Alpharetta, GA and offices in the Nashville, Dallas, and Denver markets. Founded in 1998, IDR has grown to serve businesses and professionals across industries including IT, healthcare, accounting and finance, government services, and professional services. Recognized for our expertise and the high-touch approach of our Engagement Management Program, IDR continues to build rewarding partnerships with companies and consultants. Our best-in-class service has earned IDR ClearlyRated’s Best of Staffing Client and Talent awards for ten consecutive years, in addition to awards from Staffing Industry Analysts and Best and Brightest Companies to Work For. With our commitment to empowering talent and developing leaders, we’re passionate about what we do and how we do it, and we look forward to working with you.