Data Warehouse Engineer

Summary

Greenix Pest Control is seeking a Data Warehouse Engineer to support its migration to Snowflake. The role owns the raw, bronze, and silver data layers, builds and monitors ingestion and orchestration pipelines, and ensures data freshness, quality, and auditability for analytics and reporting.

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, ensuring pipelines run reliably and failures are caught early
• Implement source auditing and freshness alerting to proactively identify stale, missing, or malformed data before it reaches downstream consumers
• Write efficient, well-documented Python and SQL for data extraction, transformation, and troubleshooting
• Monitor pipeline health, diagnose root causes of data quality issues, and implement durable fixes
• Maintain the raw, bronze, and silver data layers in Snowflake, ensuring a clean handoff to the analytics team's transformation and modeling work
• Contribute to standards and best practices for pipeline design, testing, version control, and documentation

Skills

• Bachelor's degree in a data/technology field (e.g., economics, computer science, or information systems) 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 (e.g., Airbyte, Fivetran, Stitch, or custom scripts)
• Experience with pipeline orchestration/scheduling tools (e.g., Orchestra, Airflow, Dagster, Prefect, Azure Data Factory)
• Strong SQL skills, plus working proficiency in Python for scripting and automation
• Understanding of data quality, governance, lineage, and monitoring/alerting practices
• Ability to work cross-functionally with analysts and business stakeholders to understand source systems and data needs
• Experience with a cloud data warehouse (Snowflake preferred, or a comparable platform with willingness to specialize in Snowflake)

Qualifications

Must Haves

• Bachelor's degree in a data/technology field (e.g., economics, computer science, or information systems) 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 (e.g., Airbyte, Fivetran, Stitch, or custom scripts)
• Experience with pipeline orchestration/scheduling tools (e.g., Orchestra, Airflow, Dagster, Prefect, Azure Data Factory)
• Strong SQL skills, plus working proficiency in Python for scripting and automation
• Understanding of data quality, governance, lineage, and monitoring/alerting practices
• Ability to work cross-functionally with analysts and business stakeholders to understand source systems and data needs

Nice to Haves

• Experience with a cloud data warehouse (Snowflake preferred, or a comparable platform with willingness to specialize in Snowflake)

Benefits

• Medical insurance with subsidized premiums for employees and enrollees.
• Dental, vision, disability, accident, and life insurance options.
• 401(k) retirement program with a company match.
• Employee assistance program (EAP), offering support for emotional, financial, legal, health, or work-related struggles for you and your dependents.
• Paid leave for all of life’s reasons.
• Pest control company discount (if you live within our territory).