Data Warehouse Manager, ODM - 24939

Position Summary: The New York City Public Schools (NYCPS) system is the largest in the country, composed of approximately 1 million students and 75,000 teachers in over 1,800 schools. The Office of Data Management (ODM) is part of the Office of Policy and Evaluation (OPE). OPE is the primary source of data analysis, research and academic policy for the NYCPS. ODM is the business intelligence unit of the NYCPS. ODM oversees academic data, project manages critical state and federal reporting work streams and ensures that the NYCPS’s reporting reflects educational policies and practices at the City, State & Federal levels. ODM leverages the data and reports managed by the NYCPS to deliver information back to NYCPS stakeholders to support decision-making and planning. ODM is also advancing the NYCPS’s use of data by leading in the design and implementation of next generation data structures and establishing an enterprise data governance framework that supports shared meaning and interpretation of data.

The Data Warehouse Manager, Data Architecture, is responsible for the oversight, implementation and monitoring of database operations, data processing and quality management initiatives. The Data Warehouse Manager will work directly with the Executive Director, Office of Data Management and the Director, Data Architecture, Office of Data Management, serving as a strategic manager and technical expert for the ODM team to support key NYCPS programs and initiatives. Performs related work.

Reports to: Director, Data Architecture, ODM

Direct Reports: N/A

Key Relationships: Executive Director, Office of Data Management; Director, Information Management and Support; Deputy Director, Information Management and Support; Analysts, Information Management and Support; Works closely with the Division of Instructional and Information Technology, the Office of Academic Policy & Systems, the Research & Policy Support Group, the Office of Assessment and the Office of School Performance.

Responsibilities

• Design, develop and maintain scalable data pipelines and infrastructure to support advanced analytics and business intelligence needs.
• Ensure data architecture aligns with industry best practices and organizational goals.
• Develop project analyses and programming routines using structured query language (SQL) and other analytical tools.
• Integrate data from various sources, ensuring data quality, consistency and reliability.
• Develop and maintain ETL/ELT processes to facilitate data movement and transformation.
• Implement data governance and security measures to protect sensitive information.
• Review and evaluate local, state and federal education policies that impact the rules and processes for collecting and reporting data.
• Work closely with data analysts, data scientists, business intelligence developers and business stakeholders to understand data requirements and deliver optimal solutions.
• Troubleshoot and resolve data-related issues promptly and effectively.
• Implement work plans and project schedules based on the scope and time frames set by the team leader, external and internal clients and other stakeholders; liaise between IT and business units.
• Quickly assess and resolve complex issues using sound judgment and problem-solving skills.
• Issue range from data management to customer service.
• Use Azure DevOps daily to provide project updates and track progress on all assigned work.
• Stay current with the latest trends and advancements in data engineering and cloud technologies.
• Evaluate and integrate new tools and technologies to enhance data infrastructure and data management capabilities.
  
  

Qualification Requirements

Minimum

Required

Professional/vendor certification(s) in database administration that is required for the position to be filled. In addition, all candidates must have the following:

• A baccalaureate degree from an accredited college and two years of satisfactory full‐time (not classroom based) experience in database administration planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement and security management; or
• A four‐year high school diploma or its educational equivalent and six years of satisfactory full‐time (not classroom based) information technology experience of which at least 2 years must have been database administration experience as described in ʺ1ʺ above; or
• A satisfactory equivalent of education and/or experience equivalent to “1” or “2” above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from an accredited college is equivalent to 6 months of general information technology experience; but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full‐time (not classroom based) database administration experience as described in ʺ1ʺ above.
  
  

Note: In addition to meeting the minimum Qualification Requirements: Incumbents may be required to update existing and/or obtain additional professional industry‐standard certification(s) for current and future technical environment(s) in which they may be assigned to work, as determined by the employing agency

Preferred

• Proven experience in a senior data engineering role with an understanding of cloud-based platforms.
• Demonstrated experience in data analytics, data reporting, and/or data management.
• Demonstrated experience gathering business requirements from business owners, program offices, and/or subject matter experts (SME's).
• Demonstrated experience designing and executing quality assurance tests.
• Proven ability to perform independent research, data collection and analysis.
• Excellent written and spoken communication skills.
• Experience writing technical and user documentation, business requirements documents, standard operating procedures.
• Strong strategic thinking and project management skills, attention to detail and ability to proactively identify key issues and risks.
• Highly proficient in Microsoft Office 365 applications including Excel, Word, OneDrive, SharePoint, Teams, Visio.
• Ability to work independently, adapt quickly to changing priorities.
• Prior experience working in a fast-paced, complex working environment.
• Excellent command of structured query language (SQL) and understanding of relational databases.
• Knowledge of Business Intelligence Reporting tools such as Microsoft Power BI, Tableau, and/or SAS.
• Experience using project management tools such as Azure Boards, Trello, Jira, Asana and Mondaydotcom.
• Experience working with data integrity and improving processes for increased data quality.
• Knowledge of best practices in data governance, analysis and reporting.
• Working knowledge of the public sector and/or demonstrated interest in public education.
• Excellent interpersonal skills in working with technical and non-technical personnel.
  
  

Salary: $96,106 - $105,717

(Internal candidates who are selected for this position and who currently hold comparable or less senior positions within the DOE will not earn less than their current salary.)

Please include a resume and cover letter with your application.

NOTE: The filling of all positions is subject to budget availability and/or grant funding.

• New York City Residency is NOT Required *
  
  

We encourage all applicants from the New York City tri-state area to apply.

AN EQUAL OPPORTUNITY EMPLOYER

DOE Non- Discrimination Policy

The Department of Education of the City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment upon any legally protected status or protected characteristic, including but not limited to an individual's actual or perceived sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, gender identity, veteran status, or pregnancy. For more information, please refer to the DOE Non-Discrimination Policy.

Public Service Loan Forgiveness As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education's website at https://studentaid.gov/pslf/.