Data Management Analyst (Programmer I) in 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.

MANDATORY MINIMUM QUALIFICATIONS 

The successful candidate must have minimally achieved the following experience: 

• 2 years of experience and expertise in data modeling for data warehouse and data mart
• 2 years of experience writing complex Stored Procedure and Functions in T-SQL
• 2 years of experience as a Data Analyst or related role
• 2 years of experience in writing Microsoft SQL Server queries 
• 6 months of experience in education policy and/or education administration in an urban public school district, preferably in NY
• 6 months of experience with the Office of Civil Rights (OCR) Civil Rights Data Collection (CRDC),  including data quality reviews
• 6 months of experience with the NYSED Student Information Repository System (SIRS), including  data verifications, Level 0 historical updates, L2RPT reports, etc.
• Working knowledge of importing flat files into SQL environments
• Experience with Microsoft SQL Integration Services (SSIS)
• Experience using Azure DevOps
• Experience writing technical and user documentation, business requirements documents, standard operating procedures

PREFERABLE QUALIFICATIONS 

• Programming language expertise outside of SQL (e.g. Python, R). 
• A background in the provision of technical support or customer service.   
• Comfort presenting technical information to a non-technical audience.   
• A quick learner; self-directed; excellent problem-solving skills.   
• Ability to quickly and efficiently switch focus among multiple concurrent tasks.   
• Demonstrated experience in data analytics, data reporting, and/or data management

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

Rangam Consultants is a minority, women-owned, disability workforce solutions global organization. We specialize in attracting and retaining talent globally for rewarding careers in IT, Engineering, Scientific, Clinical, Healthcare, Administrative, Finance, Business Management, and many more, while integrating veterans and individuals with disabilities into the workforce. Indeed, we connect career aspirants to relevant job opportunities, whether in the USA, UK, India, or Ireland. Additionally, we offer Location Independent jobs and contract positions across different verticals and industries.
Rangam strives to put job seekers first, providing them with free access to search for jobs, post resumes, and research companies. Every day, we connect millions of people to new opportunities.