Data Platform & AI Engineer: Real-Time Pipelines

Power Home Remodeling Group; King of Prussia (PA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical, dental, life and disability

Paid vacation

401(k) retirement plan matched

Parental leave

Equipment provided

Personal development

Job summary

Power Home Remodeling Group is seeking a Data Engineer to help build a modern, open-source-first lakehouse that powers AI across the business. You’ll own batch and streaming pipelines, collaborating with analysts and leaders to deliver scalable datasets and reliable data for AI workflows.

You’ll influence architecture and standards, work on real-time capabilities, and contribute to production-grade data for AI agents while growing with a small, high-impact team.

Qualifications

• 5+ years of data engineering experience with pipelines in production.
• Hands-on with distributed processing (e.g., Spark).
• Experience with dbt or Airflow.
• Strong SQL and Python; solid data modeling.
• Experience with data services and APIs.
• Good testing, version control, and CI/CD practices.
• Clear written communication.
• Curiosity and willingness to learn new AI data tools.

Responsibilities

• Build batch and real-time data pipelines the business relies on.
• Lead the shift to real-time data processing and modern architectures.
• Tune and harden production systems for reliability.
• Build data infrastructure behind AI apps, incl. retrieval, embeddings, and secure access.
• Turn business needs into robust datasets in collaboration with analysts and leaders.
• Contribute to code reviews and engineering standards in a growing team.

Skills

SQL

Python

Spark

Data pipelines

Data modeling

CI/CD

APIs

Testing

Code reviews

Documentation

Tools

dbt

Airflow

Open table formats

Job description

Power Home Remodeling Group is seeking a Data Engineer to help build a modern, open-source-first lakehouse that powers AI across the business. You’ll own batch and streaming pipelines, collaborating with analysts and leaders to deliver scalable datasets and reliable data for AI workflows.

You’ll influence architecture and standards, work on real-time capabilities, and contribute to production-grade data for AI agents while growing with a small, high-impact team.