> Markdown version of [/jobs/ext/2714482-etl-architect-and-developer](https://www.wearedevelopers.com/jobs/ext/2714482-etl-architect-and-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # ETL architect and developer - **Company:** SMARTER AGENT, INC. - **Location:** Philadelphia, PA, United States (Remote available) - **Experience:** Expert - **Salary:** $100,000.0 - $160,000.0 - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Bash Shell, Computer Programming, Continuous Integration, Information Engineering, Extract Transform Load (ETL), Relational Databases, Linux, DevOps, Python (Programming Language), PostgreSQL, Microsoft SQL Server, Oracle (Applications), Queueing Systems, Shell Script, Unstructured Data, Sql Optimization, Virtual Environment, Technical Debt, Semi-structured Data, Data Lineage, Amazon Simple Queue Service (SQS), Terraform, Stream Processing - **Published:** September 4, 2026 - **Apply:** https://startup.jobs/senior-data-etl-engineer-100-160k-industry-leading-real-estate-software-platform-smarter-agent-8254821 ## About the Role 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). ## Related Videos - [Docker network without Docker](https://www.wearedevelopers.com/videos/1418-docker-network-without-docker) - [From DevOps to Scaled DevOps: How We’re Rebuilding Continuous Delivery as a Platform](https://www.wearedevelopers.com/videos/100018-from-devops-to-scaled-devops-how-we-re-rebuilding-continuous-delivery-as-a-platform) - [Infrastructure as Code: The Developer's Secret Weapon](https://www.wearedevelopers.com/videos/1221-infrastructure-as-code-the-developer-s-secret-weapon) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [#90DaysOfDevOps - The DevOps Learning Journey](https://www.wearedevelopers.com/videos/548-90daysofdevops-the-devops-learning-journey) - [Docker exec without Docker](https://www.wearedevelopers.com/videos/1094-docker-exec-without-docker) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Developers are Building the Cities of the Future](https://www.wearedevelopers.com/magazine/536-developers-are-building-the-cities-of-the-future) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs) - [Navigating the AI Shift](https://www.wearedevelopers.com/magazine/629-navigating-the-ai-shift)