| Data Developer, No H1B at Remote, Remote, USA |
| Email: [email protected] |
| From: Shikha, KPG99 [email protected] Reply to: [email protected] Hi, Hope you are doing well. Please find the job description below and let me know your interest. Position: Data Developer, No H1B Location: Hybrid in Brooklyn, NY Duration: 6+ Months MOI: Phone and Video 4 + years of exp JOB DESCRIPTION OUTLINE OF RESPONSIBILITIES With guidance from project managers: Manipulate, organize and report on large datasets. Write, maintain, execute, and automate the execution of code required for project needs. Build and execute SSIS packages. Collaborate with other programmers and analysts while also completing workstreams independently. Clearly communicate and document technical work, including coding methodology. Create processes that improve scalability, accuracy, and automation of technical aspects of OPEs information architecture. Technologies:SQL, other scripting language (SAS, R, and/or Python) MANDATORY MINIMUM QUALIFICATIONS The successful candidate must have minimally achieved the following level of experience: 4 years of expertise in SQL, particularly Microsoft SQL Server. 4 years of expertise in another scripting language SAS, R, and/or Python Overview The Office of Policy and Evaluation (OPE) requires IT professional services to support day-to-day needs for critical business functions and objectives. State-mandated and collectively bargained educator evaluation programs and high-priority projects for senior leadership depend on legacy applications and require specialized skill sets not readily available in sufficient quantity internally. Requested resources will focus on the technical development, testing, compliance, and final rollout of data infrastructure and sustained extract-transform-load (ETL) procedures that support school, field, and community-facing products as well as the implementation of system updates and resource revisions to support an integrated and coherent student support model across districts. This will allow OPE to measure, analyze, interpret, and present findings on academic progress and learning experiences with a focus on special populations such as students with disabilities, multilingual learners, and students in temporary housing. OPE requires IT professional services to support day-to-day needs for critical business functions and objectives for OPE applications. Data Developers will lead the effort to build and maintain complex, large datasets for use in OPE products and analyses. Outputs will include initial conceptual solution designs for relational databases and execution thereof, the development, scheduling, and regular execution of ETL packages (e.g., stored procedures and SSIS packages) to populate and maintain databases over time, modifications and troubleshooting as needed based on evolving business requirements, documentation of data models and execution plans, optimizing performance of jobs, and related tasks. Project Goals for this contract include: Database maintenance and development related to: o Mandated Teacher Effectiveness Ratings: Advance and Overall Rating Report. Consistent with State Education Law 3012-d and agreements between the DOE and the United Federation of Teachers (UFT), eligible teachers receive a Measures of Teaching Practice (MOTP) score and rating and a Measures of Student Learning (MOSL) score and rating. Each teacher then receives an Overall Rating based on the combination of their MOTP and MOSL rating. o Student Performance Analysis: As part of the DOEs Academic Recovery Plan, the department is set to engage in a deep exploration of student data, including data from newly administered assessments, on an ongoing basis in order to know how each of its students is doing, identify trends across groups of students, and target support effectively to support recovery from trauma from the COVID-19 pandemic. As a part of this work, OPE will ingest and transform data, and design, write, and update tables and views across multiple databases, among other tasks. o Leadership Dashboards: To support a timely, comprehensive, and actionable understanding of schools throughout NYC as well as to monitor progress on key Chancellors Initiatives, dashboards are built using a combination of back[1]end data development and front-end data presentation tools. The resulting dashboards provide a mix of periodic data and daily data for consumption by the Chancellor, the Cabinet, Superintendents, their teams, and others. Keywords: rlang information technology New York |
| [email protected] View all |
| Tue Aug 29 23:02:00 UTC 2023 |