Full Job Description
Job Title: Data Engineer
Department: Information Technology
Reports To: Senior Manager, Data Analytics & Reporting
Exemption Status: Exempt (Salary)
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:
oWINNING - 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.
oEXCELLENCE - 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.
oLOVE - Love the people, love the work and love the results.
oINTEGRITY - 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.
oGRATITUDE - We recognize that we are blessed to be in the business of serving others.
oHUMILITY - We strive for greatness with a humble, modest and respectful attitude.
oTEAMWORK - 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