Data Warehouse Engineer

AGS

$90K — $120K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years in data engineering or analytics engineering
  • Hands-on with Microsoft Fabric and cloud data platforms
  • Strong SQL and proficiency in Python or PySpark
  • Experience migrating to cloud architectures
  • Understanding of Delta Lake and data governance
  • Familiar with Power BI and performance tuning
  • Knowledge of streaming technologies and AI integration

Responsibilities

  • Assess current data sources and reporting frameworks
  • Lead migration of BI and ETL processes to Microsoft Fabric
  • Modernize legacy reporting processes with Fabric solutions
  • Design and implement a secure, scalable data architecture
  • Develop and maintain data ingestion and transformation pipelines
  • Build and optimize datasets for reporting and AI workloads
  • Manage platform performance and apply data governance best practices

Benefits

  • Flexible work environment
  • Opportunities for professional development
  • Collaborative and innovative team culture
  • Access to cutting-edge technology and tools
  • Employee wellness programs
Full Job Description
Job Description

Job Overview

AGS is seeking a Data Warehouse Engineer to support Business Intelligence in leading the migration, maintenance and continued enhancement of our on-premise, multi-system reporting environment into Microsoft Fabric. This role will architect, implement, and manage our unified cloud data platform-enabling advanced analytics, AI, self-service reporting, and modern data governance. The ideal candidate has deep experience in data engineering and Microsoft's cloud analytics ecosystem.

Responsibilities

Migration & Architecture
  • Assess current data sources, ETLs, and reporting frameworks.
  • Lead the end-to-end migration of BI, reporting, and ETL processes into Microsoft Fabric (Lakehouse, Warehouse, Pipelines).
  • Modernize or replace legacy SSIS/SSRS/SSAS processes with Fabric-native solutions.
  • Design and implement a centralized, scalable, and secure Fabric data architecture for both batch and streaming data.

Data Engineering
  • Develop and maintain ingestion, transformation, and orchestration pipelines.
  • Build and optimize Delta Lakehouse tables, semantic models, and datasets for reporting and AI workloads.
  • Ensure data quality, lineage, and compliance with governance standards.
  • Integrate data from Business Central, Dynamics Field Service, Salesforce, custom SQL sources, and AGSi streaming data.

Platform Management
  • Manage Fabric capacities, workspaces, permissions, and cost optimization.
  • Monitor platform performance, reliability, and data refresh SLAs.
  • Apply best practices for Fabric security, data governance, and CI/CD automation.

Cross-Functional Collaboration
  • Partner with BI, Data Science, and business teams to enable machine learning and real-time analytics.
  • Support the development of a scalable self-service data and reporting environment.

Skills/Requirements
  • 5+ years of experience in data engineering or analytics engineering.
  • Hands-on experience with Microsoft Fabric, Datawarehouse, Data Lake, Spark, or similar cloud data platforms.
  • Strong SQL skills and proficiency with Python or PySpark.
  • Experience migrating from on-prem SQL/SSIS/SSAS/SSRS to cloud-based architectures.
  • Solid understanding of Delta Lake, medallion architecture, semantic modeling, and data governance.
  • Experience with Power BI dataset modeling and performance tuning.
  • Familiarity with streaming technologies (Event Hub, Kafka, Fabric Real-Time Analytics).
  • Exposure to AI integration, semantic models for AI, or Microsoft Copilot.
  • Experience with Dynamics 365, Business Central, Salesforce, or similar systems is a plus.
  • Strong understanding of cloud security, compliance, and best practices.
  • Any Microsoft certification in a related data, analytics, or MS Fabric field is a plus.

Soft Skills
  • Strong analytical and problem-solving skills.
  • Excellent communication and ability to work with both technical and non-technical teams.
  • Proactive ownership mindset and commitment to continuous improvement.

Note: All offers are contingent upon successful completion of a background check

*Posted positions are not open to third party recruiters and unsolicited resume submissions will be considered free referrals.

Job Snapshot
  • Location:

    Duluth, Georgia
  • Job Type:

    R&D/Game Development
  • Date Posted:

    04/14/2026


Similar Jobs

More Jobs at AGS

More Information Technology Jobs

Find similar Data Warehouse Engineer jobs: