Troutman Pepper · 21 hours ago
Data Solutions Analyst
Rochester
Full-time
Onsite
Mid Level
$120K/yr - $140K/yr
3+ years expTroutman Pepper is a law firm committed to employee support and innovation. The Data Solutions Analyst is responsible for designing and delivering analytics solutions using the Microsoft Power Platform, focusing on creating interactive Power BI dashboards to support business decisions and client engagement.
Law Practice
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
Qualification
Required
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
Preferred
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
Company
Troutman Pepper
Troutman Pepper serves a wide range of clients specializing in addressing critical legal and business issues.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Greg Saulinskas
Chief Financial Officer
A. Michelle (Shelli) Willis
Partner
Recent News
Payments Dive
2025-11-11
Company data provided by crunchbase