Data Engineer

COMPANY SUMMARY

Empire State Realty Trust, Inc. (NYSE: ESRT) is a NYC-focused REIT that owns and operates a portfolio of well-leased, top of tier, modernized, amenitized, and well-located office, retail, and multifamily assets. ESRT’s flagship Empire State Building, the “World's Most Famous Building,” features its iconic Observatory, ranked the #1 Top Attraction in New York City for the fourth consecutive year in Tripadvisor’s 2025 Travelers’ Choice Awards:
Best of the Best Things to Do. The Company is a recognized leader in energy efficiency and indoor environmental quality. As of September
30, 2025, ESRT’s portfolio is comprised of approximately 7.8 million rentable square feet of office space, 0.8 million rentable square feet of retail space and 743 residential units. More information about Empire State Realty Trust can be found at  and by following ESRT on Facebook, Instagram, Tik Tok, X, and Linked In.

The dedicated team at ESRT is a collection of diverse individuals with a shared passion for excellence and a keen eye toward future growth. Headquartered in New York City, we harness the energy of the city in everything we do. We care for one another, work hard, and have a lot of fun doing it! We are Certified™ as a Great Place to Work® by the global authority, Great Place to Work®, on workplace culture, employee experience, and leadership behaviors.

We prioritize and invest in the health and wellness of employees to attract, develop, and retain top-tier talent. ESRT values continuous employee development and encourages colleagues to excel in their roles and adapt to emerging business needs. From our crown jewel, The Empire State Building, to incredible buildings modernized for the 21st century, to outstanding customer service, and our decade-long leadership position in sustainability and energy efficient portfolio that is 100% fully powered by renewable wind electricity, we take pride in our work.

ESRT seeks an equally passionate colleague to join the team, understand the vision and help achieve that vision.

The Data Engineer will be responsible for designing, building, and supporting enterprise-wide AI and automation initiatives that improve and drive business efficiency, insight, and innovation. This role blends technical expertise in data engineering and AI integration, back-end development and automation with hands‑on collaboration across business, analytics, and IT teams.

Reporting to the Director of Application & Development, this position will support and enhance initiatives involving Informatica data pipelines, API integrations, Lakehouse data architecture, and AI‑driven capabilities—including model deployment, virtual assistants, and workflow automation. This position works closely with business, analytics, and IT teams to deliver scalable, high‑quality data and AI solutions across ESRT’s corporate and property operations.

• AI AND AUTOMATION DEVELOPMENT:
• Design, build, and deploy AI‑driven solutions using Python, APIs, and enterprise platforms (e.g., ChatGPT, Agentforce, internal automation tools, Agentic AI Assistance)
• Partner with business and analytics teams to identify and prioritize automation opportunities that streamline workflows and enhance decision‑making
• Integrate AI capabilities into existing enterprise systems and applications to improve operational efficiency

• DATA LAKE AND INFORMATICA MANAGEMENT:
• Develop, maintain, and optimize data pipeline, ETL workflows and integrations using Informatica, Azure Services, Microsoft Fabric, and Semantic Models for Power BI to ensure accurate, timely, and reliable data ingestion and transformation
• Manage the enterprise Data Lake Architecture to support analytics, reporting, and AI model training, including ingestion, transformation, and overall data management
• Uphold data governance standards, including lineage tracking, data quality, and documentation
• Working knowledge of the Medallion Data Architecture

• INTEGRATION ENGINEERING:
• Build and maintain integrations between applications, databases, and cloud platforms using APIs, middleware, and native connectors (e.g., REST/Graph
  
  QL API)
• Optimize data flow between…