The Business Intelligence System Analyst (BI System Analyst) is responsible for facilitating the financial information and reporting needs of the Firm. This person will act as a day-to-day analyst responsible for organizing data points, developing ad hoc reporting and long-term reporting solutions. The BI System Analyst will work alongside Business Intelligence Strategy Analysts, and liaise with business users, various levels of management and the IT department to perform in-depth data analysis, interpret and define information needs, develop and deliver information via various Business Intelligence defined methods to drive business impact across the firm.
Perform complex data analysis, query and report development leveraging Sidley's main financial system(s) where applicable (e.g. Elite 3E, Big Hand data warehouse Intellistat) and other custom business systems as needed; Work with the end users, developers and team management to understand business processes and requirements; identify gaps, communicate 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 for projects and daily operations; Develop reports using BI Tools, including IBM Cognos, Tableau, Business Objects and other tools for management reporting and financial analysis; connect and create SQL-statement-based queries or tools to facilitate data analysis; Work with the BI Solutions 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 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; Partner with cross-functional teams, including BI Strategy, various IT and accounting teams, and end-users, to facilitate effective communication and ensure a holistic understanding of business requirements and information delivery plan; Troubleshoot data and application issues with end users; 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, conduct thorough analysis of existing business processes to implement a BI solution from requirements gathering through post-implementation support. Other duties, as needed. To perform this job successfully, an individual must be able to perform the Duties and Responsibilities (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. If you need such an accommodation, please email (current employees should contact Human Resources).
Education and/or Experience
Required:
Bachelor's degree in Accounting, Business Management/Administration, Finance, Computer Science, Information Systems from an accredited and approved college or university; or equivalent work experience A minimum of 2 years of experience in a professional services firm (ideally a law firm) or business intelligence Experience writing queries against a SQL Server (or similar) database Proficient with Microsoft Office, particularly Excel Understanding of relational database concepts along with experience with report development leveraging database tables and 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) Proven ability to communicate across business units and translate technical language to business terminology. Preferred:
Previous experience with progressive financial analysis Demonstrated technical and analytical skills within professional background Knowledge of Elite 3E Other Skills and Abilities:
Strong attention to detail and pattern recognition Strong organization, problem solving, and analytical skills Strong interpersonal communication skills Exercises good judgment Able to perform data analysis to identify trends, patterns, and insights that inform business decision-making Able to participate in the design and implementation of system enhancements to meet business needs Able to facilitate and promote collaboration with stakeholders Able to work harmoniously and effectively with others Able to preserve confidentiality and exercise discretion Able to work under pressure in a fast paced environment Able to manage multiple projects with competing deadlines and priorities Sidley Austin LLP is an Equal Opportunity Employer
