Data Solutions Analyst

Troutman Pepper • Los Angeles, CA

1d • $120,000 - $140,000

About The Position

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.

Requirements

• 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.
• 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.
• Power Automate experience building automated workflows and data integration processes.

Nice To Haves

• Familiarity with Foundation, DealCloud (or other CRM system), Aderant, Vuture/Marigold, and federal/state agency data sources a plus.
• 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.
• Experience working with APIs, JSON, and web-based data sources.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees