ICL

Database Developer

Job Locations US-NY-New York
Position Number
IT506901
Department
Department of Technology
Type
Regular Full-Time
FLSA Status
Exempt

Overview

Under the general supervision of the Chief Information Officer, the Database Developer’s role is to develop, evolve, manage, and support the enterprise Data Warehouse for ICL; to automate data fulfillment funding agencies; and to create dashboard and enterprise reports.

Responsibilities

  1. Develop a new SQL Server database.
  2. Migrate Microsoft Access or spreadsheet data to SQL Server.
  3. Develop SQL Server applications from EMR, Finance, and HR solutions.
  4. Develop Dashboard and Enterprise Reports for ICL.
  5. Analyze requirements and documenting use cases
  6. Perform Data Modeling
  7. Design database tables and structures
  8. Create views, functions and stored procedures
  9. Create database triggers for use in automation
  10. Write optimized SQL queries for integration with other applications
  11. Maintain data quality and oversee database security
  12. Integration with other Databases
  13. Database Optimization and Troubleshooting
  14. Database Troubleshooting
  15. Server Maintenance
  16. Write and understand Microsoft Transact SQL. Write TSQL statements, stored procedures, and views using industry best practices for security and efficiency.  Create, test, and execute SQL language code.
  17. Work with staff and academic departments to satisfy ad hoc reporting requirements, including:
    • Working with various groups to determine the exact nature of the reporting required;
    • Determining if the required data is currently being collected;
    • Determining if reports already developed will satisfy reporting requirements;
    • Using currently available reporting tools to develop, verify, and deploy new reporting.
  18. Extract, summarize, and compile data for required external reporting.
  19. Provide documentation of reports in the form of functional specifications
  20. Other job duties that are assigned.

 

Qualifications

  • Bachelor’s degree in business or computer
  • Minimum of five (5) years’ experience with Microsoft SQL Server development.
  • Hands-on knowledge of Microsoft Business Intelligence, Microsoft SQL server 2012 and
  • Knowledge of trends in computer technology relating to
  • Expert in T-SQL programming, including stored procedures, user defined functions and triggers
  • Development of secure and efficient dynamic SQL code
  • Extensive experience with
  • SQL Server Analysis Services (SSAS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.