SORM - Strategy Support | AI amp; Power Platform Solu

Please paste the following URL into a browser to view the entire job posting on the CAPPS Careers page.https://erphcmprd.cpa.texas.gov/psp/candidateportal/EMPLOYEE/HRMS/c/HRS\_HRAM\_FL.HRS\_CG\_SEARCH\_FL.GBL?Page=HRS\_APP\_JBPST\_FLandAction=UandFOCUS=ApplicantandSiteId=1andJobOpeningId=105986andPostingSeq=1Job DescriptionGENERAL DESCRIPTIONThe State Office of Risk Management administers the workers compensation program, insurance and risk management programs, and the continuity of operations program for other state entities. SORM is seeking an experienced Systems Analyst to assist with analyzing and identifying user requirements, procedures, and problems to automate processing or to improve existing systems, with a specialized focus on artificial intelligence (AI) systems coordination, SharePoint development, and database/Power Platform administration. Responsibilities include helping the agency evaluate, manage, and establish policies for AI systems; administering and tracking staff utilization of AI tools; serving as the subject matter expert (SME) for custom SharePoint development; and acting as a database administrator with knowledge in designing and maintaining Power BI reports and Power Apps workflows. As a state employee, you are automatically enrolled in the states retirement plan and are eligible for additional health insurance benefits.ESSENTIAL POSITION FUNCTIONSPolicy Development and Alignment: Assists in the development, implementation, and continuous improvement of SORM's artificial intelligence (AI) policies, procedures, and strategies to support the agency's operational goals.AI System Registry and Tracking: Establishes, maintains, and actively tracks a central registry of all AI tools, large language models (LLMs), and machine learning applications utilized by SORM staff, ensuring alignment with data governance and security protocolsRisk and Feasibility Analysis: Performs analysis on new and emerging AI platforms for risk, relevancy, and feasibility at SORM. Assesses prompt engineering techniques, model fairness, data quality, and explainability.Governance Frameworks: Ensures that all developed and implemented AI solutions comply with established state and agency AI governance frameworks, responsible AI principles, and ethical standards.Conversational AI Deployment: Develops, tests, and deploys custom Microsoft Copilot Studio chatbot solutions and generative AI features from design through production, including requirements gathering, conversational flow mapping, and performance monitoringSharePoint Engineering: Performs senior-level system administration, development, and site customization in SORM's SharePoint environment. Ensures platform reliability, security, custom branding, and optimized usabilitySubject Matter Expertise: Acts as SORM's agency-wide Subject Matter Expert (SME) for SharePoint development; engages with internal stakeholders to gather business needs and translate them into custom SharePoint pages, layouts, and libraries.Custom SPFx Solutions: Designs, develops, and implements tailored SharePoint solutions utilizing SharePoint Framework (SPFx), Power Automate, and canvas Power Apps to replace outdated workflows and automate manual processes.Platform Integrations: Connects SORM's SharePoint Online environment with other enterprise cloud systems, including Microsoft Teams, Dynamics 365, and third-party APIs.Content Migration and Tech Support: Utilizes the SharePoint Migration Tool to transfer legacy file shares and content to SharePoint Online. Provides technical troubleshooting, trains end-users, and drafts best practice documentationDatabase Administration: Maintains the structural design, data integrity, capacity planning, and security of SORM's relational databases, semantic models, and data flowsPower Platform Governance: Oversees the administration, licensing structures, environment provisioning, and security integration of SORM's Microsoft Power Platform (including Power BI, Power Apps, and icrosoft Fabric)Advanced Power BI Reporting: Designs, develops, and administers advanced Power BI reports, semantic data models, dataflows, and dashboards. Implements and enforces strict Row-Level Security (RLS) policies to protect confidential dataBusiness Apps Development: Designs, builds, and deploys secure and scalable model-driven and canvas Power Apps integrated with SharePoint, SQL Server databases, and Azure Active DirectoryPerformance and Compliance: Monitors workspace compliance, capacity workloads, and dataset refresh schedules. Collaborates with security and licensing teams to ensure all configurations adhere to enterprise security guidelinesRequirements Analysis and Specifications: Analyzes current or proposed SORM procedures, information systems, and utility programs. Translate complex business needs into clear functional specifications and technical requirementsWorkflow and Prototyping: Designs, modifies, and implements revised processes to improve agency workflow. Prototypes user interfaces and workflows (such as wireframes and mockups) to align stakeholders, reduce rework, and ensure critical requirements are metData Quality and Migration: Supports data migration planning, mapping, cleansing, and reconciliation across legacy platforms and cloud systemsTechnical Documentation: Prepares analytical reports, study findings, cost-benefit diagrams, flowcharts, and instructions for proposed systems. Documents technical specifications from requirements through deploymentCommunity Support and Mentorship: Assists with developing and supporting SORM's internal data and AI community through user group research, training opportunities, and mentorshipAttendance and Service: Attends work regularly and observes approved work hours in accordance with SORM leave and attendance policies. Performs other duties as assignedPerforms related work as assigned.Maintains relevant knowledge necessary to perform essential job functions.Attends work regularly in compliance with agreed-upon work sche