Sylvia Bier

Data Architect - Contract - Onsite For our direct client in the Greenwich, CT area, we seek an experienced Data Architect consultant to lead a structured data warehouse initiative. This engagement will assess current departmental data environments, design a scalable target-state architecture, and deliver a proof of concept. This is a milestone-driven project focused on roadmap design, ETL strategy, governance foundation, and executive-ready documentation to support phased implementation. Project Objectives

• Assess existing data architecture, platforms, and data flows across departments
• Design a centralized data warehouse architecture (cloud, hybrid, or on-prem)
• Define ETL/ELT integration framework to consolidate disparate data sources
• Establish foundational data governance and security model
• Deliver a proof of concept

Key Responsibilities Current-State Assessment

• Conduct interviews with data owners and technical stakeholders
• Inventory data sources, platforms, and integration points
• Identify gaps, redundancies, and risks across systems

Target-State Architecture

• Design future-state data warehouse architecture
• Define conceptual and logical data models
• Recommend tooling and platform strategy
• Outline ETL/ELT ingestion and integration patterns

Governance & Security

• Define data ownership, stewardship, and access models
• Establish data standards and governance principles
• Recommend security and risk mitigation practices

Proof of Concept & Roadmap

• Develop proof of concept integrating 2-3 departments
• Define measurable success criteria
• Deliver implementation roadmap with milestones
• Provide documentation and knowledge transfer

Required Experience

• Proven experience as a Data Architect with strong ETL/ELT expertise
• Experience designing enterprise data warehouse or lakehouse architectures
• Strong data modeling skills (conceptual & logical)
• Experience integrating legacy and modern systems
• Familiarity with modern cloud data platforms (Azure preferred)
• Experience establishing data governance frameworks
• Strong stakeholder communication and executive presentation skills

Preferred

• Experience in decentralized or multi-department environments
• Exposure to analytics modernization or AI-ready architecture planning
• Relevant cloud or data platform certifications

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Benchmark IT, LLC and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here: https://bmarkits.com/privacy-policy/