Job ID: 11618
Location: St. Paul, Minnesota
Category: IT
Employment Type: Individual Consulting
Date Added: 05/29/2026
Location: Remote
Duration: 6 Month Contract
Overview
Responsible for executing a large-scale pilot data modernization initiative using AI-assisted development to transform decentralized campus reporting assets into governed, reusable data products in Microsoft Fabric.
The position blends data engineering, automation, and applied AI to accelerate migration from legacy on-prem, Oracle database-dependent CAP environments to a modern, scalable data platform. The position works closely and collaboratively with the Data team’s architect, and extraction and engineering experts.
Responsibilities:
• Develop automated scanning tools for Access, Excel, Power BI, SQL Server, and other objects referring to REPL (on-site Oracle database) to be used on pilot schools’ CAP servers and for future use across 33 institutions
• Identify data sources, Oracle dependencies, and usage patterns
• Capture and structure metadata for AI analysis of prioritizing data migration to Fabric
• Develop data needed by campuses into Bronze, Silver, and Gold data layers
• Design and build pipelines and transformations in Microsoft Fabric
• Optimize for scalability, performance, and reuse
• Use AI tools to generate code for inventory and metadata gathering from CAP servers
• Automate analysis and prioritization of data moves to Fabric
• Translate usage patterns into enterprise data products
• Identify data gaps and recommend ingestion strategies
• Refactor CAP server assets to Fabric-based data sources
• Update queries, connections, and data models via AI-generated code
• Develop hybrid modernization approaches (Access front-end, SQL backend)
• Establish repeatable AI-assisted workflows
• Perform reconciliation between REPL and Fabric outputs
• Ensure data accuracy, completeness, and performance
• Document tools, scripts, and methodologies
• Contribute to repeatable migration playbooks
• Support training and onboarding materials
Requirements:
• 10+ years of experience in enterprise-level data engineering, analytics, or data architecture
• 5+ years of advanced SQL skills
• 5+ years of advanced Python
• 5+ years of ETL/ELT and data modeling
• 3+ years of extensive experience with AI-assisted development tools (e.g. Copilot)
• 3+ years of extensive experience with PySpark
• 3+ years building and optimizing large-scale data transformations in a Fabric lakehouse environment
• Experience with modern data platforms (Microsoft Fabric)
• Experience with ETL/ELT and data modeling
Expected Outcomes:
• Automated CAP inventory process
• Usage-based prioritization and analysis
• AI-assisted development of high-quality, reusable Fabric data products
• Successful migration of pilot campus assets
• Scalable framework for systemwide rollout
Reporting & Collaboration:
• Campus IT teams
• Data team
The projected hourly range for this position is $70 to $87.
On-Demand Group (ODG) provides employee benefits which includes healthcare, dental, and vision insurance. ODG is an equal opportunity employer that does not discriminate on the basis of race, color, religion, gender, sexual orientation, age, national origin, disability, or any other characteristic protected by law.