Data Engineer (Store Support Center, Overland Park, KS)

Westlake Ace Hardware•Overland Park, KS
•$85,000

About The Position

The Data Engineer designs, builds, tests, deploys, and supports data engineering solutions on the Microsoft Fabric platform. The role creates reliable data pipelines, lakehouses, warehouses, and curated data products that enable reporting, analytics, and AI. It partners with business, analytics, and IT teams to transform source-system data into trusted, well-governed enterprise data. Ace Retail Group (ARG), a division of Ace Hardware Corporation, owns and operates several Ace brands and more than 260 neighborhood stores nationwide. The company is headquartered in Overland Park, Kansas, and emphasizes personal and professional growth and its Core Values: Winning, Excellence, Love, Integrity, Gratitude, Humility, and Teamwork. This position is in the Information Technology department and reports to the Senior Manager, Data Analytics & Reporting. It is exempt and salaried.

Requirements

  • At least 3 years of experience in data engineering, ETL/ELT development, analytics engineering, business intelligence, or a 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 applications, and on-premises 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 and the ability to discuss requirements and technical concepts with technical and non-technical stakeholders.
  • Self-motivated and detail-oriented, with the ability to prioritize multiple assignments in a fast-paced, changing environment.
  • Ability to exhibit and incorporate the company's Core Values into daily decisions and interactions.

Nice To Haves

  • Bachelor's degree in computer science, information systems, data engineering, or a related field, or an equivalent combination of education and experience (listed as preferred).
  • Microsoft Certified: Fabric Data Engineer Associate (DP-700).
  • Prior retail data experience.

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, business-ready data products.
  • Integrate data from on-premises and cloud databases, files, APIs, SaaS applications, and enterprise systems using appropriate Fabric and Azure connectivity patterns.
  • Create dimensional models, curated tables, and data structures supporting Power BI semantic models, Direct Lake reporting, analytics, and AI use cases.
  • Implement data quality checks, reconciliation controls, metadata, lineage, logging, monitoring, and alerting to ensure data is accurate, complete, and timely.
  • Apply established security and governance standards, including workspace access, permissions, sensitivity, 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; and optimize solutions for reliability, scalability, and cost.
  • Create and maintain technical documentation, data mappings, operating procedures, support runbooks, and recovery instructions.
  • Work with internal customers, analysts, application teams, and source-system owners to understand requirements, resolve data issues, and deliver solutions.
  • Incorporate Ace Retail Group's Core Values into daily decisions and interactions.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service