search > Brooklyn jobs > Brooklyn computer/technical

Posted: Thursday, July 6, 2017 11:06 PM

SCOPE OF SERVICES: 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 DOE 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 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 Contact Details Name: Bhavik Prajapati Email :Posted by StartWire


• Location: Brooklyn

• Post ID: 117201263 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. © 2017