• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 20th Feb 2024

Top Must Have Skills: 
1.    10+ years of Enterprise Data Warehouse experience 
2.    5+ years of experience with an ETL product (SSIS, Ab Initio, etc) in a development role (administrative knowledge a plus) 
3.    REST APIs development experience 
4.    Experience with C#, Python, Java 

 
Notes from Manager:
Overview:
CPS seeks a senior skilled resource to support increased operational and project demand. The resource needs expertise in application and database development in addition to CPS or large school district knowledge. We specifically need someone with the following knowledge and skills. Data Modeling, Database development, Dashboard and Reports Development. Developing matching procedures. Application Development, Writing SQL scripts to extract data from the Aspen Student Information system. MS Power BI administration and development, Dashboard administration and development. REST APIs development experience. SSIS, Ab Initio, C#, Python. Database and ETL performance tuning and optimization. Compliance Reporting (State and DOF). This is a full-time remote (9 am - 5 pm, M - F, CST) position. Vendors in good standing (fully executed contract and an active CPS vendor number) may submit 1 candidate's resume for consideration. This engagement has the potential to be extended, based on priorities and resources within the District.

Objectives:
• Efficient Data Integration - Create efficient Data Integration to integrate data from various sources that is accurate, reliable, and consistent.
• Timely Delivery - Ensure data is delivered on time to downstream systems, vendors and partners and any delays are addressed promptly.
• Data Quality - Data processed must be accurate, complete, and consistent.
• Performance Optimization - ETL routines need to be optimized to ensure the nightly cycle completes before the start of school and reports and dashboards should return data within five seconds.
• Scalability - ETL processes should be built to scale as the volume of data increases over time.
• Security - All code and processes developed must adhere to the district data security standards.
• Transition to Full Time Employees - ETL routines and code developed should follow a standard framework to facilitate transition to CPS Data Solutions team. All new code and code changes should be documented following the established documentation standard.
• Code development, testing and deployment - All production changes must follow the Change Advisory Board process.
• Codebase must be tracked and managed through the team’s code repository.

Scope:
Maintain and manage the existing CPS Enterprise Data Warehouse and ODS builds.
• Model extensions to the existing Data Warehouse.
• Builds ETL components according to ETL specifications. Code must address performance, dependency, auditing, error handling and data quality issues.
• Support post deployment by debugging, fixing, and participating in maintenance.
• Create reports to meet business requirements and address data needs.
• Create Dashboard pages and metrics within CPS custom dashboard solution.
• Responsible for data integrity as well as the quality of data within the Dashboard presentation layer.
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot code-related issues; and review and provide feedback to the final user documentation.
• Read and understand business requirements, write functional requirements, develop detailed technical designs, and build / unit / system test ETL code.
• Keep the team up to date on emerging technology trends that will enhance data quality, offer predictive analytics
• and bolster security in data integration. (cloud-based integration, iPaaS,
• Advanced machine learning and AI Integrations etc.

Outcomes:
• On time completion of the nightly ETL cycle.
• Extract actionable insights from district data to enable data-driven decision making.
• Optimal and secure storage of district data in the data warehouse.
• Data integrated from student information systems, learning management systems and ancillary
• databases support academic planning, student performance analysis and institutional reporting.
• Accurate and timely submission of State and DOE compliance reports.
• Projects completed on time and meeting business requirements and expectations.
• Code and processes created are fully documented and transitioned to the operational team.

Performance Milestones:
• Selective Enrollment Process Reengineering August 2024
• Create Summer School Dashboards by May 2024
• Year End Processing by June 2024 • Start of School Reporting August 2024
• Advises on and assists with cloud migration of ETL hardware by end of April 2024
• Maintains Power BI Data Gateway monthly
• Makes changes to OneRoster formats as required.
• Builds API integration between SalesForce and data warehouse May 2024
• Complete duplicate student ID resolution project June 2024
• Completes Schoolinks data integration project June 2024
• Other ad hoc projects as required

Deliverables:
• Selective Enrollment vendor onboarding
• Summer School configuration
• Year End Processing
• Start of School Reporting
• Cloud migration of ETL hardware
• Power BI Data Gateway maintenance
• OneRoster formats changes
• API integration between SalesForce and data warehouse
• Duplicate student ID resolution project
• Schoolinks data integration project
• Documentation of projects and code
• Projects and code transitioned to CPS operational team.