Job description
Our client is looking to hire a SQL Database Developer at their offices in New York City 10019. This role is on a full time, direct hire basis and will pay an annual base salary of $155K to $170K plus a performance based bonus and excellent benefits package. Our client allows for a hybrid work week with 3 days onsite/2 remote.
The SQL Database Developer will be responsible for overseeing our client'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
#legal
colinoncars.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, colinoncars.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, colinoncars.com is the ideal place to find your next job.