Senior Data ETL Engineer | $100-160K | Industry Leading Real Estate Software Platform

  • Full-time

Company Description

Please only apply to this position if you have the ability to work full-time from Collingswood, NJ, are a US Citizen, have your Green Card or Long Term Visa.

SMARTER AGENT'S GOAL IS TO BUILD THE BEST DATA TEAM IN THE REAL ESTATE INDUSTRY

Smarter Agent is one of the most widely used software platforms in the real estate industry and is integrated into the operations of many of the premier organizations in the residential real estate market.

  • Our success is built on our expanding data capabilities and data services.  
  • We now have one of the largest real estate data services platforms in North America.
  • With Smarter Agent, our customers do not have to overhaul their legacy software systems or keep up with fast paced new technologies in order to have a source of truth made up of accurate real estate data and continuous innovation.

Our Data and Technology Teams are Best in Class in the Real Estate Industry

  • Smarter Agent has a long history of innovation in the real estate markets and has built an industry leading team that has goals to dominate the real estate data market with their SAAS platform. 
  • Members of Smarter Agent have been granted US patents for location based mobile search, branding and advertising, with 5 granted patents issued since May 2013 and 2 granted in 2017. 
  • Smarter Agent was the first to introduce a cascading platform for mobile app delivery. With this app creation and linking technology, any global brand with a local presence has a way to maintain design and business rule control while providing personally branded apps to all their agents across the country or globe.  
  • Smarter Agent’s work with data over the years has morphed the company into a leading real estate data firm creating services to support global and regional real estate organizations.

Smarter Agent Headquarters Overview

  • The Smarter Agent team is an extremely successful tech start-up based in the retro cool South Jersey gem of Collingswood, New Jersey. 
  • Our new office is on the second floor of the building we designed is 10 minutes outside Philadelphia, Pennsylvania via the PATCO commuter light rail - we have free parking as well. 
  • We have a flexible work and time-off schedule and provide health benefits. 
  • Smarter Agent fosters a team environment where you can expand your skill set, gain leadership skills and grow your career.

Job Description

We're looking for a Senior ETL data engineer to help us transform how consumers interact with real estate data.  You should be a self-motivated leader that takes ownership of projects.

You are a Hands-on Senior ETL architect and developer who is excited to tackle the challenges that come with working on large volumes of diverse data with complex business rules.

You should be located in the Philadelphia/South Jersey region and be a US citizen, willing to come to our corporate office to work. However, you will start remote given current physical distancing restrictions.Thrive in building scalable, high throughput systems that processes more than 10 billion data points a day from over 500 sources that all need to be standardized and enhanced.

  • Demonstrate the ability to quickly grasp complex subject matter and apply data engineering skills and technical knowledge to assess and provide solutions. 
  • Demonstrate a willingness to assist other team members in areas outside of direct assignments, when necessary.
  • Collaborate in a virtual environment to complete projects with team members in various locations.
  • You must be available for extended hours.
  • Strong communication skills, a positive attitude, and empathy.
  • Self-awareness and a desire to continually improve.
  • Desire to write and maintain a clean and well-tested code base, avoiding tech debt.

Qualifications

  • 7+ years of SQL Server database development experience
  • 5+ years of ETL experience 
  • 5+ years of experience in working with Oracle and Postgres with experience in moving Oracle based processes to Postgre
  • Advanced SQL knowledge for working with relational data in Oracle and Postgres
  • Advanced  programming experience with Python ( Java experience) with a focus on working with unstructured data . 
  • Experience programming in a Linux/UNIX environment including shell scripting.
  • Experience with Bash scripts.
  • Advanced experience with ETL processes:  Preparing, staging, scheduling, monitoring, and maintaining automated data processes from large disconnected datasets into a production environment.
  • Ability to develop analytical models (e.g., regression, simulation, statistical, etc.) for structured and unstructured data sets with a focus on data lineage to proactively identify risk areas and identify/catch outliers, trends and/or projections, where appropriate.
  • Experience as well as a focus on DevOps principles such as CI/CD and IaC (Terraform)
  • Working knowledge of message queuing (SNS/SQS/ and stream processing (Kinesis).

Additional Information

Process for Interviewing

  • Please submit your resume and LinkedIn profile by clicking “I’m Interested” and why you feel that you are a good fit for the position.
  • Phone screen by Michael C. Bertoni, Chief Recruiting Officer
  • Smarter Agent Online Assessment 
  • Onsite Interview 
  • Offer

All the above can be completed expediently after completion of the online assessment.