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 , TikTok , X , and LinkedIn .

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

$135,000 - $145,000 a year

Salary is based on several factors including but not limited to education, work experience, job location, size of property where applicable, and/or certifications. In addition to your base salary, ESRT provides discretionary annual bonuses.

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.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.