Database developer 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

At Exeter Finance, we are committed to helping customers find the right financing for their next vehicle purchase. By building strong relationships with our customers and network of dealer partners we are able to give options that make sense, getting customers behind the wheel of their car.

Every team member is integral to our success. Whether you're at a servicing center helping customers with their loans, in the field building relationships with dealers, or supporting the company from its corporate offices, you'll enjoy a nurturing, invigorating and positive work environment.

Our vision is to be a premier finance company and lender of choice known for its People, Performance and Service.
Job Description

*This position is primarily remote but will be required to be in office two times a month for collaboration working sessions.

Job Summary

The Database Developer III reviews, evaluates, designs, implements and maintains company database[s]. Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process. Writes codes for database access, modifications, and constructions including stored procedures and SSIS packages.

Job Duties

Develops, maintains and implements operational and reporting database systems utilizing the latest techniques in data modeling and ETL concepts, from business requirements to technical design to final product. Implements database solutions and ensures quality assurance and timely delivery of data. Investigates, troubleshoots and corrects data and user related system errors, and ensures data integrity. Monitors and contributes to SQL Server in an enterprise environment, including installation, configuration, jobs, backup, recovery, upgrades and schema changes. Contributes to support an IT roadmap that is forward thinking and sets the ground work for reducing maintenance cost while meeting or exceeding business objectives. Promotes a constructive, positive team environment and maintains a spirit of openness, information sharing inquisitiveness, problem-solving and support for common goals. Ensures compliance with Exeter's policies & procedures, safety, state and federal laws, regulations and standards. Other duties as assigned.



Education and Work Experience


Bachelor's Degree or equivalent in Computer Science or a related field of study. 2-4 years of job related experience. 4+ years of job related experience preferred.

#LI-Remote

Exeter Finance LLC is an Equal Opportunity Employer.

We are looking for a qualified Database Developer to design stable and reliable databases, according to our company's needs. You will be responsible for developing, testing, improving, and maintaining new and existing SQL scripts to help users and our products retrieve data effectively. You will know the importance of and have the ability to create high performing database objects. You will also collaborate with administrators and clients to provide technical support and identify new requirements. Ultimately, you should be able to ensure the SQL code that our application relies on runs correctly, with high performance, and securely on a daily basis.
About AgileAssets a Trimble Company:

At AgileAssets a Trimble Company, we make software that helps keep roads and bridges safe, while saving tax dollars in the US and around the globe. We are part of Mission Zero to save lives through safer infrastructure.

By joining our team, you'll work at the intersection of technology and transportation-two of the most critical industries for global connectedness and quality of life. You'll get to collaborate, lead, and innovate-all while helping to strengthen the transportation infrastructure that connects our cities, farmlands, and coastline. You will help do what we do best for transportation agencies worldwide: You will help them save time, money, and lives.

Responsibilities:
Design stable, reliable and effective database queries Optimize and maintain production systems Modify database structure according to requests and perform tests Solve database usage issues and malfunctions Liaise with developers to improve applications and establish best practices Work with Product Owners to gather and understand user requirements and identify new features Provide data management support to users Ensure all database programs meet company and performance requirements

Requirements:
Demonstratable PostgreSQL experience with both single tenant and multi-tenant databases Demonstrable experience in production level tuning and best practices in monitoring Proven work experience as a Database EngineerIn-depth understanding of data management (e.g., permissions, recovery, scaling, security, and monitoring) Knowledge of software development and user interface web applications Hands on experience with SQLExcellent analytical and organization skills An ability to understand users' requirements and a problem-solving attitude Excellent verbal and written communication skills BS degree in Computer Science or relevant field

Trimble offers great benefits such as a generous PTO package, paid healthcare, 401K, stock options, and education reimbursement. In addtion to those benefits, we do provide sign on bonus.

You can also take advantage of flexible schedules, wellness initiatives, volunteer opportunities, childcare discounts, and employee resource networks to support a positive and inclusive work environment for all.

This posting allows you to express interest in a future opening in this area. Trimble People Experience staff will contact you with an invitation to interview as upcoming job postings become available.
Trimble Inc. is proud to be an Equal Opportunity and Affirmative Action Employer and considers qualified applicants for employment without regard to race, gender, age, color, religion, national origin, marital status, disability, sexual orientation, status as a covered veteran in accordance with applicable federal, state, and local laws, or any other protected factor.
Trimble Inc. is proud to be an Equal Opportunity and Affirmative Action Employer and considers qualified applicants for employment without regard to race, gender, age, color, religion, national origin, marital status, disability, sexual orientation, status as a covered veteran in accordance with applicable federal, state and local laws, or any other protected factor. EOE/M/F/V/D