Data Engineer

Power Home Remodeling Group; Philadelphia (Philadelphia County); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Full medical, dental, life insurance

401(k) with company match

Paid time off

Parental leave

Home office stipend

Job summary

Power Home Remodeling Group in Philadelphia is seeking a Data Engineer to help build the data foundation powering AI across the business. You will design and own batch and real-time pipelines, modernize the lakehouse, and enable retrieval, embeddings, and secure access for AI agents.

You will collaborate with analysts and leaders to translate needs into reliable datasets, raise engineering standards, and move fast in a small, high-impact team that values curiosity and craftsmanship.

Qualifications

• 5+ years of data engineering with production pipelines.
• Experience with real-time data pipelines and modern data tooling.
• Proficiency in Spark, dbt, Airflow, SQL and Python.
• Strong data modeling and API integration experience.
• Familiarity with testing, version control, and CI/CD practices.

Responsibilities

• Build batch and real-time data pipelines the business relies on.
• Lead modernization of the data platform with new tools and architectures.
• Tune production systems for reliability and performance.
• Support data retrieval, embeddings, and AI data workflows.
• Collaborate with analysts and leaders to turn needs into datasets.

Skills

5+ years data eng

Spark

dbt

Airflow

SQL

Python

Data modeling

APIs

CI/CD

Testing

Communication

Containers/IaC

Tools

Spark

dbt

Airflow

Python

SQL

Job description

Data Engineer, Data Platform & AIHelp build the data foundation that powers AI across the business, from the ground up.Why This Role Is DifferentThis isn't a seat on a large, established team where the big decisions were made years ago. You'll have real influence here. You'll help shape the architecture choices, standards, and practices that define how the company uses data and AI for years to come.You'll work on a modern, open-source-first lakehouse and help take it into its next phase: real-time data and production-grade data for AI. If you've wanted to do meaningful work at the point where data engineering meets generative AI, this is that opportunity.About the TeamWe're a small, high-impact team building the platform that analytics and AI across the business depend on. You'll partner closely with the technical leaders, have real influence over technical direction, and grow your career alongside the platform. We value curiosity, craftsmanship, and clear communication, and we invest in the people who bring them.What You'll DoBuild pipelines that matter. Design, build, and own batch and real-time data pipelines that the business relies on every day.Lead the shift to real time. Play a hands-on role in modernizing the platform to new tools, architectures, and capabilities as the business grows.Make things fast and reliable. Tune and harden production systems so the business can trust its data.Build the foundation for AI. Help create the data infrastructure behind intelligent applications, including retrieval, embeddings, and secure, governed access for AI agents.Turn ideas into impact. Work with analysts and business leaders to turn their needs into datasets they can depend on.Raise the bar. Contribute to code reviews, share knowledge, and help set the engineering standards for a growing team.What You'll Bring5+ years of data engineering experience, with pipelines you've shipped and supported in productionHands-on experience with distributed data processing (such as Spark) and a solid grasp of how to make it performProduction experience with modern data transformation and orchestration tools (such as dbt or Airflow)Strong SQL and Python skills and a solid foundation in data modelingExperience working with data services and APIsGood engineering habits, including testing, version control, and CI/CDClear written communicationCuriosity and a real interest in learning new tools, especially in data for AIPreferredExperience with open table formats or distributed query enginesExperience with change data capture or streaming technologiesHands-on work building retrieval-augmented generation (RAG) or similar AI data workflowsExposure to AI agents, agent tooling, or AI evaluationFamiliarity with containers, orchestration, or infrastructure as codeWhat's In It for YouReal impact. Help shape the technology, practices, and direction of a platform the whole business relies on.Cutting-edge work. Work hands-on with modern data architecture and production AI, not just talk about them.Career growth. Grow with the team as it scales, with room to take on more ownership and leadership.Mentorship. Work directly with an experienced team lead who's invested in your development.Salary & BenefitsCompetitive salaryFull medical, dental, life and disability insurance plans that can be tailored to your specific needs and the needs of your familyAmple paid vacation and holidayA competitive 401(k) retirement savings program matched by PowerSubsidized child care and fertility benefitsPaid parental leaveAll the tech you need - We'll pay for whatever hardware and software you need to work and make sure you're regularly upgraded to the latest versionsPersonal development - Personal development courses, books, & conferences.Paid parental leave - When the time comes to welcome a new member of the family, we offer paid parental leave.Power Home Remodeling Group is an equal opportunity employer, and we are committed to hiring a diverse and talented workforce. If you have a disability or special need that requires accommodation, please submit the accommodation request to [e-mail]