Data Architect

Socket.dev; Pittsburgh (Allegheny County); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Generous employee discount

Summer Fridays

Hybrid schedule

Casual dress code

FOMO events

Job summary

American Eagle Outfitters, Inc. is seeking a Data Architect to lead enterprise data architecture and ETL frameworks on Google Cloud Platform. You will design scalable pipelines, partner with BI teams, and drive governance and modernization across the data stack.

The role requires 10+ years in data roles with a focus on enterprise data strategies and strong SQL, BigQuery, and Lakehouse patterns. Hybrid schedule and competitive benefits offered.

Qualifications

• 10+ years in data engineering, data architecture, or data analytics with 3+ years as a Data Architect.
• Enterprise data warehouses and dimensional modeling in a Medallion architecture.
• Experience with Lakehouse patterns (BigQuery, Iceberg), Data Mesh, real-time streaming.
• Strong GCP expertise: BigQuery, Airflow, Dataflow, Pub/Sub, Cloud Storage.
• Expert SQL; Python is a plus for custom operators.
• Knowledge of data governance, metadata, security, and cloud compliance.
• Ability to align architecture with business needs and long-term health.
• Experience with BI tools for self-service and enterprise reporting.

Responsibilities

• Design scalable data architecture and pipelines for the enterprise data warehouse on GCP (BigQuery).
• Own end-to-end ETL/ELT architecture, ingestion, transformation, modeling, and orchestration.
• Collaborate with business and BI teams to deliver high-quality data products and analytics.
• Ensure data governance, quality, and security across the data platform.
• Lead modernization efforts and evaluate new technologies across the data stack.
• Mentor data engineers and guide cross-functional teams.

Skills

SQL

Python

Data Modeling

Data Architecture

Stakeholder Communication

Data Governance

Cloud Strategy

BI Tooling

Tools

BigQuery

Cloud Composer (Airflow)

Dataflow

Pub/Sub

Cloud Storage

Iceberg

Looker

Tableau

Databricks

Job description

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.
• 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 Togetherculture 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

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.