Enterprise AI & Automation Analyst
Role details
Job location
Tech stack
Job description
The Enterprise AI & Automation Analyst is a hands-on technical role responsible for designing, building, and deploying AI-powered automation, analytics, and agent-based solutions across St. Petersburg College's enterprise systems and data platforms.
This role works at the intersection of Microsoft Fabric, local AI infrastructure, and institutional business processes. Core responsibilities include building and maintaining the College's Fabric IQ Ontology as a governed semantic foundation for AI-driven analytics; designing and deploying Fabric Data Agents that enable conversational, natural-language access to institutional data; and participating in the build-out and operation of a local, on-premise AI environment using Ollama and open-source models. The analyst also serves as the primary point of contact for connecting the college community with AI capabilities and identifying use cases, building purpose-built agents, and helping departments adopt AI tools effectively.
The analyst works closely with enterprise application teams, data engineers, and business stakeholders to deliver production-grade AI solutions that improve operational efficiency, data quality, and decision-making. As SPC transitions from PeopleSoft to Workday, this role will also contribute to modeling Workday-centric data entities within the Fabric IQ Ontology and developing AI agents that surface insights from the College's evolving enterprise ecosystem.
Success in this role is defined by building working systems that integrate with enterprise platforms, enabling broader institutional access to AI, and generating measurable operational outcomes., Enterprise Applications & Business Intelligence oversees the College's critical software systems and data platforms, unifying student, financial, and administrative systems to support SPC's core operations and strategic goals. The team manages and optimizes enterprise platforms such as PeopleSoft (Campus Solutions, HCM, FSCM) and supports enterprise analytics and reporting on Microsoft Fabric. The department also manages SharePoint-based business processes, Power Automate workflows, enterprise system integrations, and data governance frameworks that enable secure, reliable, and scalable digital services across the institution., Fabric AI & Ontology
- Build and maintain the College's Fabric IQ Ontology, defining entity types, relationships, properties, and business rules that establish a shared semantic foundation across institutional data domains.
- Evolve the ontology to reflect SPC's transition from PeopleSoft to Workday, modeling Workday-centric HCM, Finance, and Student entities as the new ERP ecosystem comes online.
- Design, build, and deploy Microsoft Fabric Data Agents that provide conversational, natural-language access to governed datasets stored in OneLake, including lakehouses, warehouses, and Power BI semantic models.
- Develop and refine prompt engineering strategies, agent instructions, and contextual grounding to ensure Data Agents return accurate, institution-specific responses aligned with SPC's data governance standards.
- Embed AI-driven narratives, anomaly detection, and decision-support features into Power BI reports aligned with institutional priorities.
On-Premise AI Infrastructure
- Participate in the design, deployment, and administration of a local on-premise AI environment based on Ollama and open-source language models.
- Evaluate, test, and recommend local models for specific institutional use cases, balancing performance, privacy, cost, and compliance requirements.
- Develop and maintain Python-based services, notebooks, and pipelines that integrate local AI capabilities with enterprise systems and workflows using software engineering best practices (version control, testing, documentation).
AI Enablement & Community Engagement
- Serve as the primary liaison between the Enterprise Applications & BI team and the broader college community for AI adoption.
- Identify, evaluate, and prioritize high-impact AI use cases across academic and administrative departments.
- Build purpose-built agents and automated workflows tailored to departmental needs, including service request handling, document processing, onboarding workflows, and data analysis.
- Design and implement AI-enhanced workflows using SharePoint and Power Automate for service intake, onboarding, and business process automation.
- Integrate AI capabilities into SharePoint-based forms and Power Automate flows to classify requests, extract structured data, route cases, and trigger enterprise actions.
- Provide guidance, training, and hands-on support to help staff and faculty effectively utilize local and cloud-based AI tools.
Governance, Security & Documentation
- Ensure all AI solutions comply with FERPA, data governance standards, accessibility requirements, and institutional security policies.
- Document data flows, AI configurations, ontology definitions, agent instructions, access controls, and operational procedures for each deployed solution.
- Collaborate with Information Security and Infrastructure teams on risk reviews, approvals, and operational readiness.
- Partner with Enterprise Applications and Data Engineering teams to ensure solutions meet production standards for performance, reliability, and maintainability., Sedentary work: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.
Light work: Exerting up to 20 pounds of force occasionally, and/or up to 10 pounds of force to move objects.
Medium work: Exerting up to 50 pounds of force occasionally, and/or up to 30 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects.
Heavy work: Exerting up to 100 pounds of force occasionally, and/or up to 50 pounds of force frequently, and/or up to 20 pounds of force constantly to move objects.
Very heavy work: Exerting in excess of 100 pounds of force occasionally and/or in excess of 50 pounds of force frequently, and/or in excess of 20 pounds of force constantly to move objects
WORK ENVIRONMENT
May be required to work hours other than the regular schedule including nights, weekends, and holidays.
Work is performed in a safe and secure work environment that may periodically have unpredicted requirements or demands.
Requirements
Do you have experience in Systems integration?, Do you have a Bachelor's degree?, Bachelor's degree in information systems or a related field; four (4) years of related work experience in area of responsibility; or any equivalent combination of education, training, and experience which provides the requisite knowledge, skills, and abilities for this job.
- Strong proficiency with Python and SQL for data processing, integration, and automation.
- Demonstrated skill in prompt engineering, including designing system prompts, agent instructions, and contextual grounding for large language models.
- Experience working with enterprise data platforms (data lake and data warehouse concepts; Spark or equivalent processing frameworks).
- Experience integrating systems using APIs, connectors, or messaging patterns.
- Working knowledge of data privacy, security, and governance principles in enterprise environments., * Experience with Microsoft Fabric, including Data Agents, semantic models, Fabric IQ Ontology, or related workloads.
- Experience with retrieval-augmented generation (RAG) architectures, including vector databases (e.g., Chroma, pgvector, Qdrant, Milvus) and embedding-based search pipelines.
- Experience with Azure services related to data, AI, and integration.
- Experience deploying or administering local/on-premise AI environments using Ollama, vLLM, or similar open-source inference frameworks.
- Experience with SharePoint, Power Automate, Power BI, or the Microsoft Power Platform.
- Experience with PeopleSoft, Workday, or another ERP system in higher education or similarly regulated environments.
- Familiarity with intelligent document processing or workflow automation tools.
KNOWLEDGE, SKILLS AND ABILITIES
Knowledge of:
AI and large language model concepts, including prompt engineering, retrieval-augmented generation, and agent-based architectures; enterprise data platform design, semantic modeling, and ontology development; systems analysis and design principles; data governance, privacy, and security frameworks (including FERPA); process improvement principles; and project management principles.
Skills in:
Prompt engineering and AI agent design; Python programming and scripting; SQL and data querying across relational and analytical platforms; building and maintaining enterprise ontologies and semantic layers; communicating technical AI concepts to non-technical audiences; training and enabling end users on AI tools; and establishing and following procedural and technical standards.
Ability to:
Translate business requirements into AI-driven solutions; evaluate and recommend AI models and tools for specific use cases; build collaborative relationships across technical and non-technical teams; troubleshoot applications, data pipelines, and AI systems; adapt to an evolving enterprise technology landscape, including ERP transitions; and interpret and respond to evolving institutional needs., Balancing and maintain equilibrium to prevent falling while walking, standing, or crouching.
Pushing and use upper extremities to press against objects with force, or thrust forward, downward, outward.
Climbing and ascending, descending ladders, stairs, ramps, requires body agility.
Reaching and extending hands or arms in any direction., Speaking and expressing ideas with spoken word, convey detailed, important instructions accurately, concisely., Standing and for sustained periods of time.
Fingering and picking, pinching, typing, working with fingers rather than hand.
X
Stooping and bending body downward, forward at waist, with full motion of lower extremities and back.
Grasping and applying pressure to object with fingers, palm.
X
Talking 1 and expressing ideas by spoken word., Visual Acuity 1 and prepare, analyze data, transcribing, computer terminal, extensive reading., Kneeling and bending legs at knee to come to rest at knees.
Visual Acuity 3 and determine accuracy, neatness, observe facilities/structures.
X
Lifting and raising objects from lower to higher position, moving objects side to side, using upper extremities, back.
Visual Acuity 4 and operate motor vehicles/heavy equipment.
Mental Acuity and ability to make rational decisions through sound logic, deductive reasoning.
X
Visual Acuity 5 and close acuity for inspection of small defects, machines, use measurement devices, or fabricate parts.
Pulling and use upper extremities to exert force, haul or tug.
Benefits & conditions
Pulled from the full job description
- Professional development assistance
- Tuition reimbursement
- Parental leave
- Health insurance
- Retirement plan
- Paid time off
- Employee discount, * Dental insurance
- Employee discount
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Parental leave
- Professional development assistance
- Retirement plan
- Tuition reimbursement