Director of Business Development Analytics

Key Skills

Java Programming, Design, Python Programming, Database, SQL, PowerBI, Data Modeling, Tableau, Shell Scripting language, SSIS, Powerpoint, SharePoint, Data Analysis

Job Description

Reporting to the Data Engineering Manager, the Senior Data Engineer is responsible for analyzing, validating, cleansing the ETL of Enterprise data into our Finance Application and creates validation reports utilizing database technology and financial software. Create small datasets that the firm can use to retrieve and analyze data using Tableau dashboards.

Essential Duties and Responsibilities:

• Responsible for working with and mentoring our BI developers and data engineers in optimizing data sourcing and transformation that create an efficient, effective data organization.
• Collaborate with analysts and business intelligence to optimize the sourcing and consistency of KPI’s which will drive informed business decisions across the organization.
• Design, develop, test deploy and maintain large scale data sets for the firm by collaborating with the internal departments and external vendors.
• Develop and maintain reports using SSRS and Tableau.
• Develop SQL queries, stored procedures and functions as required for the reports and Tableau dashboards.
• Design and develop ETL processes and data structures following best practice procedures.
• Examples of experience in handling structured and unstructured data.
• Experience with data integration (ETL), data modeling, data quality, data governance, Enterprise Data Warehouse (EDW), and Analytical tools.
• Good understanding of data structures, data integrity and indexing with the ability to write efficient stored procedures and views.
• Utilize SSIS, SSRS and SSMS for ETL, Reports and Analysis of data.
• Ability to develop applications to support the report delivery to the end-users through Sharepoint sites.
• Ability to write Power shell scripts
• Be a knowledge resource and facilitator for data retrieval in support of all administrative business units.
• The mindset to drive innovation.

Knowledge, Skills and Abilities:

• Extensive working knowledge of SQL and data Engineering skills with ability to solve problems.
• Extensive working knowledge and understanding of SSRS and SSIS to transform report requests to quality SSRS reports
• Tableau experience a plus.
• Possess strong analytical and problem-solving skills.
• Exhibit strong written and oral communication skills.
• Strive to add value, build efficiency, and improve accuracy and reliability of information for the firm.
• Ability to maintain professionalism and build relationships with clients, attorneys, internal departments, and vendors, while maintaining confidential information.
• Ability to manage multiple projects simultaneously and meet tight deadlines while maintaining high standards for research quality.
• Demonstrate ability to take information from a wide variety of sources and ensure products are crisp, succinct, and client-ready.

Education and/or Experience:

• BS or BA in Computer Science, Management Information Systems; MS preferred.
• Six (6) or more years of relevant work experience with ETL, Data Integration and migration and strong SQL.
• Experience with creating and deploying ETL processes using SSIS required.
• Hands on experience retrieving data by writing complex SQL required.
• Proficient in Microsoft Office products such as MS Excel, SSRS, and Power Shell.
• A blend of technical and business skills, as well as strong interpersonal skills, developed from experience in data analysis, database design, and application development.
• Experience with Aderant and law firm a plus.

The Firm will comply with any applicable city or state workplace mandates in effect in regards to Covid-19. Partners and employees in the New York City office must submit proof of vaccination, unless the Firm provides a reasonable accommodation, pursuant to the Order of the Commissioner of Health and Mental Hygiene to Require COVID-19 Vaccination in the Workplace.

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.

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.