Green Street Advisors, Inc. Data Engineer in New York, New York
The Data Engineer’s primary responsibilities will include working closely with our Research and Product teams to manage data aggregation routines, warehouse large property datasets, and build and maintain proprietary financial models. The ideal candidate will have strong scripting language skills (e.g. Python), extensive knowledge of MySQL, excellent communication skills, and experience in data, ETL pipelines, and databases. They will be working with a very tight and collaborative development team and should play a key role in leading various projects.
Duties & Responsibilities:
Architect and build database schema, data ingestion models, ETLs, and testing to uphold data integrity and availability.
Develop, maintain, and optimize current data architecture and pipelines, while maintaining documentation.
Provide leadership and mentorship to junior team members through training, pair programming, and code reviews.
Collaborate with product, research, operations, and front end teams to build innovative solutions to achieve business goals.
Perform analysis on large aggregated (e.g. demographic, geographic, GIS / spatial) datasets.
Knowledge & Skills:
Excellent scripting skills and an extensive knowledge of SQL with ability to write advanced queries to manipulate datasets.
Knowledge of and passion for database design, optimization techniques, and warehousing.
Strong leadership and interpersonal skills.
Ability to quickly learn, internalize complex pipelines, and efficiently troubleshoot bugs.
Experience with AWS infrastructure and CI / CD, and interest in front end technologies is a plus.
Prior experience developing scalable APIs (REST and GraphQL) is a plus
Candidate must be currently authorized to work in the United States without a future sponsorship requirement
Strong programming skills with 4 – 5 years of experience in Python (e.g. Pandas, SQLAlchemy, Flask, FastAPI, etc.).
Extensive database skills with 4 – 5 years of experience in either MySQL, SQL, or PostgreSQL.
Proficiency with Git is required; previous experience with the Atlassian product family (Confluence and Jira) is a plus.
Must enjoy collaborative problem solving, have excellent communication skills, and demonstrate attention to detail.
Prepared to work independently in a fast-paced, agile environment with the ability to multitask.
Track record of keeping up with new cloud technologies, languages, standards, and practices.
Prior knowledge of finance, real estate data, mathematics, or GIS / spatial data is a plus.
Comprehensive benefits package including highly competitive medical and dental insurance
Company sponsored employee assistance program, life insurance and long term disability coverage
Health savings accounts and flexible spending accounts
Vacation, sick, and personal time
Company paid holidays and summer half day Fridays
Cell phone reimbursements & gym stipends
16 weeks fully paid maternity leave & 2 week fully paid paternity leave
Green Street is an Equal Opportunity Employer
Green Street provides preeminent and actionable commercial real estate research, news, data, analytics, and advisory services in the U.S. and Europe. For more than 35 years, Green Street has delivered unparalleled intelligence and trusted data on the public and private real estate markets, helping investors, banks, lenders, and other industry participants optimize investment and strategic decisions. The firm delivers exclusive market information, conclusion-driven insights, and predictive analytics through a SaaS platform.
The success of Green Street is directly attributable to the strength of our people. We attract high-quality applicants due to our reputation for excellence and our commitment to train and retain talent. Our collaborative work environment provides team members with opportunities to develop professionally and play a central role from day one. At Green Street, we are all about providing unique insights. A diverse and inclusive work environment where top talent can thrive, think freely and offer different perspectives makes our insights even stronger. We’re building a company culture where differences in gender, race, age, religion, ethnicity, identity, physical ability and perspectives are celebrated and valued.