Junior Data Engineer

Advertising, subscriptions and transaction fees each bring in a significant share of revenue. Traffic during holiday peaks can reach ten times normal levels, and the platform is built for it. We started in 2011 and have grown to about 610 people. Our office has a quiet floor and a loud floor.

Role overview:

The operations team moves data from about 30 source systems into Snowflake. You'll own ingestion, modeling and data quality checks. We're looking for another Junior Data Engineer to build and maintain the pipelines that feed our warehouse, dashboards and models. Remote, with occasional travel to Las Vegas (a few times a year).

Key responsibilities:

• Process large datasets with Spark on Databricks or EMR
• Document datasets and lineage in a catalog such as DataHub or Atlan
• Work with analysts to define metrics and fix discrepancies between reports
• Manage warehouse objects, roles and spend in Snowflake, BigQuery or Redshift
• Maintain CI for data code and review pull requests
• Stream events through Kafka or Kinesis into the lake and warehouse
• Tune slow queries and expensive jobs
• Model data in dbt using staging, intermediate and mart layers

What you need:

• 1+ years of data engineering, or backend work with data at volume
• Working knowledge of AWS, GCP or Azure data services
• Hands-on with an orchestration tool such as Airflow
• Experience with a cloud data warehouse (Snowflake, BigQuery, Redshift or Synapse)
• Patience with messy source data and the habit of documenting assumptions
• Expert SQL, including window functions and query tuning

Preferred qualifications:

• Terraform for data infrastructure
• Reverse ETL tools like Hightouch or Census

Pay: $114,000 - $132,000 a year

Benefits:

• Medical, dental and vision insurance
• 401(k) with 4% match
• Paid holidays

This position requires a background check.

Please include a short note on why this role interests you.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Hillside Online LLC.