2 months ago
Chicago, IL, USA +3 moreMid Level / Senior
H1B sponsor
Base Salary
$149k - $180k/yr
Responsibilities
- Own, design, build, test, ship, and monitor a scoped domain of dbt models.
- Translate ambiguous Marketing and Product requests into scoped work and communicate tradeoffs.
- Write design documents and break features into implementable pieces for teammates.
- Add monitoring and alerting to data models and participate in the support rotation.
- Debug failures, prevent recurring issues, and maintain runbooks, schema documentation, and diagrams.
- Coach earlier-career engineers through code review and day-to-day collaboration.
Requirements
- Approximately 3–5 years of experience in data or analytics engineering, or comparable work under another title.
- Strong SQL skills, including window functions, complex joins, and query performance considerations.
- Experience owning dbt models in a version-controlled repository, including conventions, tests, CI, and maintenance.
- Working knowledge of Python for orchestration, transformations, and testing.
- Ability to evaluate and explain data modeling tradeoffs such as dimensional modeling versus one large table.
- Ability to communicate technical decisions to both marketers and engineers.
- Experience with Snowflake or a comparable data warehouse.
Benefits
- Medical, dental, and vision coverage starting on Day 1.
- Equity in the form of ISOs.
- 401(k) program.
- Family planning programs and paid parental leave.
- Physical fitness and wellness memberships.
- Emotional and mental health support programs.
- Unlimited PTO, 10 paid federal holidays, and an annual week-long Winter Break.
- Flexible work environment.
- Lunch reimbursement for in-office employees.
- Employee Resource Groups.
- Learning and Development stipend.
- Transparent culture and an employee-focused mission.
About Upside
Upside builds a consumer cash‑back marketplace for gas, groceries, and dining, paired with a performance platform that drives incremental, attributable sales for brick‑and‑mortar retailers. Merchants fund targeted offers and pay based on measured profit, while consumers redeem through the Upside mobile app to earn cash back. Founded in 2016 and headquartered in Washington, DC, the company serves millions of users and facilitates billions of dollars in in‑store commerce annually.