Senior Data Analyst - Troutman Pepper Hamilton Sanders

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!

Job Summary:  

The Senior Data Analyst will collaborate with colleagues on the Data & Analytics Team to deliver compelling, interactive dashboards and to create and maintain data pipelines derived from external sources. The Senior Data Analyst will work on complex problems related to firm operations, business development, and strategy. The role will interact regularly with business development teams, attorneys, and senior leadership. The Senior Data Analyst is responsible for assisting with the development of data sources, external data pipelines, and compelling dashboards used by firm leadership and clients.

Essential Duties and Responsibilities: 

• Develop and work with models upon which business decisions can be based, such as gap analyses, relationship science, risk analyses, digital analytics, and operational process analyses.

• Translate data into compelling, interactive Power BI dashboards; interpret data results to provide written commentary that articulates pertinent findings.

• Develop and maintain data pipelines from publicly available sources, such as state and federal agencies.

• Leverage disparate, internal, and external data sources to present a comprehensive analysis of the subject in question.

• Collaborate with team members to extract, transform, and load (ETL) data from disparate sources and unify where possible; manipulate, clean, and prepare data for analysis on an ongoing, project-by-project basis.

• Build relationships and collaborate with stakeholders across departments, identifying opportunities to leverage analytics and dashboards to enhance firm strategies and operations.

• Act as product manager for dashboards, reports, and other deliverables, ensuring that feedback from all stakeholders is gathered and leveraged in the ongoing system enhancement process.

• Collaborate with members of other technical departments to resolve problems and assist in efforts to implement data-based solutions throughout the organization.

Knowledge, Skills and Abilities:

• Strong data analytics skills, with proven ability to identify key insights from varied and robust data sources.

• Python and SQL proficiency is strongly preferred; key libraries include requests, beautifulsoup, selenium, scikitlearn, pandas, numpy, and seaborn.

• Familiarity with Foundation, InterAction (or other CRM system), Aderant, Vuture/Marigold, and federal/state agency data sources a plus.

• Intellectual curiosity, creativity, and innovative problem-solving skills.

• 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.

• Advanced critical thinking and problem-solving skills

• Ability to independently research complex problem areas, facilitate meetings and high-level decision-making processes.

• Excellent written and verbal communication skills

• Ability to maintain the confidentiality of firm data, as appropriate.

• Ability to adapt to change and balance competing demands while meeting deadlines.

Education and/or Experience: 

• Bachelor's degree required; any combination of training, education, and experience that demonstrates the ability to perform the position's duties may be considered.

• Minimum of four (4) years of relevant experience, preferably in legal or professional services firms, consultant agencies, research organizations, or journalism.

• Demonstrated experience and success with Power BI.

• Experience working with APIs and JSON beneficial.

• Experience with other data visualization and data management platforms (e.g., Alteryx, SQL Server Mgmt. Studio, Azure Data Studio) preferred.

#LI-DNI

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.

California Applicants: Please visit our Privacy Notice and Notice at Collection to learn about our information practices in the Job Application and Employment context.

Equal Employment Opportunity
Troutman Pepper 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.