Job Description :
SQL DEVELOPER Client:DOHMH Location: Multiple JD below: Summary of Position: DOHMH seeks an experienced DOHMH-DOE Data Integration and Reporting- SQL Developer with experience integrating data, data exchange/transfer, data modeling and reporting. This consultant will support reporting on COVID-19 activity in schools and provide strategic operations reports for COVID-19 monitoring, response and prevention. Data integration will allow for determining which schools are open, their addresses, all the subsites with students, school closures. The consultant will facilitate this integration project to allow for continuous and smooth data analysis and reporting that will result in more comprehensive planning for COVID-19 prevention activities in schools. The consultant will implement a database reporting system. Specifically, the DOHMH-DOE Data Integration and Reporting- SQL Developer will: Understand Office of School Health (OSH) databases, data structure and business rules. Define protocol and data modeling for the disparate data, and maintain data to performance level, maintain data exchanges with Department of Education (DOE) utilizing web services and sFTP. Ensure data integrity of all databases. Implement data control processes and documentation. Analyze and map data from DOE, as needed. Implement work-flow processes to streamline data. Administer request processes with DOHMH Division of Information Technology (DIT) and NYC Department of Information Technology & Telecommunications (DOITT) for approval of external data exchange solutions with DOE. Understand necessary business requirements and create modern reporting system using power BI or other industry standard. Collaborate on other major data-centric projects based on need. Create ad-hoc data-centric reports as needed based on business demands. Assist with any database administrative tasks to support DOHMH Database Administrator. Advise on best practices regarding business continuity from data perspective. Advise on processes involving redundancy, data replication and database backup. Investigate and advise on new data integration and data analysis technology from an IT point of view. Qualifications and Requirements: 5 years of experience with MS SQL Server Development in .NET platform. 2 years of experience in reporting using MS Power BI. Experience setting up MS Power BI reporting projects. Experience in data modelling and data management of large systems. Experience with designing SSDT/SSIS and in particular automated integration with sFTP services. Experience with various methods of data exchange using Web services. MS SQL Server administrative experience strongly preferred. Knowledge of SQL Server back up and replication strongly preferred.
             

Similar Jobs you may be interested in ..