Job

BI Systems Analyst (22-00907)

By June 21, 2022August 18th, 2022No Comments

Duration: Perm / Direct Hire
Location: Chicago, IL

Responsibilities:

  • Perform complex data analysis and query development on the main financial systems and other custom business systems as needed
  • Work with the business units and management to analyze business processes, identify gaps and define requirements for technical solutions including reporting, data warehousing and general application development; assist in the development of process changes or new technical solutions to satisfy the business need;
  • Develop reports using BI Tools, including IBM Cognos, Business Objects and other tools for management reporting and financial analysis; create SQL-statement-based queries or tools to facilitate data analysis;
  • Work as part of a team to develop data analysis models; create reports against source and data warehouse technologies; assist the business units in their information needs and end user reporting solutions;
  • Work with end users and developers, including outside consultants, to gather business requirements and to communicate business and technical requirements for projects or operational needs;
  • Work with end users to address ad-hoc data analysis requests; determine the proper course of action to manage appropriate timelines via ticketing systems such as Service Now and JIRA
  • Troubleshoot data and application issues; fully analyze the impact and determine the strategy for a resolution; fully test and reconcile reports and data analyses; assist in the implementation of the solution;
  • Assess the BI readiness of a business area and, when appropriate, implement a BI solution from requirements gathering through post-implementation support.

Requirements:

  • Bachelor's degree in Accounting, Finance, Computer Science, Information Systems or equivalent work experience
  • At least 2 years of work experience in a related business or business intelligence field
  • Experience writing complex SQL queries against a SQL Server (or similar) database
  • Proficient with Microsoft Office, particularly Excel
  • Understanding of relational database concepts along with experience with report writing and database query tools
  • Experience with standard Business Intelligence tools such as Cognos Analytics or TM1, SQL Server Management Studio, Business Objects, Tableau, , Power BI, SQL Server Reporting Services, SQL Server Analysis Services (or similar)