BI Analytics Analyst

Morgan Lewis; Philadelphia (Philadelphia County); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Morgan, Lewis & Bockius LLP seeks a Business Intelligence Analytics Analyst in Philadelphia with a strong background in dashboards and data modeling. You will design, develop, and sustain complex reports for partners and administration, crafting KPIs and governance standards to drive firm value.

The role requires collaboration with IT and firm departments, a commitment to accuracy, and the ability to navigate a fast-paced professional environment with a hybrid in-office/remote schedule.

Qualifications

• Bachelor’s degree in business, IT, or related field or equivalent experience.
• Strong proficiency with Excel, Power BI, SQL Server, and data visualization tools.
• Ability to analyze complex data and present actionable insights.

Responsibilities

• Develop complex analytical dashboards and reports for partners and management.
• Define and implement BI standards and data governance processes.
• Collaborate with IT for data infrastructure and source systems support.
• Identify business KPIs and model data to support strategic decisions.

Skills

Excel

Power BI

SQL Server

Tableau

Qlik

SSRS

Access/VBA

Data Visualization

Education

Bachelor's degree

Tools

Elite Financial Systems

Job description

Morgan, Lewis & Bockius LLP, one of the world’s leading global law firms with offices in strategic hubs of commerce, law, and government across North America, Asia, Europe, and the Middle East, is seeking to hire a Business Intelligence Analytics Analyst. Reports to the Manager, Business Intelligence Analytics, assists with identifying Firm BI needs and then designs and develops solutions, including complex reports and dashboard development, that drive value for the Firm. This position will reside in our Philadelphia office and offers a hybrid in-office/remote working schedule.

Key responsibilities

• Assists in developing complex analytical dashboards and reporting solutions for partners, legal staff, firm management, and administrative users
• Assists in developing standards for reporting.
• Assists in determining requirements for centralized, governed data sources and develop processes to ensure accuracy of data.
• Develops key performance indicators to meet the requirements of key business drivers.
• Implement business rules in applicable BI applications.
• Work with business functions to identify and implement BI solutions to solve specific business problems.
• Develop statistical modelling and analysis work required for BI solutions.
• Assist in determining appropriate benchmarks for identified firm goals.
• Develop complex dashboards and reporting solutions for partners, legal staff, firm management, and administrative users.
• Coordinate with IT department for infrastructure and database support.
• Coordinate with and support embedded analysts in other firm administrative departments (for example, analysts in Practice Operations department).
• Perform ad hoc analysis as needed.

Experience and qualifications

• Bachelor's degree in Business Administration, Computer Science, Information Systems, or a related field (or equivalent experience).
• Technical proficiency with reporting and analytics tools, including Excel, Power BI, Access/VBA, SQL Server, Visual Studio, SSRS, Tableau, and Qlik.
• Experience with Elite Financial Systems is preferred.
• Ability to analyze complex data, identify trends, solve problems, and draw actionable conclusions.
• Strong quantitative skills, including the ability to interpret metrics, ratios, percentages, graphs, and charts.
• Excellent written and verbal communication skills with the ability to effectively interact with employees, clients, and vendors.
• Demonstrated ability to manage competing priorities, adapt to changing business needs, and work in a fast-paced environment.

Morgan, Lewis & Bockius LLP is committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. We value inclusion and solicit applications from all qualified applicants without regard to race, color, gender, sex, age, religion, creed, national origin, ancestry, citizenship, marital status, sexual orientation, physical or mental disability, medical condition, veteran status, gender identity, genetic information, or any other characteristic protected by federal, state, or local law. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment qualified applicants with arrest and conviction records.

California Applicants: Pursuant to the California Consumer Privacy Act, the following link contains the Firm's California Consumer Privacy Act Privacy Notice for Candidates which explains the categories of personal information that we collect and the purposes for which we use such personal information. CCPA Privacy Notice for Candidates.

Morgan, Lewis & Bockius, LLP reasonably accommodates applicants and employees who need them to perform the essential functions of the job because of disability, religious belief, or other reason protected by applicable law. If you believe you need a reasonable accommodation during the application process, please contact Talent Acquisition at 888.534.5003 or [e-mail].

If hired, your employment relationship with the firm will be on an "at-will" basis, meaning that the firm may modify the terms and conditions of your employment at any time, and that either you or the firm will be free to end the relationship at any time with or without cause and with or without advance notice, although reasonable notice would be expected.

At Morgan Lewis, we work in collaboration around the world—always ready to respond to the needs of our clients and craft powerful solutions for them. From our offices in strategic hubs of commerce, law, and government in North America, Asia, Europe, and the Middle East, we work with clients ranging from established, global Fortune 100 companies to enterprising startups. We provide comprehensive litigation, corporate, finance, restructuring, employment and benefits, and intellectual property services in all major industries, helping clients address and anticipate challenges across vast and rapidly changing landscapes. And we approach every representation with an equal commitment to first understanding, and then efficiently and effectively advancing, the interests of our clients and arriving at the best results.

SEARCH FIRMS: Morgan Lewis does not accept resumes or referrals from search firms for most staff positions. If you are a search firm, employment agency, or representative of either, you will not be compensated in any way for your referral of a candidate to a position not approved for agency recruiters and/or for an inquiry submitted to anyone other than the recruiting contacts as listed on our main website.