Data Architect

American Eagle Outfitters•Pittsburgh, PA

4d•Hybrid

About The Position

We are seeking an experienced Data Architect to lead the design and implementation of our enterprise data architecture and ETL frameworks supporting our modern data warehouse in Google Cloud Platform (GCP). You will play a pivotal role in shaping our data strategy, ensuring scalable, reliable, and secure solutions that empower business users and analysts to deliver actionable insights. This role sits at the intersection of architecture, engineering, and business, collaborating closely with business stakeholders, product managers, and the business intelligence team to enable strategic analytics and decision-making across the organization.

Requirements

10+ years in data engineering, data architecture, or data analytics roles, with a minimum of 3 years specifically dedicated to a Data Architect position.
Proven history of designing and delivering high-performance, enterprise-scale data strategies that bridge the gap between technical infrastructure and strategic business outcomes.
Expertise in designing and implementing enterprise data warehouses, including star/snowflake schemas and dimensional modeling techniques in a Medallion architecture.
Proven experience implementing Lakehouse patterns (specifically using BigQuery and open table formats like Iceberg), Data Mesh (domain-driven design), and real-time streaming architectures.
Strong expertise in Google Cloud Platform, specifically BigQuery, Cloud Composer (Airflow), Dataflow, Pub/Sub, Cloud Storage, Slot Reservations/Workload Management.
Expert-level SQL is required.
Python proficiency is a strong plus for custom operators and advanced data processing.
Solid understanding of data governance, metadata management, security, and compliance in cloud environments.
Proven ability to balance immediate business delivery with long-term architectural health; a strategic thinker who can navigate complex stakeholder requirements to build scalable, future-proof data platforms.
Experience working with BI tools (e.g., Tableau, Looker, AtScale, Databricks) to support self-service and enterprise reporting.
Ability to engage with both technical and non-technical stakeholders to translate complex requirements into impactful solutions.

Nice To Haves

Background in the retail industry or high-volume transactional environments.
Familiarity with or vision for integrating Generative AI into data engineering workflows (e.g., using LLMs for SQL generation, automated metadata documentation, or synthetic data creation).

Responsibilities

Design and implement scalable data architecture, pipelines, and modeling strategies that power our enterprise data warehouse on GCP (BigQuery).
Own the end-to-end ETL/ELT architecture, including ingestion, transformation, modeling, and orchestration.
Partner with business leaders and the BI team to translate strategic goals into high-quality data products and analytical solutions.
Ensure data integrity and security by adhering to and upholding data governance, quality standards, and architectural best practices.
Drive modernization efforts by researching, evaluating, and implementing emerging technologies and tools across the data ecosystem.
Serve as a technical mentor and guide to data engineers and cross-functional teams.
Participate in data platform roadmap planning, vendor evaluations, and tool selection.
Promote reusable patterns, modular design, and automation wherever possible to ensure long-term scalability.