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 Observation Deck, ranked the #1 Top Attraction in New York City for the fifth consecutive year in Tripadvisor’s 2026 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 March 31, 2026, ESRT’s portfolio is comprised of approximately 8.0 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 esrtreit.com and by following ESRT on Facebook, Instagram, TikTok, X and LinkedIn.
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.
POSITION SUMMARY
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.
RESPONSIBILITIES 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/GraphQL API)
Optimize data flow between operational, analytical, and AI systems to ensure scalability, performance, and security
Collaborate with IT and application teams to standardize integration patterns and enforce governance
REPORTING AND ANALYTICS ENABLEMENT:
Curate and publish high-quality datasets for analytics and visualization tools such as Power BI, including developing and maintaining semantic models and enterprise data schemas
Partner with business stakeholders to translate requirements into actionable data models and AI workflows
Enable self-service analytics and enhance business intelligence capabilities across the enterprise
GOVERNANCE, SECURITY, & DOCUMENTATION:
Maintain clear and up-to-date documentation for technical specifications, data flows, integration architecture, and AI models
Enforce compliance with data security, access control, and governance frameworks
Implement monitoring and alerting for data quality, pipeline performance, and AI model accuracy
Adhere to Project Management Office (PMO) best practices
Support overall data governance, privacy, cybersecurity, and responsible AI practices
WHAT SUCCESS LOOKS LIKE Drive enterprise-wide applications to operate within a cohesive, data-driven framework that advances company-wide goals, with a focus on leasing space, selling Observatory tickets, and enhancing shareholder value, while delivering projects on time and on budget
Integrate cutting-edge platforms, AI, and advanced analytics to fuel strategic decision-making and measurable business impact
Embed seamless AI and data workflows into enterprise systems to improve operational efficiency, automation, and insight generation
Establish reliable, well-governed data pipelines and integrations that power analytics, reporting, and scalable automation
Enable enhanced decision-making across departments by delivering high-quality, trusted data and embedded intelligence
Foster collaboration, accountability, and a culture of innovation that aligns technology solutions directly with business outcomes
REQUIRED TECHNICAL SKILLS / ABILITIES Strong proficiency in Informatica, SQL, Python, and Power BI
Experience with AI/ML frameworks, LLM-based tools, and cloud platforms (e.g., Azure, AWS, or GCP)
Hands-on experience developing and maintaining API integrations
Strong understanding of data governance, lineage, and security best practices
Excellent analytical, organizational, and communication skills
Ability to collaborate across teams and translate technical concepts into business value
Deep expertise in enterprise architecture, complex application design, AI integration, advanced analytics, and emerging technologies to deliver scalable, secure, and innovative solutions
Demonstrate deep, active listing to better understand another’s motivations, reality, and perspectives
Strong organizational skills: ability to prioritize work and meet deadlines in a fast-paced environment
Excellent written and verbal communication skills, adept at conveying complex technical concepts to diverse audiences and building trust with both technical and non-technical stakeholders
Dedication to refining development practices, adopting industry best practices, and driving sustainable organizational scalability
Development of SMART goals, followed by the timely execution of deliverables aligned with our IT roadmap which will be measure of employee and team success
Commitment to ethical, secure, and responsible data and AI practices
EDUCATION & EXPERIENCE Bachelor’s degree in computer science, data engineering, data science, information systems, or related fields
5–8 years of experience in data integration, analytics, or related fields 5+ years of ticketing / attraction focused experience preferred
Proven experience managing data pipelines, AI integrations, and enterprise analytics environments
Exposure to real estate, REIT, or property technology environments preferred
PHYSICAL REQUIREMENTS Prolonged periods of sitting at a desk and working on a computer
Must be able to lift up to 15 pounds at times
WHAT YOU CAN EXPECT At ESRT, like our tenants, our employees come from everywhere. We foster a collaborative work environment that captures top talent and cultivates the best ideas. As a Great Place to Work® Certified employer, we are committed to maintaining our positive work culture where employees are engaged and can grow and develop. In addition, ESRT employees embody our Company Culture & Success Factors -
Adaptable – you are a self-starter who’s able to quickly digest and execute new processes to work both collaboratively and independently
Dynamic – you are solutions-oriented, aim to improve processes and implement efficiency, and offer insightful feedback to improve ESRT
Dependable – you take a strong sense of ownership and accountability over your work
Passionate – you keep up with industry trends and are excited about the potential to propel the industry forward with a “roll-up-your-sleeves” attitude
Curious – you consistently look for new ways to work smarter, not just harder
Ethical – you treat others with respect, act with integrity in how you perform your work, and embrace our collaborative culture
Positive – you possess a service-oriented attitude with excellent follow through
BENEFITS Competitive base salary and bonus
Health/Dental/Vision insurance
Company sponsored Life, AD&D, STD (with Salary Continuation), and LTD Insurance
Voluntary Enhanced LTD Program
Voluntary Hospital, Accident, and Cancer Programs
401(k) with 100% match up to 5%
Paid parental leave
Pre-tax transit accounts
Employee Assistance Program for emotional, financial, and legal support
WELL-BEING Generous paid time off
Flex remote work time
Flex Summer Fridays
Employee engagement programs
Volunteer time off
Continuing education
Complimentary Empire State Building Observatory access
Complimentary gym membership and other wellness benefits
Employee Discount Programs
ESRT is an equal opportunity employer and is committed to providing a workplace free from harassment and discrimination. We celebrate the unique differences of our employees because they drive curiosity, innovation, and the success of our business. We do not discriminate based on race, religion, color, creed, national origin, sex, sexual orientation, gender identity or expression, reproductive choices, age, marital status, veteran status, disability status, pregnancy, parental status, caregiver status, genetic information, political affiliation, or any other status protected by the laws or regulations in the locations where we operate. This policy applies to all aspects of employment, including hiring, promotion, demotion, compensation, training, working conditions, transfer, job assignments, benefits, layoff, and termination. Reasonable accommodations that do not create an undue hardship for the Company are available for applicants and employees with disabilities or sincerely held religious beliefs.