Retail Insight

Data Engineer II

Retail Insight

full-time

Posted on:

Location Type: Hybrid

Location: ChicagoIllinoisUnited States

Visit company website

Explore more

AI Apply
Apply

Salary

💰 $85,000 - $110,000 per year

About the role

  • You'll help shape and strengthen our data ecosystem for our existing, and brand new clients - working hands‑on across pipelines, orchestration, databases, and cloud technologies.
  • Design, build, and maintain scalable data pipelines across ingestion, transformation, orchestration, monitoring, and quality assurance.
  • Develop and optimise data solutions, including database schemas and SQL performance tuning to ensure reliable, accessible data for analytics and downstream systems.
  • Integrate data solutions into production environments, collaborating with software engineers and supporting delivery for new and existing clients.
  • Write clean, maintainable code and documentation, covering SQL, Python, PowerShell, models, pipelines, and platform architecture.
  • Support production operations, providing 3rd‑line incident investigation/resolution and contributing to code reviews and engineering best practices.

Requirements

  • Proven experience in data or analytics engineering, with strong foundations in data warehousing, ETL/ELT, and large‑scale analytics environments.
  • Hands‑on expertise with SQL‑based databases (MS SQL Server, Azure SQL, Postgres) and cloud platforms such as Azure and Snowflake.
  • Strong SQL skills plus working knowledge of Python, PowerShell, and integrating data via APIs.
  • Familiarity with agile delivery, GitHub, Atlassian tooling, and production troubleshooting/incident resolution.
  • Bonus: Experience with Databricks.
Benefits
  • Competitive Compensation: We're offering the right candidate between $85,000 - $110,000 per annum.
  • Hybrid & Flexible Working: Work from anywhere benefits, plus summer hours and extra days off for life’s big moments (including your birthday and wedding).
  • Generous Time Off: 26 days PTO (increasing with service), paid volunteer days, and full support for your wellbeing, including mental health resources.
  • Career & Learning: Access to a top-tier learning platform, career progression plans, and support to create your ideal home workspace.
  • Health & Financial Benefits: Comprehensive medical, dental, and vision coverage, plus a 6% matched retirement plan.
  • Personal Perks: Annual phone reimbursement, onsite gym access, and customizable benefits via our online platform. Plus much more!
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLPythonPowerShellETLELTdata warehousingdata pipelinesdatabase schemasSQL performance tuningdata integration
Soft Skills
collaborationincident investigationproblem resolutioncode reviewsengineering best practices