Job Location: Available to
work Hybrid, Brooklyn, NY.
Job Description:
OUTLINE OF
RESPONSIBILITIES
- Capable of critically evaluating data to derive meaningful,
actionable insights.
- Adept at queries, report writing, and presenting findings.
- Use statistical and data management software to develop and
manipulate large datasets for external and internal NYCDOE partners.
- Assist in the planning, development, and administration of
academic data collection and reporting systems that fulfill state and federal
requirements
- Review and evaluate local, state, and federal education policies
that impact the rules and processes for collecting and reporting data
- Liaise between program offices and technical partners to develop
business rules for transforming and reporting data including and not limited to
teams from the Division of School Leadership, the Division of Multilingual Learners,
the Division of Specialized Instruction and Student Support, the Division of
Early Childhood Education, and the Division of Inclusive and Accessible
Learning.
- Provide technical assistance in academic program development and
evaluation through data by documenting stakeholders, business rules,
requirements, processes, and outcomes
- Develop project analyses and programming routines using structured
query language (SQL) and other analytical tools.
- Based on analysis, provide validation and quality assurance
support
- 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
- Participate in the solution design to ensure consistency between requirements
and specifications.
- Quickly assess and resolve complex issues using sound judgment and
problem-solving skills.
- Provide regular status reports as required to ODM leadership;
represent the data management team by working cross functionally with ODM
colleagues and program offices.
Use
Azure Dev Ops daily to provide project updates and track progress on all
assigned work
REQ SCOPE
- 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
- Excellent command of structured query language (SQL) and
understanding of relational databases
- Experience working with data integrity and improving processes for
increased data quality
- Data Modeling
- T-SQL
- SQL Queries
- Azure DevOps
- Data Analysis
- Microsoft SQL Server
- SSIS
- Data Quality Assurance
Requirements
Skills Set:
Skill
| Required /Desired
| Experience
|
experience and expertise in data
modeling for data warehouse and data mart
|
| 2 years
|
experience writing complex Stored
Procedure and Functions in T-SQL
|
| 2 years
|
experience as a Data Analyst or related role
|
| 2 years
|
experience in education policy and/or education administration
in an urban public school district, preferably in NY
|
| 2 years
|
experience with the Office of Civil
Rights (OCR) Civil Rights Data Collection (CRDC), including data
quality reviews
|
| 6 months
|
experience with the NYSED Student Information Repository
System (SIRS), including data verifications, Level 0 historical
updates, L2RPT reports, etc
|
| 6 months
|
Working knowledge of importing flat
files into SQL environments
|
| 6 months
|
Experience with Microsoft SQL
Integration Services (SSIS)
|
| -
|
Experience using Azure DevOps
|
| -
|
Experience writing technical and
user documentation, business requirements documents, standard operating
procedures
|
| -
|
Programming language expertise outside of SQL (e.g. Python,
R)
| Preferred
| -
|
A background in the provision of technical support or customer
service
| Preferred
| -
|
Comfort presenting technical information to a non-technical
audience
| Preferred
| -
|
A quick learner; self-directed; excellent problem-solving skills
| Preferred
| -
|
Ability to quickly and efficiently switch focus among multiple
concurrent tasks
| Preferred
| -
|
Demonstrated experience in data analytics, data reporting,
and/or data management
| Preferred
| -
|