Data Warehouse Engineer: Snowflake Pipelines & Data Quality

Greenix Pest Control; Orem (UT); On-site; USD 95,000 - 116,000; Full time

Benefits offered by this job

Medical insurance

401(k) retirement with company match

Paid leave

Job summary

Greenix Pest Control is seeking a Data Warehouse Engineer to own the raw, bronze, and silver layers of our data platform with some duties in the gold layer. You will build reliable ingestion pipelines, monitor data flows, and ensure data freshness and quality for analytics and reporting.

The role collaborates with the analytics team who own modeling and the gold layer. Ideal candidates have 2–5 years in data engineering, strong SQL and Python, and Snowflake experience.

Qualifications

• Bachelor's degree in a data/tech field or demonstrated experience in a data warehouse work environment.
• 2–5 years of experience in a data engineering, ETL/ELT, or related analytics engineering role.
• Hands-on experience building and maintaining data ingestion pipelines using tools like Airbyte, Fivetran, Stitch, or custom scripts.
• Experience with pipeline orchestration/scheduling tools such as Airflow, Dagster, Prefect, Azure Data Factory.
• Strong SQL skills and working proficiency in Python for scripting and automation.
• Experience with Snowflake or a comparable cloud data warehouse.
• Understanding of data quality, governance, lineage, and monitoring/alerting practices.

Responsibilities

• Build and maintain data ingestion pipelines, including connector development and API integrations for sources not natively supported.
• Design, schedule, and monitor data orchestration workflows to ensure reliability and early failure detection.
• Implement source auditing and freshness alerting to catch stale or malformed data before downstream use.
• Write efficient Python and SQL for data extraction, transformation, and troubleshooting.
• Monitor pipeline health, diagnose data quality issues, and implement durable fixes.
• Maintain raw, bronze, and silver data layers in Snowflake for downstream analytics handoffs.
• Contribute to standards for pipeline design, testing, version control, and documentation.

Skills

Python

SQL

Snowflake

ETL/ELT

API integrations

Education

Bachelor's degree in data/tech field

Tools

Airflow

Dagster

Prefect

Azure Data Factory

Airbyte

Fivetran

Stitch

Job description

Greenix Pest Control is seeking a Data Warehouse Engineer to own the raw, bronze, and silver layers of our data platform with some duties in the gold layer. You will build reliable ingestion pipelines, monitor data flows, and ensure data freshness and quality for analytics and reporting.

The role collaborates with the analytics team who own modeling and the gold layer. Ideal candidates have 2–5 years in data engineering, strong SQL and Python, and Snowflake experience.