ETL Data Warehouse Architect

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