Job description
The Data Developer will be responsible for overseeing the Firm’s Database environment, Business Intelligence platform and Data Warehouse.
This position, reporting directly to the IS Applications Director, will ensure that all critical data assets are stable, healthy, secure and continually improved. In addition, the Data Developer will own the overall Data Architecture and contribute to the maintenance and development of systems integrations, reports and dashboards.
Requirements:
- Work closely with the Practice and Business Systems Management Team to develop and maintain a Data Strategy roadmap.
- Meet with Subject Matter Experts, Product Managers and Application Developers to gather business requirements.
- Design, model and develop across both Relational Databases and Data Warehouse.
- Develop SQL views, stored procedures and tables.
- Maintain, monitor, upgrade and secure the SQL Server platform in partnership with established vendor.
- Support, upgrade and maintain the Microsoft Reporting Server portal
- Develop ETL (extract, transform and load) processes to populate Data Marts and Warehouses
- Develop systems integrations across between traditional databases and modern Cloud APIs.
- Follow established Software Development Lifecycle (SDLC) activities including Analysis, Design, Development, UAT, Pilot, Testing & lessons learned.
- Troubleshoot data integrations/data feeds between systems.
- Create reports and dashboards using technologies such as PowerBI and Microsoft Reporting Services.
- Maintain required SDLC documentation, test scripts, training materials etc.
- Document databases models, system processes, and maintenance procedures.
Qualifications:
- Familiarity with Law Firm data concepts such as Clients, Matters, and Timekeepers.
- 5+ Years’ Experience in SQL Server Database Management
- 5+ Years’ Experience in SQL Server Database Development and SQL scripting (T-SQL)
- 5+ Years’ Experience in ETL development using Microsoft SQL Server Integration Services (SSIS)
- 5+ Years’ Experience developing reports and dashboards using PowerBI and Microsoft Reporting Services (SSRS)
- Experience with IntApp Integration Builder
- Must be detail oriented
- Must have strong customer service skills
- Must be results and goal oriented
- Must be able to work in high-paced environment with time sensitive deadlines
DISCLAIMER STATEMENT:
The preceding job description has been designed to indicate the general nature and level of the work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualification required of employees assigned to this job.
Organization Paul, Weiss, Rifkind, Wharton & Garrison LLP
Work Locations 1285 Avenue of Americas, New York, NY 10019-6064
Job Posting Aug 29, 2022, 11:49:26 AM
Job Type: Full-time
www.arclintfl.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, www.arclintfl.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, www.arclintfl.com is the ideal place to find your next job.