Sr. Data Warehouse Architect

Sr. Data Warehouse Architect (260000GA)

• Medical, dental, and vision plans with no‑cost and low‑cost options
• Annual employer HSA contribution
• 401(k) matching and immediate vesting
• Vehicle purchase and lease discounts, plus monthly vehicle allowances by job level:
  • Associate / Sr. Associate: $350
  • Director: $800
  • Executive Director: $900
  • VP or Above: $1,000
• 100% employer‑paid life and disability insurance
• No‑cost health and wellbeing programs, including a gym benefit
• Six weeks of paid parental leave
• Paid Volunteer Time Off, plus a company donation to a charity of your choice

The Sr. Data Warehouse Architect defines and governs enterprise data architecture across data warehouse, transactional, analytical, and near‑real‑time environments. This role leads complex architecture decisions, establishes enterprise standards, and ensures scalable, secure, and high‑performing data solutions aligned with business, technology, and regulatory requirements.

• Define and evolve enterprise data architecture, target‑state designs, and integration patterns across warehouse, lakehouse, transactional, and analytical platforms.
• Lead architecture decisions for complex, cross‑functional initiatives to ensure solutions are scalable, secure, resilient, and aligned with business and technology strategy.
• Establish standards for data modeling, storage design, integration patterns, and workload optimization across enterprise data domains.
• Evaluate and recommend technologies, tools, and frameworks that improve performance, flexibility, cost efficiency, and long‑term maintainability.
• Serve as the senior architectural advisor to engineering, analytics, and business stakeholders on high‑impact platform and design decisions.

• Design architecture for near‑real‑time and streaming data solutions that support time‑sensitive operational and analytical use cases.
• Define architecture patterns for event‑driven processing, change data capture, and hybrid batch/streaming data flows.
• Lead design of cloud‑based data platforms using AWS services to support scalable and reliable data delivery.
• Establish standards for streaming, schema management, and processing models to support performance, consistency, and reuse.
• Resolve complex technical issues and architectural tradeoffs involving latency, reliability, scalability, and interoperability.

• Define and enforce enterprise data architecture standards, naming conventions, metadata management practices, and data lineage requirements.
• Partner with governance, security, compliance, and risk teams to ensure architectures align with enterprise controls and regulatory requirements.
• Establish frameworks that promote data quality, consistency, traceability, and trusted use of enterprise data.
• Support architecture decisions related to platform modernization, data lifecycle management, privacy, and control environments.

• Minimum 8 years progressive experience in data architecture, data engineering, or related technical roles.
• Experience designing enterprise data warehouse, transactional, analytical, and near‑real‑time data architectures.
• Strong hands‑on experience with AWS data services, including Redshift, RDS, S3, Glue, Apache Iceberg, Lake Formation, Athena, and related tools.
• Experience with Oracle and relational database design in complex enterprise environments.
• Experience designing streaming and near‑real‑time data architectures using Kafka, Kinesis, or similar technologies.
• Experience working in enterprise‑scale cloud data environments within regulated industries.
• AWS certification(s) such as Solutions Architect, Data Analytics, or Database Specialty.
• Familiarity with CI/CD, infrastructure‑as‑code, and modern data platform delivery practices.
• Experience with event‑driven microservices architectures and schema registries (Glue Schema Registry, Confluent Schema Registry).
• Experience with BI/reporting tools (OBIEE, Tableau, or similar).
• Bachelor’s degree in Computer Science, Engineering, Technology or a related discipline.
• St…