Data Engineer - Store Data & Fabric Pipelines

Ace Retail Group, Inc.

Overland Park (KS)

On-site

USD 77,000 - 94,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ace Retail Group is seeking a Data Engineer to design, build, and operate data pipelines and lakehouse/warehouse solutions from the Store Support Center in Overland Park, Kansas. You will transform source-system data into trusted enterprise data for reporting, analytics, and AI, working with business, analytics, and IT teams.

You will implement quality checks, security standards, and governance while using Fabric, Python, SQL, and Spark to deliver scalable data products that support Power BI and

Qualifications

  • Bachelor's degree in computer science, information systems, data engineering, or related field, or equivalent experience.
  • 3+ years of experience in data engineering, ETL/ELT development, analytics engineering, BI, or related discipline.
  • Hands-on experience with Microsoft Fabric or comparable Azure data services such as Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, or Databricks.
  • Strong SQL skills and experience with relational databases, data warehousing, dimensional modeling, and performance tuning.
  • Experience developing data transformations with Python and PySpark or Apache Spark.
  • Experience with lakehouse and warehouse concepts, Delta/Parquet data, notebooks, pipelines, and layered data architecture.
  • Experience integrating data from SQL Server, ERP or retail systems, flat files, APIs, SaaS apps, and on-prem sources.
  • Experience with Git-based source control, Azure DevOps or GitHub, CI/CD practices, and automated deployment.
  • Understanding of data quality, security, governance, lineage, monitoring, and production support practices.
  • Strong communication skills, with ability to discuss requirements with technical and non-technical stakeholders.
  • Self-motivated, detail-oriented, and able to prioritize multiple assignments in a fast-paced environment.
  • Microsoft Certified: Fabric Data Engineer Associate (DP-700) and prior retail data experience preferred.

Responsibilities

  • Design, build, test, and support scalable data ingestion, transformation, and orchestration solutions using Microsoft Fabric.
  • Develop and maintain Fabric pipelines, notebooks, lakehouses, warehouses, dataflows, and other data engineering components within OneLake.
  • Use SQL, Python, and PySpark to transform data through Bronze, Silver, and Gold layers and produce reusable data products.
  • Integrate data from on-premises and cloud databases, files, APIs, SaaS applications, and enterprise systems using Fabric/Azure connectivity patterns.
  • Create dimensional models, curated tables, and data structures that support Power BI semantic models, Direct Lake reporting, analytics, and AI use cases.
  • Implement data quality checks, reconciliation controls, metadata, lineage, logging, monitoring, and alerting.
  • Apply security and governance standards, including workspace access, permissions, retention, and protection of confidential information.
  • Use Git, Azure DevOps, Fabric deployment pipelines, and automated testing to manage source control and promote solutions through development, test, and production.
  • Monitor pipeline, Spark, SQL, and capacity performance; troubleshoot failures; optimize for reliability, scalability, and cost.
  • Create and maintain technical documentation, data mappings, operating procedures, runbooks, and recovery instructions.
  • Collaborate with internal customers, analysts, application teams, and source-system owners to understand requirements and deliver solutions.

Skills

Data engineering
SQL proficiency
PySpark / Apache Spark
Azure data services
Git / CI/CD
Data governance & security

Education

Bachelor's degree in CS/IS/Data Engineering

Tools

Microsoft Fabric
Azure Data Factory
Azure Synapse Analytics
Azure Data Lake Storage
Databricks

Job description

Ace Retail Group is seeking a Data Engineer to design, build, and operate data pipelines and lakehouse/warehouse solutions from the Store Support Center in Overland Park, Kansas. You will transform source-system data into trusted enterprise data for reporting, analytics, and AI, working with business, analytics, and IT teams.

You will implement quality checks, security standards, and governance while using Fabric, Python, SQL, and Spark to deliver scalable data products that support Power BI and

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer: AI-Ready Data Pipelines
Data Engineer: AI-Ready Data Pipelines

Koch Business Solutions, LP • Wichita (KS)

On-site
USD 110,000 - 140,000
Data Engineer: Build Scalable Pipelines & Data Lakes
Data Engineer: Build Scalable Pipelines & Data Lakes

Yankalatam • United States

Remote
USD 120,000 - 180,000
Data Engineer - Microsoft Fabric: Lakehouse & Pipelines
Data Engineer - Microsoft Fabric: Lakehouse & Pipelines

NextPhase.ai • San Mateo (CA)

On-site
USD 120,000 - 180,000
Data Engineer: AI-Driven Data Pipelines & Integrations
Data Engineer: AI-Driven Data Pipelines & Integrations

Computationaldesign • Berkeley (CA)

On-site
USD 111,000 - 166,000
Data Engineer – Pipelines & Data Warehouse Specialist
Data Engineer – Pipelines & Data Warehouse Specialist

Base Operations • United States

Remote
USD 90,000 - 130,000
Fabric Data Engineer: Build Scalable Pipelines & Lakehouse
Fabric Data Engineer: Build Scalable Pipelines & Lakehouse

Tata Consultancy Services Limited • Dallas (TX)

On-site
USD 120,000 - 135,000
Data Engineer
Data Engineer

EdgeQ Technologies Private Limited • United States

On-site
USD 120,000 - 180,000
Data Engineer: Enterprise Pipelines & Analytics (Dallas)
Data Engineer: Enterprise Pipelines & Analytics (Dallas)

Business Centric Technology • Dallas (TX)

On-site
USD 126,000 - 154,000
Health care plan
Retirement plan
Life insurance
+3
Data Engineer - AI-Driven Pipelines & Quality
Data Engineer - AI-Driven Pipelines & Quality

SCOR Group • Leawood (KS)

On-site
USD 95,000 - 165,000
DATA ENGINEER
DATA ENGINEER

Black Financial Consulting Group • Snowflake (AZ)

On-site
USD 120,000 - 160,000