Junior Data Engineer, Python

Sellers use the platform to list used outdoor gear, and we handle payments, shipping labels and buyer protection. Revenue comes from a mix of advertising, affiliate commissions and a premium tier. Product reviews happen on Thursdays, with demos of whatever shipped that week.

Overview:

This role opened up after a team member moved internally. This hire will help replace a set of fragile nightly scripts with tested, monitored pipelines. Chicago Apps needs someone who writes solid SQL and Python and treats pipelines like production software. Our headquarters is in Chicago, and about a third of the team works remotely from other countries. This is a full-time remote role. We use an employer of record in India, so you get a proper employment contract, not a freelance agreement. Core hours overlap with US Central time, 9:00 AM to 1:00 PM CT. We use Slack, Notion and Google Meet. Cameras on for team calls.

Essential duties and responsibilities:

Document datasets and lineage in a catalogue such as DataHub or Atlan. Tune slow queries and expensive jobs. Respond to pipeline failures and backfill data when needed. Ingest data from APIs, SaaS tools and databases with Fivetran, Airbyte or custom Python. Maintain CI for data code and review pull requests. Work with analysts to define metrics and fix discrepancies between reports. Model data in dbt using staging, intermediate and mart layers.

Minimum qualifications:

1-2 years of data engineering, or backend work with data at volume. Working knowledge of AWS, GCP or Azure data services. Patience with messy source data and the habit of documenting assumptions. Strong Python for data processing. Understanding of dimensional modelling and slowly changing dimensions. Expert SQL, including window functions and query tuning.

Perks and benefits:

Public holidays observed per your country. Home office setup budget. 24 days paid time off. Performance bonus. Health insurance through our employer-of-record partner. Company laptop. Monthly internet allowance.

Please include your notice period and salary expectations.

Candidates must be eligible to work in India.

Start: Immediately.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Chicago Apps, LLC.