Database Engineer

New York, NY

Full Time

Mid Level

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

Apply for this position

Required*

Apply with Indeed

First Name*

Last Name*

Email Address*

Phone*

Address

Resume*

We've received your resume. Click here to update it.

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Will you now, or in the future, require sponsorship for employment visa status (e.g. H-1B visa status)?*

Are you legally authorized to work in the United States?*

The following questions are entirely optional.

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.

Gender

Race/Ethnicity

Human Check*

Submit Application

Thanks for visiting our Career Page. Please review our open positions and apply to the positions that match your qualifications.

Database Engineer

Apply for this position