Junior Data Engineer

About Esposito Digital

Most of what we build is back-office software for property managers, including lease tracking, work orders and tenant payments. Clients range from single-location retailers to franchise groups with hundreds of stores, all running our point-of-sale and loyalty software. Founded in 2012, we now have 180 employees. Laptops are MacBook Pros, and you pick your own editor.

What this job is

We're looking for a Junior Data Engineer to join our team. This is a remote role. This hire will help replace a set of fragile nightly scripts with tested, monitored pipelines. The Data Infrastructure team moves data from about 30 source systems into Snowflake. You'll own ingestion, modelling and data quality checks. Our team is spread across 9 countries. Headquarters is in White Plains. We hire in Pakistan through an employer of record, so this is a regular full-time job with local payroll and statutory benefits. You will need at least 4 hours of overlap with US Eastern time.

Day to day

Respond to pipeline failures and backfill data when needed. Model data in dbt using staging, intermediate and mart layers. Write data quality tests with dbt or Great Expectations and alert on failures. Handle PII according to retention, masking and access policies.

What we're looking for

Working knowledge of AWS, GCP or Azure data services. Familiarity with Git, CI/CD and testing practices for data code. Patience with messy source data and the habit of documenting assumptions. Understanding of dimensional modelling and slowly changing dimensions. Strong Python for data processing. Expert SQL, including window functions and query tuning.

Desirable

Background in finance or marketing data. Reverse ETL tools like Hightouch or Census. Terraform for data infrastructure.

Compensation and benefits

Performance bonus. Health insurance through our employer-of-record partner. Paid parental leave. Co-working space stipend. Stock options. Annual salary review. Flexible hours.

Start: Flexible.

Demo job created on 11jobs for testing and demonstrations. It is not an actual opening at Esposito Digital.