Über diese Data Engineer (Store Support Center, Overland Park, KS) Stelle bei Ace Hardware
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:
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.