Data Developer

The

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

• 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