Summer Python Sql Jobs in Pennsylvania (NOW HIRING)

Title: Manager - Data Engineering
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 a results-driven Data Engineering Manager to lead the Consumer Data Engineering Team, specifically overseeing domains such as Customer, Digital/eCommerce, and Store Operations. You will lead a team of high-performing onshore engineers and offshore partners to build robust data products that drive operational efficiency. This role requires a blend of people leadership, project management, and deep domain expertise in retail operations to cultivate a sustainable, high-performance engineering culture.
What You'll Do:

• Domain Leadership: Direct oversight of the Consumer engineering teams, ensuring technical roadmaps are aligned with business priorities like customer personalization, marketing attribution, and omnichannel engagement.
• Team Management: Directly manage a team of Data Engineers, providing technical mentorship, performance management, and professional development.
• Architectural Collaboration: Partner closely with the Sr. Data Architect to ensure all domain-specific pipelines align with enterprise-wide technical standards and the Medallion architecture blueprint.
• Stakeholder Intake: Act as the primary technical point of contact for Consumer-side business leads, translating complex operational needs into actionable engineering requirements.
• Strategic Engineering Culture: Establish and maintain best practices for code quality, documentation, and automated testing to ensure the long-term sustainability of the Consumer data ecosystem.
• Product Delivery: Ensure the delivery of high-quality "Gold" layer data products within our GCP Medallion architecture.

What You Bring:

• Experience: 8+ years in Data Engineering with at least 2+ years of formal people management or team lead experience.
• Domain Expertise: Deep understanding of Customer Data (CRM, Loyalty, Customer 360), Digital/eCommerce (web/app clickstream), Marketing Analytics (attribution, campaign performance), and Store Operations.
• GCP Technical Proficiency: Hands-on experience with Google BigQuery, Cloud Composer (Airflow), and building pipelines using SQL and Python.
• Modern Modeling Knowledge: Familiarity with Dimensional Modeling (Star/Snowflake) and its application within a Medallion architecture (Bronze/Silver/Gold).
• Strategic Mindset: Strong problem-solving and systems-thinking skills with a proven ability to balance short-term execution with long-term platform health.
• Agile Methodology: Experience running high-velocity engineering sprints and managing a backlog of data product features.

Nice to Have:

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

#LI-CH1
About Us
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.