Senior Data Engineer

PerkSpot
  • Chicago, IL
  • Full-time
Today

Job Description

PerkSpot is searching for a Senior Data Engineer to join our Engineering team! At PerkSpot, our mission goes beyond discounts—it’s about empowering employees everywhere to make smarter spending decisions so they can do more of what they love. We believe every dollar saved can become a stepping stone to a brighter future, whether that’s a special family vacation, a first home, or simply extra peace of mind.

Reporting to the Director of Data Engineering, the Senior Data Engineer will design, build, and maintain reliable, scalable data pipelines and models that power our business. In this role, you’ll own data solutions end to end, partnering with teams across PerkSpot to turn business and source-system requirements into dependable, production-ready solutions. You’ll bring strong data engineering fundamentals and hands-on experience with modern technologies like SQL, dbt, cloud data warehouses, Python, and workflow orchestration tools.

This position is required to be in the office 3 days a week on Tuesday, Wednesday, and Thursday. Our office is located in the Merchandise Mart in downtown Chicago, IL.

What you’ll accomplish:

  • Design and build scalable batch and event-driven data pipelines from ingestion through consumption.
  • Develop and maintain reliable data models using SQL and dbt.
  • Build and optimize solutions on Snowflake or a comparable cloud data warehouse.
  • Create and manage orchestrated workflows using Airflow, Dagster, or similar tools, including dependencies, schedules, retries, failure handling, and backfills.
  • Integrate data from databases, APIs, files, cloud storage, and third-party platforms using Python to automate workflows and support pipeline development.
  • Implement testing, monitoring, alerting, logging, and data-quality controls to improve pipeline reliability.
  • Troubleshoot pipeline failures, performance issues, and data discrepancies while optimizing for performance, scalability, and cost.
  • Apply software engineering practices including Git, code reviews, CI/CD, documentation, and automated testing.
  • Partner with analytics, product, engineering, and business teams to translate requirements into dependable data solutions.
  • Mentor other engineers and contribute to data architecture and engineering standards.

What we’re looking for:

  • 5+ years of experience in data engineering or a related role.
  • Advanced SQL skills, including complex transformations, query optimization, and dimensional data modeling.
  • Hands-on experience with dbt, including models, tests, macros, documentation, and incremental processing.
  • Experience with Snowflake or a similar cloud data warehouse.
  • Experience building solutions in AWS or Azure.
  • Proficiency in Python for data processing, automation, and integration.
  • Hands-on experience with Airflow, Dagster, or another workflow orchestration platform.
  • Demonstrated experience building and supporting data pipelines end to end.
  • Strong understanding of workflow dependencies, scheduling, retries, backfills, and failure recovery.
  • Strong understanding of ETL/ELT patterns, data warehousing, and data-quality practices.
  • Experience using Git and CI/CD within a collaborative development environment.
  • Strong troubleshooting, communication, and documentation skills.

Preferred qualifications include:

  • Experience with Azure Data Factory, Snowpipe, Snowflake Streams and Tasks, or comparable technologies.
  • Experience working with APIs, JSON, event-driven pipelines, and cloud object storage.
  • Familiarity with medallion architecture and dimensional modeling.
  • Experience implementing pipeline observability, lineage, and automated alerting.
  • Experience modernizing legacy stored-procedure or scheduler-based pipelines.
  • Familiarity with data governance, security, and role-based access controls.

About PerkSpot:

Our journey began in Chicago back in 2006 with a vision of helping employees stretch their paychecks without sacrificing what they love. What began as a small company with a big vision has evolved into a discount shopping solution employees across the globe rely on to stretch their paychecks. In 2018, PerkSpot raised $50M from Susquehanna Growth Equity and today the business serves more than 22 million employees from top employers including Southwest Airlines, Mayo Clinic, and Humana. We saw an opportunity to do more—to build something that brought genuine, life-enhancing value to employees’ everyday financial decisions.

Your first few months as a PerkSpotter:

Providing value doesn’t have to wait, from day one we are open to your big ideas. In your first few months, you will...

  • Meet the team! You’ll report to the Director of Data Engineering and collaborate with partners across B.I. & Analytics, Product, and Engineering!
  • Get to know PerkSpot! Immerse yourself in the business, engage with internal stakeholders, and participate in monthly companywide All-Hands meetings.
  • Sharpen your skills! Build your knowledge of PerkSpot’s data ecosystem, pipelines, data models, and engineering practices.
  • See your impact! Help make our data pipelines and products more reliable, scalable, and maintainable.
  • Participate in company-wide events! Whether it’s office miniature golf or a raffle gameshow, company culture is at the forefront of our business.

 

The pay: 

PerkSpot offers competitive industry rate salaries with the goal of retaining and growing talented individuals. We regularly review and adjust our compensation structure as needed to ensure equity and across teams and levels. The base salary range for this position is $150,000 - $160,000 plus a $4,000 annual bonus. 

What We Offer:

  • Competitive salary, matching 401K, and company paid disability.
  • Comprehensive medical, dental, and vision insurance is effective on your first day of employment!
  • Time off is required. We want our team members to rest, relax, and recharge, so we encourage employees to take 20 days off each year. Plus, we offer 8 paid company holidays and our office is closed from Christmas Eve through New Year's Day.
  • Summer Fridays are great and are an annual tradition between Memorial Day and Labor Day every year.
  • To help you get a jump start on company holidays, we close at 1 pm the day prior to each company holiday as “holiday eve.”
  • Tenure is valued and rewarded. In addition to PTO, we offer a paid Sabbatical for up to 3 months to employees at 5 years and 10 years of service.
  • Commuting can be expensive – we get it. So, we provide a monthly transportation stipend and free lunch every Wednesday.
  • Connection and relationship building is everything. We offer regular outings, virtual events, fun community-interest Slack channels, and occasional happy hours.

How to apply:

All applications will be kept strictly confidential. Please submit a resume and cover letter telling us how you stack up to the qualifications, plus any other information you feel would be relevant to PerkSpot. Don’t be afraid to show your spark and personality!

All positions require a complete background screening.

PerkSpot is an equal opportunity employer. Offering a diverse, equitable, and inclusive work environment is a priority at PerkSpot. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, or national origin, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.

 

Powered by JazzHR

Numbers & Facts

LocationChicago, IL
Job TypeFull-time
Websitehttp://www.perkspot.com/

Skills

  • Access Controlunmatched
  • Amazon Web Services (AWS)unmatched
  • Application Programming Interface (API)unmatched
  • Automationunmatched
  • Channel Strategiesunmatched
  • Cloud Computingunmatched
  • Cloud Storageunmatched
  • Communication Skillsunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Data Managementunmatched
  • Data Modelingunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Warehousingunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Dental Insuranceunmatched
  • Dimensional Modelingunmatched
  • Documentationunmatched
  • Ecosystemsunmatched
  • Gitunmatched
  • Identify Issuesunmatched
  • Information/Data Security (InfoSec)unmatched
  • JSONunmatched
  • Mentoringunmatched
  • Microsoft Windows Azureunmatched
  • Performance Tuning/Optimizationunmatched
  • Product Engineeringunmatched
  • Python Programming/Scripting Languageunmatched
  • Reliability Engineeringunmatched
  • Requirements Managementunmatched
  • SQL (Structured Query Language)unmatched
  • Scalable System Developmentunmatched
  • Schedule Developmentunmatched
  • Slackunmatched
  • Small Companyunmatched
  • Snowflake Schemaunmatched
  • Stored Proceduresunmatched
  • Team Playerunmatched
  • Vision Planunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Resume Builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Resume Builder