Data Warehouse Manager, ODM - 24939

NYC Department of Education; New York (NY); On-site; USD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking organization as a Data Warehouse Manager, where you will lead the oversight and implementation of database operations. This role is crucial for supporting educational initiatives within the largest public school system in the country. You will manage data quality, develop scalable data infrastructures, and ensure alignment with best practices. If you have a passion for data and education, and possess strong analytical and project management skills, this is your chance to make a significant impact in the community. Embrace the opportunity to work in a dynamic environment that values innovation and collaboration.

Benefits

Public Service Loan Forgiveness

Flexible Work Environment

Professional Development Opportunities

Qualifications

• Professional certification in database administration required.
• 2+ years of experience in database administration or equivalent education.

Responsibilities

• Design and maintain data pipelines for analytics and business intelligence.
• Implement data governance and security measures for sensitive information.
• Collaborate with analysts to understand data requirements.

Skills

Database Administration

Data Analysis

Project Management

Communication Skills

Problem-Solving

Strategic Thinking

Education

Bachelor's Degree in Computer Science

Master's Degree in Computer Science

Tools

SQL

Microsoft Power BI

Azure DevOps

Microsoft Office 365

ETL/ELT Tools

Project Management Tools

Job description

New York City Department of Education is looking for Data Warehouse Manager, ODM - 24939 in New York, NY.
This local job opportunity with ID 3102265091 is live since 2025-03-08 02:12:57.

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.
• 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:

• 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; 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 master's 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.

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).

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 (SMEs).
• 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, and 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, and 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 Monday.com.
• 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.

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.

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/