The Opportunity:
Key Responsibilities:
- Dashboard Development: Design, develop, and maintain various kinds of dashboards in Power BI to track key contracts metrics, trends that show legal department’s performance and other KPIs. Ensure that dashboards provide monthly visibility into the legal team’s performance, enabling leadership to make informed, data-driven decisions.
- Support business tools integration and development: Support and manage the various tools like e-Billing and spend management, contract management, documents and data repository, approval workflows maintained currently on various platforms, handle user queries, create training manuals and work on continuous improvement of the systems. Create separate dashboards from all tools and integrate into a single presentation. Ensure that dashboards provide timely visibility. Develop new reports as per requirements.
- Optimizing team’s performance through Data Analytics: Leverage data analytics to create measurable metrics and present them by driving Excellence initiatives across the regionally situated legal teams. Analyze data related to contracts, litigations, spend, workflow, approvals workflows to uncover trends, identify areas for improvement, and optimize performance. Collaborate with the commercial and legal operations teams to deliver insights that support business objectives and enhance effectiveness.
- Power BI Development & Reporting: Lead the development of various solutions for the team using Power BI. Create interactive dashboards and reports that present insights in a visually compelling and actionable manner. Use various tools to transform and model data, ensuring reports are optimized for performance and clarity.
- Prepare presentations and reports: Work closely with the team members to support the creation of various presentations, reports and data metrics with excellent understanding of PowerPoint, M365 and Power BI.
- Stakeholder Collaboration: Collaborate with regional legal teams and IT teams to ensure alignment of reporting tools with business needs. Provide training and guidance to stakeholders on how to use reports and dashboards effectively.
- Optimise AI: Work with the team to maintain the legal team’s website, develop AI chat bots and legal AI bots for ensuring effectiveness, presence and reach of legal resources to the associates. Integrate and leverage tools like Chat GPT and Microsoft 365.
Required Skills & Qualifications:
- Education:
- Bachelor’s degree in business Analytics, Computer Science, Information Systems, or a related field
- Advanced certifications in relevant tools (Power BI, Excel, etc.) are a plus
- Experience:
- 5+ years of experience as a Business Analyst, Data Analyst, or similar role
- Strong proficiency in Advanced Excel (Pivot Tables, Macros, VBA scripting, complex formulas)
- Extensive experience in Power BI development
- Hands-on experience with PowerPoint and Microsoft 365
- Hands-on understanding of AI tools like Chat GPT and Microsoft 365 and their integration
- Technical Skills:
- Advanced Excel (including VBA and complex functions)
- Power BI (Dashboard development)
- Microsoft 365, Chat Gpt and other AI tools
- Dataverse, SharePoint Online, Teams, Yammer
- Other Skills:
- Strong analytical and problem-solving skills
- Excellent communication and interpersonal skills
- Ability to translate business requirements into technical solutions
- Detail-oriented with a strong commitment to data accuracy and quality
- Ability to manage multiple tasks and deadlines in a fast-paced environment
- Strong organizational skills
- Flexible with working hours
- Previous experience working on a legal team or in a law firm is an additional benefit
Disclaimer:
The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this position. Avantor is proud to be an equal opportunity employer.
Why Avantor?
Dare to go further in your career. Join our global team of 14,000+ associates whose passion for discovery and determination to overcome challenges relentlessly advances life-changing science.
The work we do changes people's lives for the better. It brings new patient treatments and therapies to market, giving a cancer survivor the chance to walk his daughter down the aisle. It enables medical devices that help a little boy hear his mom's voice for the first time. Outcomes such as these create unlimited opportunities for you to contribute your talents, learn new skills and grow your career at Avantor.
We are committed to helping you on this journey through our diverse, equitable and inclusive culture which includes learning experiences to support your career growth and success. At Avantor, dare to go further and see how the impact of your contributions set science in motion to create a better world. Apply today!
EEO Statement:
We are an Equal Employment/Affirmative Action employer and VEVRAA Federal Contractor. We do not discriminate in hiring on the basis of sex, gender identity, sexual orientation, race, color, religious creed, national origin, physical or mental disability, protected Veteran status, or any other characteristic protected by federal, state/province, or local law.
If you need a reasonable accommodation for any part of the employment process, please contact us by email at [email protected] and let us know the nature of your request and your contact information. Requests for accommodation will be considered on a case-by-case basis. Please note that only inquiries concerning a request for reasonable accommodation will be responded to from this email address.
3rd party non-solicitation policy:
By submitting candidates without having been formally assigned on and contracted for a specific job requisition by Avantor, or by failing to comply with the Avantor recruitment process, you forfeit any fee on the submitted candidates, regardless of your usual terms and conditions. Avantor works with a preferred supplier list and will take the initiative to engage with recruitment agencies based on its needs and will not be accepting any form of solicitation
