PhiladelphiaRecruiter Since 2001
the smart solution for Philadelphia jobs

Practice Group Data Analyst

Company: Morgan Lewis
Location: Philadelphia
Posted on: November 26, 2022

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 Senior Data Analyst for its Legal Practice Data Analytics Department. This position will be resident in any of our U.S. offices, but the ideal candidate would be generally available to work a schedule of 11:00 AM Eastern to 8:00 PM Eastern (i.e., 8:00 AM Pacific to 5:00 PM Pacific). As our world becomes more data driven, data analysts with strong technical skills are becoming absolutely essential to the practice of law. In this role, the selected candidate will be on the front line of law and data analytics.This position can reside in either of our Boston, Chicago, Dallas, Houston, Philadelphia, Washington DC office with a hybrid in-office/remote working schedule.Responsibilities:

  • Work in a collaborative team environment to support attorneys and paralegals on a wide variety of complex business and legal issues
  • Access, parse, and load complex data sets from small text files to large databases from enterprise applications quickly, efficiently, and accurately
  • Perform data engineering, modeling, and analytic tasks to facilitate client reporting capabilities, enhance dashboards, and provide actionable data and insightful analysis
  • Join attorneys on client meetings to lead technical discussions including output file definition, input file requirements, and general interpretation of data
  • Mentor, teach, share knowledge and analytic techniques with your colleaguesEducation and experience:
    • Minimum of three years of relevant experience in developing analytic solutions with proficiency in SQL, Microsoft Excel, Power BI, or similar data analysis and ETL tools
    • Bachelor's degree (B.S./B.A.) in an appropriate field from an accredited college or university
    • Preferred experience in developing client facing visualizations and reports using Power BI, SSRS or similar visualization tools is a plus
    • Preferred knowledge of coding in Python, R, DAX and/or M
    • Preferred experience in developing SSIS and/or SSAS solutions
    • Strong verbal and written communication skills with the ability to convey highly complex technical concepts down to actionable objectives to advise stakeholders including attorneys, firm management, and firm colleagues
    • Experience in project management including planning, organizing, and supervising clients and colleagues towards successful project completion
    • Demonstrated ability to learn and succeed in a fast-paced environment
    • Expert level of proficiency with T-SQL or equivalent including a high level of proficiency in database administration
    • High proficiency with Microsoft Excel including an ability to create pivot tables, power pivots & queries, formulas, and external data connections
    • Ability to design and implement ETL solutionsCOVID-19: Morgan, Lewis & Bockius LLP requires its personnel to be fully vaccinated against COVID-19. Proof of vaccination is required. -Morgan, Lewis & Bockius LLP is committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. We value and encourage diversity 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. Morgan Lewis & Bockius LLP is also an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law.If you are interested in applying for employment with Morgan Lewis and need special assistance or an accommodation to use our website or to apply for a position, please call or email the following contacts:
      • Professional Staff positions: Please call 888.534.5003 or email
      • Lawyer/Summer Associate positions: 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 Karen Queen-LeBoo at .

Keywords: Morgan Lewis, Philadelphia , Practice Group Data Analyst, Professions , Philadelphia, Pennsylvania

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Pennsylvania jobs by following @recnetPA on Twitter!

Philadelphia RSS job feeds