Home > Brooklyn jobs > Brooklyn computer/technical

Posted: Saturday, December 30, 2017 5:44 AM

A NYC agency located in Brooklyn, NY is looking for a Data Manager/SQL Programmer for an 18 month contract. The consultant will be performing as a member of an Agile development team, this position is responsible for developing and continually refining the reporting infrastructure required for operational reporting, data analytics, and business intelligence.Responsibilities include: * Create and implement the data models and database designs required to support the growing operational reporting needs of the division. * Independently design, develop and implement databases and/or data marts that will be used to feed operational dashboards on a daily, weekly and monthly basis. * Participate in database programming and data extraction, transformation and loading of data for custom reporting applications or enhancements to systems. * Extract and transform data from multiple internal systems into a consolidated database that will be used for MIS reporting, dashboards and analytical modeling. * Ensure that all database designs conform to appropriate data modeling standards, guidelines, internal best practices and approved modeling techniques and approaches. * Interface with users, sponsors and all other stakeholders in order to determine and plan for evolving data requirements. * Liaise with the all other data management groups within the agency to ensure that there is consistency with existing systems and that minimum reporting standards are met. * Actively participate in working sessions to help define system requirements pertaining to the design and building phases for all data related systems. * Assist in maintaining an enterprise-level data dictionary by documenting all entities, their relationships and all relevant attributes for all reporting systems designed to support the Special Education Office. * Perform complex analysis of data emanating from multiple source systems used to support special education reporting. * Lead data mapping efforts between SESIS and other existing data sources. * Ad-hoc reporting.Mandatory Skills/Experience: Note: candidates who do not have the mandatory skills will not be considered. * A baccalaureate degree from an accredited college and four (4) years of full-time paid experience in the fields of operations management, computer science, mathematics, statistics or a related field; or A satisfactory combination of education and experience. * Advanced SQL development skills: SSIS, SSRS, SSAS. * Demonstrated success in building and implementing databases and data marts for operational, analytical and/or dashboard reporting. * Conceptual, logical and physical data modeling experience. * Relational data modeling; Data modeling tools. * Ability to work with database administrators, application designers and developers, business analysts and end-users to define the informational needs of the organization. * Demonstrated experience in data mapping and data conversion. * Comfortable navigating large quantities of data. * Strong analytical, conceptual, problem solving and trouble shooting skills.Desirable Skills/Experience: * Experience in performing data analytics, data modeling and testing activities in a large data project. * Demonstrated experience in building service-oriented relationships and providing successful consultative support. * Technical writing skills * Requirements management * Business intelligence analysis - provided by DiceData Manager/SQL Programmer


• Location: Brooklyn

• Post ID: 152512752 brooklyn is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2018