
Data Engineer II
Retail Insight
full-time
Posted on:
Location Type: Hybrid
Location: Chicago • Illinois • United States
Visit company websiteExplore more
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