Data Warehouse Engineer

Greenix Holdings, LLC; Plano (TX); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical insurance

Dental & Vision insurance

401(k) retirement match

Employee assistance program

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 as part of migrating to Snowflake. You will build reliable ingestion pipelines and monitor data quality for analytics and reporting, partnering with the analytics team on gold-layer modeling.

You should bring 2–5 years of data eng/analytics eng experience, strong SQL and Python, and familiarity with Snowflake and data governance.

Qualifications

• Bachelor's degree in data/tech field or equivalent experience.
• 2-5 years in a data engineering/analytics engineering role.
• Hands-on data ingestion pipelines with listed tools.
• Experience with orchestration/scheduling tools.
• Strong SQL and Python for scripting and automation.
• Experience with Snowflake or similar warehouse.
• Knowledge of data quality, governance, lineage, monitoring.

Responsibilities

• Build and maintain data ingestion pipelines and API integrations.
• Design, schedule, and monitor data orchestration workflows.
• Implement source auditing and freshness alerts.
• Write Python and SQL for ETL/ELT processes.
• Monitor pipeline health and diagnose data quality issues.
• Maintain raw, bronze, and silver data layers in Snowflake.
• Contribute to standards, testing, version control, and documentation.

Skills

Data ingestion pipelines

Airflow

Dagster

Python

SQL

Snowflake

Data quality & governance

Cross-functional collaboration

Education

Bachelor's degree in data/technology field

Tools

Airbyte

Fivetran

Stitch

Airflow

Dagster

Prefect

Azure Data Factory

Orchestra

Job description

ROLE 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 gold layer fact and dim modeling, as part of our migration to Snowflake. This role is responsible for building reliable data ingestion pipelines, orchestrating and monitoring data flows, and ensuring the freshness, quality, and auditability of source data that feeds our analytics and reporting. This role partners closely with the analytics team, who own the dimensional modeling and business-view (gold layer) work built on top of this foundation. The successful candidate will demonstrate attention to detail in pipeline design, a sense of curiosity to build effective solutions and grow their own skills, and an ownership attitude. Your experience as a data warehouse engineer or analytics engineer will be valuable to success in this role.

ABOUT GREENIX

Join one of the fastest growing businesses in Utah! Greenix has been recognized as one of “Utah’s Fast 50” businesses for 3 years running and named “Utah’s Emerging 8” businesses to watch. We have also been recognized by the Salt Lake Tribune and USA Today as a Top Workplace in 2023 and 2024! By sticking to our core values, we are redefining the pest control service industry.

Building Lasting Relationships Going Beyond Creating Opportunities Doing What Is Right, Always If our core values resonate with you, we would be excited to add you to our team.

DUTIES & 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

QUALIFICATIONS & REQUIREMENTS

• Education: 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.
• Skills and Experience:
  • 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
  • Experience with a cloud data warehouse (Snowflake preferred, or a comparable platform with willingness to specialize in Snowflake)
  • 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

WHAT WE OFFER

• 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).

As part of our dedication to the diversity of our workforce, Greenix is committed to Equal Employment Opportunity. Applicants will receive consideration for employment without regard for race, color, gender, religion, national origin, disability, veteran status, military status, age, marital status, sexual orientation, gender identity, genetic information or any other protected group status. We are also committed to providing reasonable accommodations for qualified individuals with disabilities and disabled veterans in our job application and employment procedures.

Greenix has developed a company culture that empowers our employees. If you currently do not enjoy getting up and going to work every morning, then see if you are a fit with us. We understand that you have a life, and we know family matters. We also recognize that work can be stressful. By providing regular employee lunches, incentives, company parties, and more, we help provide a comfortable stomping ground for our greatest asset... our employees. Join our team and find balance for work and yourself while shaping the future of the pest control industry.