Senior Data Engineer
Green Street, United States
Job Description
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.
The Senior 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 excellent 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 amp; 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 amp; 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
Requirements
We are highly selective candidates should possess the following:
- Candidate must be currently authorized to work in the United States without a future sponsorship requirement
- Excellent 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.
Working Conditions: The Senior Data Engineer will work indoors in an air-conditioned office building and must be able to remain stationary at a desk and computer for most of the day.
Travel Percentage: None
Benefits
- 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
- 401(k) matching
- Vacation, sick, and personal time
- Company paid holidays and summer half day Fridays
- Cell phone reimbursements amp; gym stipends
- 16 weeks fully paid maternity leave amp; 2 week fully paid paternity leave
- Green Street is an Equal Opportunity Employer