Data Engineer and Agentic AI Lead

Garan, Incorporated
New York, NY

Overview

We are seeking a Microsoft Fabric Data Engineer with Agentic AI experience to design, build, and maintain scalable data solutions within the Microsoft Fabric ecosystem. This role is responsible for developing robust data pipelines, implementing Medallion architecture (Bronze, Silver, Gold layers), and ensuring high-quality, analytics-ready datasets.

The ideal candidate will have hands-on experience with Microsoft Fabric components (Data Factory, OneLake, Lakehouse, Warehouse, and Power BI), strong data engineering fundamentals, and the ability to support advanced analytics and AI initiatives.

Key Responsibilities

  • Design, develop, and maintain end-to-end data pipelines using Microsoft Fabric (Data Factory, Pipelines, Notebooks)
  • Implement and manage Medallion architecture (Bronze, Silver, Gold layers) to ensure data quality, governance, and usability
  • Ingest, transform, and integrate data from multiple structured and unstructured sources
  • Optimize data workflows for performance, scalability, and cost efficiency
  • Build and maintain Lakehouse and Data Warehouse solutions within Fabric
  • Ensure data reliability through monitoring, logging, and error-handling mechanisms
  • Collaborate with stakeholders to translate business requirements into scalable data solutions
  • Enforce data governance, security, and compliance best practices
  • Document data models, pipelines, and system architecture
  • Contribute to roadmap planning and platform evolution

Database & Power BI Oversight

  • Design enterprise-grade data models optimized for Power BI and analytics workloads
  • Oversee creation and management of semantic models and datasets within Fabric
  • Oversee dataset performance, refresh strategies, and capacity management in Power BI
  • Implement data modeling best practices (star schema, normalization where appropriate)
  • Support development of dashboards and reports by providing curated, high-quality datasets
  • Manage access control, row-level security (RLS), and data lineage visibility
  • Manage Power BI capacity, dataset refresh strategies, and scalability considerations
  • Collaborate with BI developers to optimize DAX performance and reporting efficiency
  • Monitor usage and adoption metrics to improve data accessibility and usability

AI Readiness & Advanced Analytics

  • Prepare and structure data to support AI/ML use cases within Microsoft Fabric and Azure ecosystem
  • Enable feature engineering by delivering clean, enriched, and well-governed datasets
  • Support integration with AI tools such as Azure Machine Learning, Fabric Data Science, and Copilot experiences
  • Implement data pipelines that support real-time or near real-time analytics where needed.
  • Ensure datasets are scalable and aligned with AI model training requirements.
  • Promote best practices for data versioning, reproducibility, and experimentation.

Qualifications

  • Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or related field.
  • 7+ years of experience in data engineering or related roles.
  • Hands-on experience with Microsoft Fabric or closely related tools (Azure Synapse, Azure Data Factory, Power BI).
  • Strong expertise in Medallion architecture and modern data lake/lakehouse patterns.
  • Proven experience building and maintaining data pipelines (ETL/ELT).
  • Proficiency in SQL, Python, and/or Spark.
  • Experience with Lakehouse architectures and distributed data processing.
  • Strong understanding of data modeling and data warehousing concepts.

Desired Skills & Competencies

  • Experience with OneLake, Delta Lake, and Fabric-native workloads.
  • Experience with Data Agents, Copilot Studio and Microsoft Foundry
  • Familiarity with CI/CD pipelines for data solutions.
  • Power BI adoption and user satisfaction across business units.
  • Delivery of AI-ready datasets and agentic AI pilot outcomes
  • Security compliance and incident prevention

Key Competencies

  • Strong problem-solving and analytical thinking
  • Attention to detail and data quality focus
  • Ability to work cross-functionally with technical and business teams
  • Excellent communication and documentation skills
  • Continuous learning mindset in evolving data and AI technologies

Performance Metrics

  • Data integrity and availability across all departments
  • System uptime and query performance
  • Power BI adoption and user satisfaction across business units
  • Reduction in time-to-action based on data insights
  • Successful onboarding and reliability of third-party integrations
  • Delivery of AI-ready datasets and agentic AI pilot outcomes
  • Security compliance and incident prevention
  • Adoption of best practices as informed by industry trends

This role is essential for Garan Apparel's enterprise data transformation, integrating Azure and Microsoft Fabric with best practices in data, security, AI readiness, and team collaboration—while ensuring that every user, from executive to analyst, can understand, trust, and act on data with confidence.

Salary : $150,000

Posted 2026-05-06

Recommended Jobs

Senior Mechanical Engineer

The LiRo Group
Syosset, NY

Senior Mechanical Engineer US-NY-Syosset Job ID: 2026-3329 Type: Regular Full-Time # of Openings: 1 Category: MEP The LiRo Group Overview We have an immediate need for a …

View Details
Posted 2026-05-06

Mental Health Counselor

Community Health Center of Buffalo
Buffalo, NY

**Job Summary:** The Mental Health Counselor will be responsible for performing case management and counseling activities related to the bio-psychosocial needs affecting the health and well-being of …

View Details
Posted 2026-02-18

Commodity Manager

INFICON
East Syracuse, NY

Company Description INFICON is a leading provider of innovative instrumentation, critical sensor technologies, and Smart Manufacturing/Industry 4.0 software solutions that enhance productivity and…

View Details
Posted 2026-04-24

Remote Cruise Travel Planner — Flexible Hours & Perks

Explore More Travel with Fran
New York, NY

A travel agency is seeking a motivated Cruise Travel Coordinator to assist clients with planning cruise vacations from a remote workspace. Responsibilities include researching cruise options, preparin…

View Details
Posted 2026-05-01

Real Estate Buyer's Agent (Hopewell Junction)

Berkshire Hathaway HomeServices New England Properties
Hopewell Junction, NY

DESCRIPTION: Are you passionate about helping people make one of the most important decisions of their lives? As a Real Estate Buyer's Agent , you will be dedicated to representing and guiding buye…

View Details
Posted 2026-05-01

High School US History Tutor- Saturday Academy

Toolkit Tutors
Queens, NY

We are seeking a talented  US History tutor to provide in-person support to students at a Queens NYCDOE school. This role focuses on helping students build strong foundational skills, improve problem…

View Details
Posted 2026-04-30

Pediatric Hospice APRN - Manhattan (New York City)

Jobot
New York, NY

Hospice Nurse Practitioner - 15K Sign on Bonus, PENSION & weekly hybrid work schedule This Jobot Job is hosted by: Donna Gawroski-Kusik Are you a fit? Easy Apply now by clicking the Apply butto…

View Details
Posted 2026-04-30

Business Developer - Event & Corporate Gifting

Mejuri
New York, NY

Mejuri is the category-defining fine jewelry brand redefining luxury, your way. Feeling disconnected from an industry that typically markets to men, co-founder and CEO Noura Sakkijha leveraged her le…

View Details
Posted 2026-04-28

Receptionist- CSK

Garnet Health
Harris, NY

: Overview: At Garnet Health, the Hudson Valley's leading integrated health system, you'll find the perfect balance of a satisfying career and a rewarding lifestyle. Our focus is on patient-centric …

View Details
Posted 2026-04-30

Director - Utility Operations Services

PSEG
Hicksville, NY

Director Utility Operations Services Requisition : 82419 PSEG Company : PSEG Long Island Salary Range : $ 161,200 - $ 264,900 Work Location Category : Onsite - Hicksville, NY PSEG is n…

View Details
Posted 2026-05-06