Sidley Austin LLP

Returning Candidate?

Business Intelligence System Analyst

Business Intelligence System Analyst

Recruiting Location 
Information Technology

More information about this job


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.


To perform this job successfully, an individual must be able to perform the Duties and Responsibilities (the “Duties”) above satisfactorily and meet the requirements below. The requirements listed below are representative of the minimum knowledge, skill, and/or ability required. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions of the job. Employees or applicants who need an accommodation should contact Human Resources. If you need such an accommodation, please email (current employees should contact Human Resources).


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


Other Skills and Abilities:

The following will also be required of the successful candidate:

  • Strong organizational skills
  • Strong attention to detail
  • Good judgment
  • Strong interpersonal communication skills
  • Strong analytical and problem solving skills
  • Able to work harmoniously and effectively with others
  • A self-starter who desires to show ownership and commitment to the job
  • Able to preserve confidentiality and exercise discretion


 Sidley Austin LLP is an Equal Opportunity/Affirmative Action Employer.