Business Intelligence Developer - Cognos
Roth Staffing Companies

BI Developer - Cognos Specialist (Contract with potential for Contract-to-hire)

We are seeking an experienced Business Intelligence (BI) Developer with strong Cognos development skills to provide critical reporting and analysis support, with a focus on manufacturing, finance, and business data. This role will be a technical resource (not project management focused), helping maintain and develop key BI solutions and supporting the business with ad hoc reporting, troubleshooting, and administration. The ideal candidate will be highly self-sufficient, with minimal need for training, and adaptable to company business practices.

This contractor position offers the possibility of conversion to a permanent role based on performance and business needs. This role is based in Eden Prairie 4 days per week (Monday through Thursday) with the opportunity to work remotely on Fridays. Contract pay is between $53-55/hour.

Candidates must be local to the St. Paul/Minneapolis metro area. Candidates must also be eligible to work in the U.S. without sponsorship both now and in the future. No third parties or C2C.

Responsibilities

• Cognos Development & Report Management:
• Design, develop, and maintain reports and dashboards using Cognos BI tools, including Framework Manager.
• Support TM1 reporting solutions (if applicable).
• Update and manage models, catalogs, and tables, ensuring data integrity through validation.
• Troubleshoot report issues and assist with back-end data fixes as needed.
• Promote changes from development to production, ensuring smooth deployments.
• Ad Hoc Reporting & Ongoing Support:
• Assist team with ongoing reporting requests, seasonal program updates, and operational needs.
• Handle renewals, report updates, and user requests efficiently.
• Provide support for upcoming acquisitions-developing new star schema frameworks and integrating new ERP systems and data warehouses.
• Collaborate with the team to support data needs for budgeting, forecasting, and planning.
• Manufacturing and Business Data Integration:
• Work with financial and manufacturing data sources, including Infor JBA, RSS Alliant, custom sales/inventory data, and ShopVue/Relex.
• Provide insights from customer sales, licensing, inventory, rebate, and incentive data to support business decision-making.

• Cognos BI & TM1 (Report Studio, Workspace Advanced, Framework Manager)
• SQL Server
• iSeries DB2
• SQL Server Reporting Services (SSRS)
• Microsoft Excel

• 3+ years of experience with Cognos development (including Report Studio and Framework Manager).
• Manufacturing data experience is strongly preferred.
• Ability to troubleshoot, maintain, and promote reporting solutions from development to production.
• Strong SQL skills with a focus on data validation and integration.
• Ability to support end-users with ad hoc reporting requests and provide operational guidance.
• Administrative experience in Cognos (25%)-able to promote solutions, resolve technical issues, and maintain environments as needed.
• Experience with trans