Database Engineer

The New York Compensation Insurance Rating Board (NYCIRB) is a non-profit, unincorporated association of insurance carriers. NYCIRB is licensed by the New York State Department of Financial Services as the official workers’ compensation rate service organization in the State. In this capacity, NYCIRB provides a variety of services to the workers’ compensation industry, including data collection and analysis, and the development of loss costs and rating values. These activities, along with analytical tools, research, and customer focused services, are intended to foster a stable and healthy workers’ compensation system in the State of New York.

The Database Engineer will be responsible for building complex database systems, optimizing databases, implementing data quality, and supporting development efforts. The individuals’ responsibilities are:

• Design, implement, maintain, and optimize database systems within the organization, ensuring data integrity, security, and efficient access by managing database structures, performance, best practices and scalability. Working closely with software engineers to integrate databases with applications and address data storage needs across the system. Provide a leadership role for the work group through knowledge of database systems
• Understand the business teams’ environment and technical challenges as well as their plans for evolving or creating their future state architecture. Using that knowledge, lead the analysis, design, and development of data solutions
• Build strategies for warehouse implementation, data acquisition and access, and data archiving and recovery. Builds data models and defines the structure, attributes and nomenclature of data elements. Will evaluate new data sources for adherence to the organization's quality standards and ease of integration
  
  

The successful candidate must have a track record of designing and developing database solutions, ad-hoc reports, and data manipulation on the SQL Server and/or Oracle platform. Particular emphasis will be placed on experience in building and delivering stable, serviceable data solutions in an independent fashion with minimal supervision. Excelling in a team environment where strong collaboration and high work ethics are essential. Candidate should have development experience with ODBC compliant relational databases, SQL, and/or Oracle

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Development and implementation using data analytics, database modeling tools and/or database interactions
• Work with business teams to gain and maintain a strong understanding of workers’ compensation data and how each department uses it, identifying opportunities to leverage database best practices, develop and enhance reuseable intellectual property and solutions
• Work with Solutions Architect, Project Managers, Business Analysts, and Developers in defining requirements and prototyping solutions
• Work with users to understand business requirements to create reporting or other solution specifications
• Review project requirements and assess and estimate the necessary time-to-completion
• Debug and troubleshoot complex data issues, ensuring the stability and reliability of our databases
• Designs report options and/or database queries to meet the needs of the organization
• Writing custom reports, SQL Scripts, Advance Searches and queries
• Write clean, efficient, and maintainable code, while adhering to coding standards and guidelines, ensuring consistency and efficiency in database development processes
• Document, propose and edit business data solutions and requirements
• Other duties as assigned and deemed necessary by management
  
  

QUALIFICATIONS:

• 5 years of backend software development experience required
• 5 years of SQL Server Development and/or Administration required
• Experience in Database design and normalization
• Experience in Database management and administration
• Experience in various programming architectures
• Experience using SQL Server / Azure SQL, NoSQL, ETL tools, and Windows Operating Systems
• Have used C# Entity Framework with SQL Server and/or Azure SQL
• Ability to execute projects accurately and quickly
• Solid team player who must be self-motivated and punctual
• Must be responsible, and detail oriented
• Microsoft certifications are a plus
• Insurance industry knowledge is a plus
  
  

EDUCATION REQUIREMENTS:

• BA/BS in Information Technology field
• Or BA/BS in any field combined with relevant experience in the field
  
  

PHYSICAL DEMANDS AND WORK ENVIRONMENTS:

The physical demands described in this section are to be representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.

• Work requires mobility with frequent bending and standing
• Frequent use of arms for stretching and reaching and use of legs for walking and lifting. 80% -90% of work hours are spent sitting down
• This job operates in an office setting. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, fax machines, and the like
  
  

The position description is a guide to the critical duties and essential functions of the job, not an all-inclusive list of responsibilities, qualifications, physical demands and work environment conditions. Position descriptions are reviewed and revised to meet NYCIRB’s changing needs, at the sole discretion of management.

SALARY RANGE:

$115,000.00 - $150,000.00

Powered by JazzHR

L1JITpBndj