AI Developer

Contractor is 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., 1. CAP Inventory & Metadata Discovery

• 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 (1 college, 3 universities, system office) 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

2. Data Engineering & Fabric Development

• 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

3. AI-Assisted Development

• 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

4. Validation & Testing

• Perform reconciliation between REPL and Fabric outputs
• Ensure data accuracy, completeness, and performance

7. Documentation & Knowledge Transfer

• Document tools, scripts, and methodologies
• Contribute to repeatable migration playbooks
• Support training and onboarding materials

Do you have experience in Spark implementation?, * 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+ ETL/ELT and data modeling
• 3+ years of extensive AI-assisted development tools (e.g. Copilot)
• 3+ years of extensive experience with PySpark required
• 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

$90 - $100 an hour - Contract, Pulled from the full job description

• Continuing education credits
• Health insurance
• 401(k) matching
• Vision insurance
• Dental insurance
• Paid sick time
• Life insurance, * Collaborates with:

• Campus IT teams
• Data team

Benefits + Perks

Comprehensive Benefit Plan

Hollstadt offers medical, dental, vision, life insurance, short-term disability, long-term disability, paid sick leave, and retirement benefits to eligible employees. With three different medical plans to choose from, you can enroll in the coverage you need from individual to family, or anywhere in between!

Remarketing Process

Hollstadt is based on retention and relationships. We get to know your strengths and career wishes throughout your assignment and then start remarket discussions 6-8 weeks prior to your end date. By being proactive, we are able to keep your down time between assignments as short as possible, unless you choose otherwise.

Professional Development

Hollstadt offers on-demand training through our consultant portal. Trainings give our consultants the continuing education they need to excel on their projects. Many of our courses apply towards continuing education credits and we have an entire training hub dedicated to upskilling in Artificial Intelligence (AI).

401k + Matching

One popular benefit is our 401(k) match on the first 4% of your contributions. Hollstadt wants to help you reach your long-term financial goals and understands that planning for your future is critical. Consultants also have access to support from a Financial Advisor.

Bonus Opportunities

We appreciate and reward loyalty. Join Hollstadt, stay for 5 years, and we'll give you a $5,000 Longevity Award bonus! Additionally, we know great talent knows other great talent. If you are on contract with Hollstadt and refer one of your connections who gets placed, we'll pay you $1,000!

Ongoing Support & Networking

We have made a significant investment in building a support program for our consultant team - so you never have to feel like you are going it alone. We also have a Consultant Coach program which acts like a 'work buddy' to provide a safe ear for questions or concerns at your client site.

Hollstadt Consulting is a management and technology consulting firm dedicated to placing professionals at engagements where they will excel. When you work with us, you'll work with a refreshingly real company led and staffed by seasoned experts who are also down-to-earth, good people. We're committed to treating you with respect and helping you achieve your career aspirations. Since 1990, Hollstadt has been a trusted partner to more than 150 domestic and global companies and has successfully completed over 3,000 projects. Our continued growth has created challenging and rewarding opportunities for accomplished IT and Business Consultants. Hollstadt Consulting is an equal opportunity employer including disability/veteran. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Hollstadt Consulting and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel at any time.