Design and implement enterprise data architecture and ETL/ELT on GCP (BigQuery). Own ingestion, transformation, modeling, orchestration, governance, and platform roadmap. Collaborate with business and BI teams, mentor engineers, drive modernization (lakehouse, data mesh, streaming), and ensure scalable, secure, high-performance data products for analytics.
Title: Data Architect
Reports To: Director - Data Engineering
Location: Pittsburgh, PA or New York, NY
American Eagle is a youth culture brand grounded in denim. Our purpose extends beyond making the best jeans–we embrace self expression, culture, optimism and connection. Through the brand platform Live Your Life, we empower our community to be who they want to be all while wearing the clothes that make them most confident.
Get to Know the Role:
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.
What You’ll Do:
- Architectural Blueprinting: Design and implement scalable data architecture, pipelines, and modeling strategies that power our enterprise data warehouse on GCP (BigQuery).
- ETL/ELT Ownership: Own the end-to-end ETL/ELT architecture, including ingestion, transformation, modeling, and orchestration.
- Business Collaboration: Partner with business leaders and the BI team to translate strategic goals into high-quality data products and analytical solutions.
- Governance & Integrity: Ensure data integrity and security by adhering to and upholding data governance, quality standards, and architectural best practices.
- Innovation & Modernization: Drive modernization efforts by researching, evaluating, and implementing emerging technologies and tools across the data ecosystem.
- Technical Mentorship: Serve as a technical mentor and guide to data engineers and cross-functional teams.
- Platform Planning: Participate in data platform roadmap planning, vendor evaluations, and tool selection.
- Efficiency: Promote reusable patterns, modular design, and automation wherever possible to ensure long-term scalability.
What You Bring:
- Experience: 10+ years in data engineering, data architecture, or data analytics roles, with a minimum of 3 years specifically dedicated to a Data Architect position. Candidates must demonstrate a proven history of designing and delivering high-performance, enterprise-scale data strategies that bridge the gap between technical infrastructure and strategic business outcomes.
- Enterprise Data Modeling: Expertise in designing and implementing enterprise data warehouses, including star/snowflake schemas and dimensional modeling techniques in a Medallion architecture.
- Modern Architecture Standards: Proven experience implementing Lakehouse patterns (specifically using BigQuery and open table formats like Iceberg), Data Mesh (domain-driven design), and real-time streaming architectures.
- GCP Ecosystem: Strong expertise in Google Cloud Platform, specifically BigQuery, Cloud Composer (Airflow), Dataflow, Pub/Sub, Cloud Storage, Slot Reservations/Workload Management.
- Languages: Expert-level SQL is required; Python proficiency is a strong plus for custom operators and advanced data processing.
- Governance: Solid understanding of data governance, metadata management, security, and compliance in cloud environments.
- Platform Thinking & Strategy: 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.
- BI Tooling: Experience working with BI tools (e.g., Tableau, Looker, AtScale, Databricks) to support self-service and enterprise reporting.
- Communication: Ability to engage with both technical and non-technical stakeholders to translate complex requirements into impactful solutions.
Nice to Have:
- Industry Knowledge: Background in the retail industry or high-volume transactional environments.
- Emerging Technology: 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).
Perks: Why You’ll Love it Here
- Generous employee discount
- Summer Fridays
- Casual dress code
- Hybrid schedule
- FOMO events (Exciting company-wide events)
Pay/Benefits Information:
- Actual starting pay is determined by various factors, including but not limited to relevant experience and location.
- Subject to eligibility requirements, associates may receive health care benefits (including medical, vision, and dental); wellness benefits; 401(k) retirement benefits; life and disability insurance; employee stock purchase program; paid time off; paid sick leave; and parental leave and benefits.
- Paid Time Off, paid sick leave, and holiday pay vary by job level and type, job location, employment classification (part-time or full-time / exempt or non-exempt), and years of service. For additional information, please click here
- AEO may also provide discretionary bonuses and other incentives at its discretion.
Get to Know AEO
American Eagle Outfitters, Inc. (NYSE: AEO) is a leading global specialty retailer with a portfolio of beloved apparel brands including American Eagle, Aerie, OFFL/NE by Aerie, Todd Snyder and Unsubscribed.
Rooted in optimism, inclusivity and authenticity, AEO’s brands empower every customer to celebrate their unique personal style by offering casual, comfortable, timeless outfitting and high-quality products that are made to last. In addition to a robust e-commerce business, we operate stores in the United States, Canada and Mexico, with merchandise available in more than 30 countries through a global network of license partners.
At AEO, we believe in the power of our people and our brands. Our Better Together culture creates a mutual desire to succeed–inspiring our community to excel, while driving future growth for the business and associates. Through experience, exposure and education we empower associates to build their unique career journey.
Inclusion, Diversity, Equity and Access at AEO
We remain committed to building an inclusive culture that is welcoming and fosters a sense of belonging for everyone. Please see more about our initiatives here.
AEO is an Equal Opportunity Employer and is committed to complying with all federal, state and local equal employment opportunity ("EEO") laws. AEO prohibits discrimination against associates and applicants for employment because of the individual's race or color, religion or creed, alienage or citizenship status, sex (including pregnancy), national origin, age, sexual orientation, disability, gender identity or expression, marital or partnership status, domestic violence or stalking victim status, genetic information or predisposing genetic characteristics, military or veteran status, or any other characteristic protected by law. This applies to all AEO activities, including, but not limited to, recruitment, hiring, compensation, assignment, training, promotion, performance evaluation, discipline and discharge. AEO also provides reasonable accommodation of religion and disability in accordance with applicable law.
Applications will be accepted until the Apply Before date (if applicable), but may be extended based on applicant volume.
American Eagle Outfitters New York, New York, USA Office
401 5th Avenue, New York, United States
Similar Jobs
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Lead enterprise data architecture across warehouses, data lakes, downstream applications, and AI workloads. Design data models, Medallion Architecture, ELT standards, semantic layers, APIs, access controls, and reusable datasets. Partner with business and BI teams to drive adoption, conduct architecture reviews, establish platform standards, and mentor data and analytics engineers. The role requires deep Snowflake, dbt, data modeling, pipeline, and semantic-layer expertise, with experience in AI data patterns and cloud infrastructure preferred.
Top Skills:
AWSAzureDatabricksDbtDelta LakeGCPGraphQLLlmsPower BIRagRestSnowflakeSnowflake Unity CatalogTableau
Information Technology
Designs and delivers Snowflake data architectures on AWS, including dbt-based data engineering and AI-enabled solutions. Leads RAG, vector search, embedding, semantic search, and analytics initiatives from proof of concept through production. Directs project teams, oversees solution quality and budgets, supports proposals and business cases, and serves as a trusted technical advisor to clients. Requires strong data engineering, governance, documentation, communication, and stakeholder-management skills, with travel as needed.
Top Skills:
AWSDbtEmbedding PipelinesGenerative AiPrompt OrchestrationRetrieval-Augmented GenerationSemantic SearchSnowflakeSQLVector Search
Information Technology
Lead client-focused MarTech and digital transformation initiatives, including cloud migrations, Adobe platform implementations, complex content and system migrations, and AI-ready data architecture. Design customer data models, identity resolution, and real-time activation pipelines while managing delivery, budgets, teams, stakeholders, and business development. Advise clients on AI-enabled marketing technology and oversee cross-functional global delivery.
Top Skills:
Adobe Experience Manager (Aem)Adobe Experience Platform (Aep)Adobe Real-Time Customer Data Platform (Rtcdp)Aem AssetsAPIsAWSCloud MigrationCustomer Data Platforms (Cdp)Generative AiGoogle Cloud Platform (Gcp)Large Language Models (Llms)AzureOracle EloquaSalesforce Data CloudSalesforce Marketing Cloud
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
