Skip to content

REQ-35112

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

Overland Park, Kansas Retail

About Ace Retail Group

Ace Retail Group (ARG), is a division of Ace Hardware Corporation that owns and operates several Ace brands, including Westlake Ace, Great Lakes Ace, Buikema’s Ace, Outer Banks Ace, Dennis Company, and Breed & Company. ARG is one of the largest hardware retailers in the United States and has two headquarters located in Lenexa, KS and Farmington Hills, MI. ARG’s origins date back over a century and operates over 250 neighborhood stores located throughout the United States. Great people make ARG stand out in our industry, and we are looking for individuals who strive for personal and professional growth, and who want to work with a company founded on (and still led by) our solid Core Values of: Winning, Excellence, Love, Integrity, Gratitude, Humility and Teamwork.

Job Title: Data Engineer

Department: Information Technology

Reports To: Senior Manager, Data Analytics & Reporting

Exemption Status: Exempt (Salary)

About Ace Retail Group, Inc.

Ace Retail Group (ARG) is a division of Ace Hardware Corporation that owns and operates several well-known Ace brands, including Westlake Ace, Great Lakes Ace, Buikema’s Ace, Outer Banks Ace, Dennis Company, and Breed & Company. As one of the largest hardware retailers in the United States, ARG operates more than 260 neighborhood stores nationwide and is headquartered in Overland Park, Kansas.

With roots dating back over a century, ARG’s success is driven by its people. What truly sets us apart in the industry is our commitment to hiring and developing individuals who are passionate about personal and professional growth and who want to be part of a company built on strong, enduring Core Values:

Winning, Excellence, Love, Integrity, Gratitude, Humility and Teamwork

General Job Summary

The Data Engineer position will be responsible for designing, building, testing, deploying, and supporting data engineering solutions on the Microsoft Fabric platform. This position will create reliable data pipelines, lakehouses, warehouses, and curated data products that enable reporting, analytics, and AI. The role will partner with business, analytics, and IT teams to transform source-system data into trusted, well-governed enterprise data.

Essential Duties and 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 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 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.

Other Essential Requirements

Ability to exhibit and incorporate our Core Values into daily decisions and interactions with others:

o WINNING - In business, money is the score. To win, we must perform, compete, and have fun. At Ace, we win through people - our strength is being helpful.

o EXCELLENCE - Excellence honors God and inspires people. We aspire to be the best, to continuously improve and to inspire others by giving the team our very best.

o LOVE - Love the people, love the work and love the results.

o INTEGRITY - For Ace to win, we need to be able to trust each other. And trust will require us to be honest, reliable, caring, of high character and of unquestioned ethics.

o GRATITUDE - We recognize that we are blessed to be in the business of serving others.

o HUMILITY - We strive for greatness with a humble, modest and respectful attitude.

o TEAMWORK - We will fight the natural tendency for control and credit in favor of collaboration and mutual success, recognizing that...Together, we are Ace.

Minimum Skills, Requirements and Qualifications

• Bachelor's degree in computer science, information systems, data engineering, or a related field, or an equivalent combination of education and experience, preferred.

• 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, with the ability to discuss requirements and technical concepts with technical and non-technical stakeholders.

• Self-motivated, detail-oriented, and able to prioritize multiple assignments in a fast-paced and ever-changing environment.

• Microsoft Certified: Fabric Data Engineer Associate (DP-700) and prior retail data experience are preferred.


Compensation Details

Starting at $85000 per year

For a full list of benefits and open positions, please visit us at: https://acehardware.wd1.myworkdayjobs.com/en-US/ARG_External

Want to be notified when new jobs are posted? Follow the link below to create an account and set up custom job alerts:

Create Job Alert

Equal Opportunity Employer
Ace Retail Group is committed to a policy of promoting equal employment opportunities. The company recognizes the importance of diversity and leveraging the skills and talents of all people to the mutual advantage of each individual and the organization. The company is committed to the prevention of employment discrimination related to race, religion, color, sex (including sexual harassment), gender identity, national origin, age, marital status, disability and military discharge, or any other action covered by federal or state laws.

Life at Ace

Find out how we’ve created a one-of-a-kind, passionate and helpful workplace that puts our people first.

Notice to Applicant about this Employer: You are applying for a job with an independently owned and operated cooperative member of Ace Hardware Corporation, who owns and operates this Ace Hardware retail store location. Ace Hardware Corporation is not the employer for this position. The independent store owner alone is responsible for and independently makes all decisions concerning employment related matters, including hiring, firing, discipline, supervision, staffing and scheduling. Ace Hardware Corporation will not receive a copy of any applications submitted for this position, does not control interviews and/or hiring decisions, and has no control over or responsibility for the employment policies and practices of the independent store owner. If hired, the independent store owner will be your only employer. The Ace Hardware trademarks, logos and designs are owned by Ace Hardware Corporation and used by independent store owners under a license from Ace Hardware Corporation.

United Healthcare creates and publishes Machine-Readable Files on behalf of Ace Hardware Corporation | Learn More