AI Developer / AI-Assisted Data Engineer / Data Modernization Engineer

About this role

AI Developer / AI-Assisted Data Engineer / Data Modernization Engineer:


The client is seeking an experienced AI Developer / AI-Assisted Data Engineer to support a large-scale enterprise data modernization initiative leveraging AI-assisted development and Microsoft Fabric technologies. The ideal candidate will help transform decentralized campus reporting assets and legacy Oracle-based CAP environments into scalable, governed, reusable enterprise data products within a modern Fabric lakehouse architecture.


This role combines advanced data engineering, AI-assisted automation, metadata discovery, and enterprise modernization practices to accelerate migration from legacy reporting platforms into a scalable cloud-based ecosystem. The candidate will work collaboratively with architects, extraction teams, engineering teams, and campus IT stakeholders to establish repeatable modernization frameworks for systemwide deployment.


The position requires deep expertise in Microsoft Fabric, PySpark, SQL, Python, ETL/ELT processes, AI-assisted development tools such as Copilot, and enterprise-scale data transformation initiatives. Strong analytical, automation, and collaboration skills are essential.


Key Responsibilities

• Develop automated scanning and inventory tools for Access, Excel, Power BI, SQL Server, and Oracle-based CAP environments.
• Identify Oracle dependencies, reporting assets, data sources, and usage patterns across pilot campus environments.
• Capture, structure, and analyze metadata to support AI-driven prioritization of data modernization initiatives.
• Design and develop Bronze, Silver, and Gold data layers within Microsoft Fabric lakehouse environments.
• Build scalable ETL/ELT pipelines, transformations, and reusable enterprise data products in Microsoft Fabric.
• Utilize AI-assisted development tools to automate code generation, metadata analysis, modernization workflows, and migration activities.
• Refactor legacy CAP assets into ...