Data Engineer
Share
Job Location:
New York City, NY - USA
Monthly Salary:
Not Disclosed
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
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. ESRTs flagship Empire State Building the Worlds Most Famous Building features its iconic Observatory ranked the #1 Top Attraction in New York City for the fourth consecutive year in Tripadvisors 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 September30 2025 ESRTs 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 capabilitiesincluding 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 ESRTs 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 anothers 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
- Bachelors degree in computer science data engineering data science information systems or related fields
- 58 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 addition ESRT employees embody our Company Culture & Success Factors -
- Adaptable you are a self-starter whos 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
$135000 - $145000 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 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.
Required Experience:
IC
Key Skills
- Apache Hive
- S3
- Hadoop
- Redshift
- Spark
- AWS
- Apache Pig
- NoSQL
- Big Data
- Data Warehouse
- Kafka
- Scala
About Company
Discover modern office spaces at the Empire State Building, featuring top-tier amenities and energy efficiency that attract top tenants from diverse industries.
