Required Skills

SSIS Ab Initio C# Python Java

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 20th Feb 2024

JOB DETAIL

• 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.

Company Information