Role: ETL / Data Warehouse Architect
Location: Stamford, Connecticut
Duration: 3 months
Purpose: To provide a data architect to develop a plan/ roadmap to create a data
warehouse to Extract, Transform and Load (ETL) individual department data sets to a single
platform and begin to leverage structured data to make data driven decisions. The Architect will
also develop a proof of concept with 2 departments and provide step by step process for adding
additional departments to the data warehouse.
The purpose is to engage a technology firm that can provide a data architect to
develop a plan/ roadmap to create a data warehouse to Extract, Transform and Load (ETL)
individual department data sets to a single platform and begin to leverage structured data to make data driven decisions. The Architect will also develop a proof of concept with 2 departments and provide step by step process for adding additional departments to the data warehouse.
Scope of Work
The selected vendor/consultant will be expected to perform the following services:
Assess current data architecture, platforms, and data flows
Design target-state data architecture (e.g., cloud, hybrid, or on-prem)
Define data models, integration patterns, and governance frameworks
Recommend tools, technologies, and best practices
Conduct interviews with data owners/ data custodians in various departments including Engineering, Public Safety, Data Analytics, Operations, and Technology teams
Provide implementation roadmap and technical documentation
Deliverables
Current-state and target-state AI-ready (BI/ ML) architecture diagrams
Data architecture standards and design principles
Technology and tooling recommendations
Implementation roadmap with milestones. Final architecture documentation and
knowledge transfer
Project will commence approximately April 1, 2026 and it is anticipated that a final
report will be issued July 1, 2026
Proven experience as a Technology/Data Architect with specific expertise in ETL
Expertise in modern data platforms (e.g., cloud, data lakes, data warehouses)
Experience with data governance, security, and compliance
Strong communication and stakeholder engagement skills
Relevant certifications or case studies (preferred)
Proposals will be evaluated based on:
Technical expertise and experience 30
o Proven experience in data architecture and ETL
o Familiarity with modern data platforms (cloud, data lakes, warehouses)
Approach & Methodology 20
o Clear roadmap for data warehouse and ETL integration
o Feasibility of proof of concept and phased rollout
Security & Governance 20
o Data governance framework and compliance readiness
o Security best practices and risk mitigation
Cost & Value 15
o Competitive pricing and transparent cost structure
o Value for proposed deliverables
References and past performance 15
o Relevant case studies or client references
o Successful similar projects