Data Engineer II

INSPYR Solutions; Lehi (UT); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Comprehensive medical benefits

Competitive pay

401(k) retirement plan

Job summary

A dynamic tech company in Lehi, UT is seeking a Data Engineer II to develop ETL/ELT pipelines and collaborate with data scientists to operationalize features. The ideal candidate has over 3 years of experience with strong skills in Python, SQL, and distributed data frameworks. This role offers a comprehensive benefits package and a hybrid work model.

Qualifications

• 3+ years of data engineering or backend data systems experience.
• Proven track record building production-grade pipelines.
• Strong proficiency in distributed data frameworks.

Responsibilities

• Design and maintain scalable ETL/ELT pipelines.
• Build verified HVAC and Energy data tables.
• Collaborate with data scientists for feature generation.

Skills

Python

SQL

PySpark

Databricks

Kafka

GCP

Problem-solving

Tools

Airflow

Neo4j

Pinecone

Job description

Data Engineer II

Location: Lehi, UT 84043 (hybrid: 4 days onsite / 1 day remote)

Duration: Long Term Contract

Work Requirements: US Citizen, GC Holders, or Authorized to Work in the U.S.

About This Role

• Data Pipeline Development: Design and maintain scalable ETL/ELT pipelines that process time-series signals from thermostats, weather, schedules, and device analytics.
• Core Data Products: Build verified HVAC and Energy data tables (e.g., Run & Drift, Thermal Coefficients, Efficiency Drift) to serve as trusted sources for analytics, modeling, and automation.
• Modernization & Quality: Refactor legacy Scala/Akka processes into PySpark or Databricks jobs, improving observability, testing, and CI/CD coverage for upstream feeds.
• Integration & Streaming: Manage data sourced from Mongo-based telemetry, Kafka or Pub/Sub streams, and cloud storage (GCS) to ensure reliability and consistency.
• Model Enablement: Collaborate with data scientists to generate and operationalize features supporting HVAC runtime prediction, anomaly detection, and DR optimization.
• Documentation & Governance: Promote best practices for data lineage, schema documentation, and change control to prevent regressions in production systems.

Required Qualifications

• 3+ years of data engineering or backend data systems experience
• Strong proficiency in Python, SQL, and distributed data frameworks (PySpark, Databricks)
• Hands‑on experience with GCP, Kafka/Pub‑Sub, and data lake architecture
• Ability to read and modernize legacy Scala/Akka codebases
• Proven track record building production‑grade pipelines that deliver analytics‑ready datasets
• Strong problem‑solving skills in ambiguous, under‑documented environments

Preferred Qualifications

• Experience with ML platforms and feature engineering workflows (e.g. Vertex AI)
• AI/ML application experience (LLMs, computer vision, energy forecasting models)
• Background in IoT applications, protocols, and telemetry
• Familiarity with specialized databases:
  • Graph databases (e.g. Neo4j)
  • Vector databases (e.g. Pinecone)
• Experience with data orchestration tools (e.g. Airflow)
• Background in Demand Response or home energy automation
• Experience implementing data quality metrics, observability, and alerting
• Track record of significant cost optimization or performance improvements in data systems

Our benefits package includes:

• Comprehensive medical benefits
• Competitive pay
• 401(k) retirement plan
• …and much more!

INSPYR Solutions provides Equal Employment Opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability, or genetics. In addition to federal law requirements, INSPYR Solutions complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities.

Information collected and processed through your application with INSPYR Solutions (including any job applications you choose to submit) is subject to INSPYR Solutions’ Privacy Policy and INSPYR Solutions’ AI and Automated Employment Decision Tool Policy: https://www.inspyrsolutions.com/policies/. By submitting an application, you are consenting to being contacted by INSPYR Solutions through phone, email, or text.