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

Smarter Agent; New Jersey; Hybrid; USD 100.000 - 160.000; Vollzeit

Benefits dieser Stelle

Flexible work and time-off schedule

Health benefits

Team environment for career growth

Zusammenfassung

Smarter Agent, based in Collingswood, NJ, is seeking a Senior Data ETL Engineer with a salary range of $100-160K. The successful candidate will work on large volumes of real estate data and has advanced experience in SQL Server, ETL processes, and programming in Python.

The position is full-time, requiring applicants to be US citizens or have valid work authorization. The role will initially be remote, transitioning to on-site as conditions allow. A collaborative team environment and excellent benefits are part of the offering.

Qualifikationen

• 7+ years of SQL Server database development experience.
• 5+ years of ETL experience.
• 5+ years of experience with Oracle and Postgres.
• Advanced SQL knowledge for working with relational data.
• Advanced programming experience with Python.
• Experience programming in a Linux/UNIX environment.

Aufgaben

• Transform how consumers interact with real estate data.
• Build scalable, high throughput systems.
• Collaborate in a virtual environment.
• Assist team members in areas outside of direct assignments.

Kenntnisse

SQL Server database development

ETL processes

Oracle

Postgres

Python

Linux/UNIX

Shell scripting

Bash scripts

CI/CD

Terraform

Message queuing (SNS/SQS)

Data analysis

Jobbeschreibung

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

• Full-time

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 areBest 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.
• 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.

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.
• • 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).

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.

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply.