BI Analyst

Chicago, IL 60606

Post Date: 02/13/2018 Job ID: 10051 Category: Data

Working extensively with the Firm’ s financial systems to facilitate the information needs of the Firm’ s Accounting and HR departments, this position is responsible for performing in-depth data analysis, defining information needs, and delivering information via various Business Intelligence defined methods.

Duties and Responsibilities:
  • Perform complex data analysis on Sidley’ s main financial system (Elite Enterprise - Billing, AP, GL and Conflicts modules), the data warehouse (Intellistat), and miscellaneous other 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 Crystal Report Developer or Cognos Report Studio 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; and prioritize tasks and responsibilities to properly manage one' s own workload;
  • 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.

Education and/or Experience:

  • Bachelor’ s degree from an accredited or approved college or university
  • At least 2 years of work experience in a related business or business intelligence field
  • Excellent overall computer skills
  • Proficient with Microsoft Office (especially Excel and PowerPoint at an intermediate level)
  • Familiarity with Cognos 10.x Report Studio
  • Familiarity with Crystal Reports or other similar Reporting Tools
  • Strong SQL Skills, including Performance tuning queries
  • Solid understanding of relational database concepts along with experience with report writing  and database query tools

  • Two year work experience in a professional services industry
  • Experience with client-server applications utilizing a SQL Server (or similar) database
  • Experience with Cognos TM1
  • Experience with Microsoft SQL Server, SQL Server Reporting Services, SQL Server Analysis Services
  • Crystal Reports Development Experience
SQL Queries, Excel, Reporting (Any tool, Cognos or SSRS prefered.

Not ready to apply?

Send an email reminder to:

Share This Job:

Related Jobs: