The Data Engineer designs and builds AI-driven solutions, optimizes data pipelines, manages integrations, and enhances analytics capabilities across the organization to improve efficiency and decision-making.
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 December 31, 2025, ESRT’s portfolio is comprised of approximately 7.9 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
- 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.
Top Skills
AWS
Azure
GCP
GraphQL
Informatica
Power BI
Python
Rest
SQL
Empire State Realty Trust New York, New York, USA Office
111 West 33rd Street, 12th Floor, New York, NY , United States, 10120
Similar Jobs
eCommerce • Fashion • Other • Retail • Sales • Wearables • Design
The Data Engineer will design and develop Java-based applications, optimize APIs, and collaborate with teams, focusing on cloud integration and SQL queries.
Top Skills:
AWSBash ScriptingGitJavaJdk 11+Restful ApisSQL
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
As a Senior Associate, you will design data solutions, manage ecosystems, mentor junior members, and maintain high standards while building client relationships. The role requires analyzing complex problems and delivering quality work.
Top Skills:
Data Analytics ToolsData WarehousingDatabricksEltETLKafka
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
As a Manager in Managed Services, you'll lead data ecosystems projects, mentor juniors, manage client accounts, and deliver data strategies to optimize operations and drive insights for clients.
Top Skills:
DatabricksKafka
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
