Retail Insight · 1 day ago
Data Engineer II
Chicago, Illinois, United States
Full-time
Hybrid
Mid Level
$85K/yr - $110K/yrRetail Insight is a company that turns data into action, growing its data engineering capability to support major retailers and consumer brands. The Data Engineer role involves building scalable data solutions, maintaining data pipelines, and collaborating with software engineers to enhance platform reliability and client delivery.
RetailBig DataAnalyticsProduct Design
Responsibilities
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
Qualification
Required
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
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
Preferred
Experience with Databricks
Benefits
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.
Company
Retail Insight
Retail Insight is provider of store-focused retail analytics solutions.
Founded in 2005
51-200 employees
H1B Sponsorship
Retail Insight has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2023 (1)
2022 (1)
Funding
Current Stage
Growth StageTotal Funding
unknown2019-07-12Acquired
Recent News
Company data provided by crunchbase