A government agency in Connecticut issued “Data Engineer Consulting Services” (RFP). Solicitation MGT-1258 closes on December 17, 2026. Eligibility: USA Organization. Submissions via Email.
The consultant will build on the discovery, architecture, governance artifacts, and proofs of concept completed during the prior six months and move selected components toward maintainable, production-ready implementation.
1 Mobilization and Technical Validation
• Review the existing architecture, proofs of concept, inventories, glossaries, dictionaries, classifications, lineage, quality logs, governance decisions, and roadmap.
• Validate source connectivity, credentials, environments, dependencies, and nonfunctional requirements.
• Produce a prioritized six-month delivery backlog with acceptance criteria, risks, dependencies, and an agreed release plan.
2 Data Ingestion and Pipeline Engineering
• Design, build, test, and document repeatable ETL/ELT pipelines for selected City data sources.
• Support structured, semi-structured, and file-based sources, including databases, APIs, exports, SharePoint/OneDrive files, and other approved sources.
• Implement parameterization, incremental loading where appropriate, restartability, error handling, logging, auditability, and operational monitoring.
• Preserve source-level controls and comply with City-approved handling rules for sensitive information.
3 Warehouse and Lakehouse Implementation
• Implement the approved layered architecture, including staging/raw, curated, and consumption-ready layers.
• Create and optimize tables, views, transformations, and reusable data products.
• Implement dimensional models with fact and dimension structures where appropriate, including shared conformed dimensions approved by the City.
• Establish naming conventions, schema standards, partitioning or performance practices, and technical metadata.
4 Data Quality, Governance, and Lineage
• Translate documented business rules into automated data quality checks and exception reporting.
• Maintain and extend the data dictionary, business glossary, classification, ownership matrix, lineage map, data quality issue log, and governance decision log.
• Implement role-based access and least-privilege patterns in coordination with City security and data owners.
• Document data retention, refresh cadence, reconciliation, and issue-resolution procedures for delivered data products.
5 BI Enablement
• Publish supported, documented, consumption-ready datasets or semantic models for Power BI.
• Partner with City staff to validate KPI definitions, calculations, refresh behavior, and reconciliation to source systems.
• Support one or more priority dashboards or reports sufficient to demonstrate the completed end-to-end data flow.
6 DevOps, Testing, and Operational Readiness
• Use City-approved source control and CI/CD practices for code, configuration, and deployment assets.
• Create unit, integration, reconciliation, regression, and performance tests appropriate to each pipeline and data product.
• Prepare operational runbooks covering schedules, dependencies, monitoring, alerts, failures, recovery, support ownership, and change control.
• Remediate defects identified during user acceptance testing and stabilization.
7 Knowledge Transfer and Closeout
• Conduct working sessions, code walkthroughs, and paired implementation with designated City staff.
• Deliver administrator, developer, and operator documentation.
• Provide a final backlog and recommendations for the next implementation phase, including technical debt and unresolved dependencies.
Ask any question about the RFP and its amendments. Instantly surface schedules, deliverables, compliance items, evaluation criteria, and budget details with 100% source-backed answers.
Quick answers about deadlines, eligibility and submission for this solicitation.
Proposals for MGT-1258 are due by December 17, 2026.
A government agency in Connecticut. The buyer's contact and submission details are in the solicitation documents.
USA Organization.
Submissions are accepted via Email. Follow the instructions in the solicitation documents.
Contract term: 6 months.
Questions and inquiries must be submitted by December 3, 2026.
Yes. After purchase, with a subscription or during a free trial, the RFPPlanet AI Assistant answers questions sourced from this RFP’s documents, such as requirements, evaluation criteria and key dates.
Set up free email alerts and get notified when new government and private-sector bids and tenders match your industry and location. Choose daily or weekly delivery.