Data Warehouse Engineer

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.

AGS is an equal opportunity employer.