SW-116644 - USA (Pennsylvania) - Coding and Automation Services - Deadline August 17,2026

(1) Vendor needs to provide coding and automation services. 1) Discovery, scheduling, and requirements confirmationa) Confirm reporting cycles, snapshot/census logic, submission deadlines, and timing dependencies that drive each file’s extraction schedule.b) Confirm scope, project cadence, communication plan, and environment access requirements.c) Establish deliverable acceptance criteria and milestone–based completion checkpoints aligned to fixed–price execution2) Source mapping and technical specificationsa) Map field sources, technical specifications, business rules, transformations, and example values for all required files.b) Document Banner and third–party sources where relevant3) Insights data lake assessment and configurationa) Assess data availability and alignment in the PASSHE Insights Parent Data Lake and each institution’s Child Data Lake(s).b) Configure required mappings/crosswalks and standardized output structures needed for automated extraction.4) build, automation, and audit/error logginga) Develop processes to extract, transform, and generate each output file with automated scheduling.b) Build automated audit/error outputs aligned to error definitions for each file.5) Parent data lake pull validation and multi–institution standardizationa) Validate that Parent Data Lake ingestion can automatically retrieve, store, and align audit datasets produced in Child Data Lakes.b) Confirm cross–institution repeatability and consistency (common patterns, metadata, and scheduling).(2) A pre–proposal conference will be held on July 30,2026.(3) All question must be submitted no later than August 3, 2026.