Business Intelligence Analyst

Business Intelligence Analyst

Cooley is seeking a Business Intelligence Analyst to join the Data Delivery team.

Position summary: Cooley Innovation embraces a culture of customer service excellence and all members of the department are expected to move this agenda forward. Working as a key part of the Data Delivery team, the Business Intelligence Analyst will work with employees across all functional groups to understand data needs, map business case scenarios, query underlying data and assist in the shaping of actionable information for consumers. Specific duties and responsibilities include, but are not limited to, the following:

Position responsibilities:

• Collaborate across practice groups and business functions to identify data needs, map business case scenarios and query underlying data to create actionable insights that enhance firmwide decision-making
• Understand the scope, coverage, and limitations of the enterprise data catalogue and external data integrations that support the reporting function
• Contribute to the development, expansion, and maturation of business intelligence analytics capabilities
• Actively promote, develop, brand and enhance the Business Intelligence function across all relevant business areas
• Manipulate sophisticated reporting tools including visualization tools such as Power BI and SSRS Reporting Services to develop reports, dashboards and visualizations such as: Client Lists; Marketing Event Lists; Relationship Reports, Thought Leadership Reporting etc.
• Develop, extend and mature Enterprise Intelligence analytics capabilities
• Create Business Intelligence end-user training curriculum, including user guides, tutorials, and live training sessions
• Work with the firm’s Enterprise Data Architects and Engineers to improve centralized management of data integrations by supporting the development of the firm’s data catalog, its related extract, load and transform processes as well as data governance functions
• Identify data stewardship tasks including design and implementation of data cleaning processes that leverage existing tools, clarification of ownership roles, and automation, where possible
• Catalog data sources including technical specifications, use cases and affected stakeholders
• Develop and maintain reporting templates where applicable that cover a wide range of regular requirements and that can be adapted by the team and end-users
• All other duties as assigned or required

Skills and experience:

Required:

• After orientation at Cooley LLP, exhibit proficiency in the Microsoft Office suite, iManage and other firm applications
• Ability to work extended and/or weekend hours, as required
• 4+ years’ experience performing exempt-level duties in a data focused role preferably in a legal services environment with an AMLAW 200 firm or an in-house department with 50+ attorneys; Eligible for consideration of Senior designation with 5+ years’ directly applicable work experience
• Exhibit analytical and critical thinking in day-to-day tasks
• Strong knowledge of data-oriented programming languages especially SQL
• Proficiency with one or more business intelligence platforms, (i.e., data visualization tools and methodologies, such as Excel, Power BI, DoMo and SSRS)
• Experience with SQL Server Management Studio, data warehouses and one or more cloud systems such as Azure or AWS

Preferred:

• Bachelor’s degree
• Strong technical background in legal data systems and their underlying structures, with proficiency in SQL-based data handling approaches
• Experience with Elite 3E Accounting software

Competencies:

• Exhibit analytical and critical thinking in day-to-day tasks
• Proven ability to transform complex data concepts into clear documentation that spans both technical and non-technical audiences to explain how data is collected, managed and used
• Ability to work both independently and collaboratively as needed in a geographically disparate staffing environment
• Excellent customer service skills
• Superior relationship management, presentation and collaboration skills
• Ability to take initiative while ensuring compliance with department standards in development, delivery and support of business systems

Cooley offers a competitive compensation and excellent benefits package and is committed to fair and equitable employment practices.

EOE.

The expected annual pay range for this position with a full-time schedule is $100,000 - $145,000. Please note that final offer amount will be dependent on geographic location, applicable experience and skillset of the candidate. Senior level candidates may be considered for th