| urgent role::Junior Data Developers (face to face interview) at Remote, Remote, USA |
| Email: [email protected] |
| From: Saurabh Kesarvani, TEK Inspirations LLC [email protected] Reply to: [email protected] Title: Junior Data Developers (face to face interview) Interview Type Requested: In person, WebEx (Please provide three references.) Job Description: Overview 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: 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. 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. Leadership Dashboards: To support a timely, comprehensive, and actionable understanding of schools throughout Client as well as to monitor progress on key Chancellors Initiatives, dashboards are built using a combination of back- 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. 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. Regards, Saurabh Kesarvani Technical Recruiter | IT Healthcare & Informatics TEK Inspirations LLC 13573 Tabasco Cat Trail, Frisco, TX 75035 Email: [email protected] Keywords: rlang information technology Texas |
| [email protected] View all |
| Sat Aug 26 01:12:00 UTC 2023 |