Troutman Pepper

Design and develop interactive dashboards and analytics solutions using Power BI and Power Platform, build SQL queries, and collaborate with stakeholders to deliver data-driven insights. | Minimum of 3 years of relevant experience in data visualization, Power Platform, SQL, and stakeholder collaboration, with a background in law firms, professional services, or similar environments. | We are always seeking talented, motivated, growth-minded, and creative individuals. Our firm is committed to providing employee support and advancement, while embracing inclusion and innovation as keys to a stronger future. We invite you to explore the position below and to submit your application to join our team! The Data Solutions Analyst design and deliver analytics solutions using the Microsoft Power Platform, with a primary focus on creating interactive Power BI dashboards that drive business decisions across the firm. Working closely with business development teams, attorneys, and leadership, the Analyst translates complex data into compelling visual stories and automated workflows that support client engagement and firm strategy. The Analyst will develop Power Platform solutions, maintain data pipelines, build SQL queries in SSMS, collaborate with stakeholders to understand their needs, and serve as a trusted advisor for data-driven insights.  Essential Duties and Responsibilities: • Design, develop, and maintain interactive Power BI dashboards and analytics solutions that translate complex data into actionable insights for business development, client engagement, and operational decision-making. • Build integrated Power Platform solutions (Power Automate workflows, Power Apps applications, Power Query data transformations) to streamline processes and enhance user experience. • Write and optimize SQL queries in SQL Server Management Studio (SSMS) using existing tables and schemas to support reporting, data validation, modeling, and automated workflows. • Collaborate with business development teams, attorneys, and leadership to gather requirements, understand analytical needs, and deliver solutions tailored to client and practice growth. • Develop and maintain automated data pipelines connecting internal systems and external data sources, including federal and state agencies, legal databases, and third-party vendors. • Present insights and recommendations to stakeholders, serving as product owner for analytics deliverables and continuously refining dashboards and workflows based on user feedback. • Work cross-functionally with the Data Solutions team and other technical teams on data integration, quality assurance, problem resolution, and implementing data-driven operational solutions. • Leverage available artificial intelligence resources to enhance work product and internal processes. • Demonstrate intellectual curiosity, creativity, and advanced critical thinking and problem-solving skills • Maintain the confidentiality of firm data, as appropriate.  Knowledge, Skills, and Abilities: • Strong proficiency with Microsoft Power Platform including Power BI, Power Automate, and Power Apps; ability to design integrated solutions across the platform. • Advanced Power BI expertise required including DAX, Power Query, data modeling, report design, and dashboard UX principles. • Exceptional ability to communicate data insights to non-technical audiences through compelling visualizations and clear written narratives. • Strong stakeholder management and collaboration skills with demonstrated ability to build relationships across departments, understand business needs, and manage competing priorities. • SQL proficiency required for data extraction and manipulation, experience with data transformation and integration. • Robust data analytics skills, with proven ability to identify key insights from varied and robust data sources. • Strong organizational skills with the ability to handle multiple projects simultaneously while focusing on continuous improvement. • Ability to take initiative without established guidelines and procedures using significant independent judgment. • Excellent written and verbal communication skills • Ability to independently research complex problem areas, facilitate meetings and high-level decision-making processes. • Ability to adapt to change and balance competing demands while meeting deadlines. • Familiarity with Foundation, DealCloud (or other CRM system), Aderant, Vuture/Marigold, and federal/state agency data sources a plus.  Education and/or Experience: • Bachelor's degree; any combination of training, education, and experience that demonstrates the ability to perform the position's duties may be considered. • Minimum of three (3) years of relevant experience working in law firms, professional services firms, consultant agencies, research organizations, or journalism. • Demonstrated experience and success developing solutions with Microsoft Power Platform, particularly Power BI. Experience building Power Automate workflows and integrating Power Platform tools strongly preferred. • Experience with other data visualization and data management platforms (e.g., Alteryx, Azure Data Studio) preferred. • Python experience beneficial; key libraries include pandas, requests, beautifulsoup, and selenium. • Experience presenting to senior leadership and facilitating data-driven discussions with attorneys and business development teams. • Power Automate experience building automated workflows and data integration processes. • Experience working with APIs, JSON, and web-based data sources. The Firm will comply with any applicable city or state workplace mandates in effect in regards to Covid-19. This position description is intended to describe the general content of and requirements for the performance of the job. The statements contained in the position description are not necessarily all-inclusive and additional duties and responsibilities may be assigned as determined by business needs. This position description does not constitute a written or implied contract of employment. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. By applying for this position, you agree and understand that Troutman Pepper Locke will process your Personal Information pursuant to the terms of our Worker and Applicant Global Privacy Notice. If you have questions about our data handling practices, or you are a resident of California, the United Kingdom, or the European Union and wish to exercise your privacy rights, please contact us at privacy@troutman.com. Equal Employment Opportunity Troutman Pepper Locke adheres to a policy of equal opportunity and will make all employment decisions, which include hiring, promotion, transfer, demotion, evaluation, compensation and separation, without regard to race, color, religion, sex, age, sexual orientation, gender identity or expression, national origin, pregnancy, citizenship, disability, genetic information, marital or armed forces status and any other classification as protected by law. Compensation is dependent on several factors, such as position, location, education, training, and/or experience. Hiring Salary Range: $120,000.00 - $140,000.00

Manage and coordinate legal administrative processes, support billing and compliance, and implement process improvements to enhance firm profitability and efficiency. | Bachelor's degree or equivalent experience, minimum 3 years as paralegal/legal assistant/legal secretary, strong organizational and communication skills, proficiency with Microsoft Office, and ability to work independently and collaboratively. | We are always seeking talented, motivated, growth-minded, and creative individuals. Our firm is committed to providing employee support and advancement, while embracing inclusion and innovation as keys to a stronger future. We invite you to explore the position below and to submit your application to join our team! The Legal Project Analyst will work directly with attorneys, Paralegals, and Legal Practice Assistants to effectively manage and coordinate the firm's administrative and legal processes for their largest and most complex client relationships. The Legal Project Analyst will support reporting, knowledge management, and oversight of billing and collections for our top clients. The Legal Project Analyst will work with the administrative departments and attorney teams to develop and implement procedures to improve the firm's processes and profitability. The Legal Project Analyst will also support the Legal Project Management team's overall mission, which is to improve the partners' practices to allow them to engage in their legal work more effectively. ESSENTIAL DUTIES AND RESPONSIBILITIES: • Conduct analysis to help identify issues, working closely with the Legal Project Manager to provide guidance to client teams to streamline and improve the firm's legal teams' processes and gain efficiencies. • Support successfully implementing the firm's outside counsel guideline compliance function/technology. • Review time entries and bills to ensure compliance with outside counsel guidelines. • Implement process improvements for the legal team for tasks related to time entry, reporting, billing, and client compliance. • Support the implementation, use, and development of LPM best practices, tools, and software. • Liaise with other business services teams (ex., Pricing/Finance/IT/Marketing/Business Development/Litigation Support) and vendors to support partners and their clients/matters. • Develop a strong understanding of identified legal terms, including matter timelines and processes, to assist in reviewing and highlighting issues that need Attorney attention. • Develop processes to highlight and address issues quickly; create processes and corresponding documentation that could be replicated across the various legal teams as required. • Provide requested financial data and analysis. • Seek out opportunities to improve the Legal Project Management function at the firm. KNOWLEDGE, SKILLS, AND ABILITIES: • Professionalism, integrity, sound judgment, and discretion regarding sensitive and confidential matters. • Ability to work independently and on a team with limited supervision and to collaborate effectively across administrative departments and practice groups in all offices. • Service mindset and the ability to take the initiative, think critically, identify and solve problems, and marshal appropriate resources. • Ability to build and maintain strong relationships and gain the trust of the attorneys and professional staff. • Strong organizational skills reflect the ability to perform and prioritize multiple tasks and execute with attention to detail, even under pressure. • Excellent verbal and written communication skills, specifically regarding time entry. • Awareness and understanding of business processes and ability to identify areas for process improvement to develop and implement best practices. • Motivated self-starter who has been successful working in a high-performance, fast-moving, dynamic environment. • Proficiency with Microsoft Office suite is required, with strength in using Excel (e.g., lookups, pivot tables); demonstrated ability to learn and utilize additional technology solutions quickly. • Flexibility and a positive attitude. • Interpersonal communication skills are required for many positions, including communication with outside entities and departments within our organization. • Capability to adapt to changes as clients routinely update their requirements. • Willingness to travel occasionally. EDUCATION AND/OR EXPERIENCE: • Bachelor's degree in accounting, finance, business administration, legal field, or Paralegal Certification; a combination of education, training, and experience that demonstrates the ability to perform the duties of the job may be considered. • Minimum of three (3) years' experience as a paralegal, legal practice assistant or legal secretary. #LI-Hybrid The Firm will comply with any applicable city or state workplace mandates in effect in regards to Covid-19. This position description is intended to describe the general content of and requirements for the performance of the job. The statements contained in the position description are not necessarily all-inclusive and additional duties and responsibilities may be assigned as determined by business needs. This position description does not constitute a written or implied contract of employment. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. By applying for this position, you agree and understand that Troutman Pepper Locke will process your Personal Information pursuant to the terms of our Worker and Applicant Global Privacy Notice. If you have questions about our data handling practices, or you are a resident of California, the United Kingdom, or the European Union and wish to exercise your privacy rights, please contact us at privacy@troutman.com. Equal Employment Opportunity Troutman Pepper Locke adheres to a policy of equal opportunity and will make all employment decisions, which include hiring, promotion, transfer, demotion, evaluation, compensation and separation, without regard to race, color, religion, sex, age, sexual orientation, gender identity or expression, national origin, pregnancy, citizenship, disability, genetic information, marital or armed forces status and any other classification as protected by law. Compensation is dependent on several factors, such as position, location, education, training, and/or experience. Hiring Salary Range: $70,000.00 - $90,000.00