SharePoint Automation & Reporting Technical Consultant

NTT DATA Services•Springfield, IL
•$81,936 - $170,700•Remote

About The Position

NTT DATA is seeking a principal technical consultant to support the Illinois Medicaid Enterprise System Program Advisory and Support Services (IL MES PASS) account and the Illinois Department of Healthcare and Family Services. The consultant will design, develop, implement, and support SharePoint Online, Microsoft Power Platform, workflow automation, and reporting solutions that improve program operations, governance, collaboration, data quality, and leadership decision-making. The role includes taking ownership of existing automation and reporting solutions, stabilizing and enhancing them, and establishing sustainable support and governance practices. The consultant will work across the full solution lifecycle, including process discovery, requirements analysis, solution design, development, testing, deployment, adoption, documentation, production support, and continuous improvement. The role collaborates with State stakeholders, program leadership, PMO and delivery workstreams, technical teams, consulting resources, systems integrators, and other vendors. It is primarily remote, with the ability to travel up to 25% to Springfield, Illinois, or Chicago, Illinois, if needed.

Requirements

  • Bachelor’s degree in information technology, computer science, management information systems, business analytics, engineering, or a related discipline, or equivalent relevant professional experience.
  • At least five years of experience designing, developing, configuring, implementing, or administering Microsoft SharePoint solutions.
  • At least five years of experience supporting Microsoft 365 applications, services, and integrations.
  • At least three years of experience designing, implementing, and supporting workflow automation solutions.
  • At least three years of experience developing dashboards, analytics, or reporting solutions using Power BI, Tableau, SSRS, or a comparable business intelligence platform.

Nice To Haves

  • Hands-on experience with SharePoint Online, Power Automate, Power Apps, and Power BI.
  • Experience with SharePoint lists, libraries, metadata, content types, permissions, views, and document-management structures.
  • Experience integrating SharePoint and structured data sources with reporting and visualization platforms.
  • Experience with process discovery, requirements gathering, process mapping, solution design, testing, deployment, and production support.
  • Experience assuming ownership of and stabilizing SharePoint or Power Platform solutions developed by others.
  • Experience building Power Automate flows with monitoring, exception handling, retry and timeout controls, alerting, reusable components, and non-personal connection strategies.
  • Experience using Power Platform solutions, connection references, environment variables, and controlled environment promotion.
  • Experience producing technical designs, data models, test scripts, deployment and rollback plans, support runbooks, and solution inventories.
  • Ability to evaluate licensing, connectors, platform constraints, performance, security, scalability, and long-term supportability when selecting a solution approach.
  • Strong analytical, troubleshooting, communication, documentation, and stakeholder-management skills.
  • Ability to work independently while collaborating across multidisciplinary teams, workstreams, and vendors.
  • Advanced Power Automate, Power Apps, and Power BI experience.
  • Experience with Power BI data modeling, Power Query, DAX, data gateways, scheduled refresh, and row-level security.
  • Experience integrating SharePoint with Jira, Power BI, Tableau, Teams, Excel, or other project-management and reporting tools.
  • Experience with Dataverse, Microsoft Graph, SharePoint REST APIs, custom connectors, webhooks, OAuth, CSOM, or SPFx.
  • Working knowledge of JSON, HTML5, CSS, JavaScript, SQL, C#, .NET, or related development technologies.
  • Experience with Microsoft Azure and cloud-based enterprise applications.
  • Experience with the Power Platform Center of Excellence Starter Kit or a comparable governance framework.
  • Familiarity with Section 508 and WCAG accessibility requirements.
  • Experience working within formal architecture review, change-management, and release-management processes.
  • Experience supporting Medicaid, MMIS, Health and Human Services, healthcare, or State government technology programs.
  • Knowledge of PMO processes, including deliverables, schedules, milestones, RAID management, dependencies, action items, decisions, and status reporting.
  • Experience developing executive and operational dashboards for large, complex technology programs.
  • Experience working with government clients, consulting teams, systems integrators, and multiple contracted vendors.

Responsibilities

  • Analyze business, operational, and technical processes and translate requirements into practical SharePoint, workflow automation, Power Platform, and reporting solutions.
  • Design, configure, and maintain SharePoint Online sites, libraries, lists, metadata, content types, views, permissions, and document-management structures.
  • Develop and support automated workflows using Power Automate, SharePoint Online, Power Apps, Microsoft Teams, Outlook, and related Microsoft 365 capabilities.
  • Create Power BI dashboards, reports, metrics, and visualizations using SharePoint, Jira, Excel, and other approved program data sources.
  • Automate program and PMO processes, including deliverable tracking, reviews and approvals; risks, issues, actions and decisions; status and executive reporting; notifications and escalations; governance and project intake; milestones and dependencies; and compliance and due-date monitoring.
  • Assess, document, stabilize, and enhance existing SharePoint, Power Automate, Power Apps, Power BI, and related reporting solutions.
  • Maintain an inventory of automations, data sources, connections, service accounts, dependencies, ownership, risks, support requirements, and lifecycle status.
  • Implement production-ready solutions using development, test, and production environments; controlled deployments; versioning; connection references; environment variables; and rollback procedures.
  • Build workflows with appropriate monitoring, logging, notifications, exception handling, retry logic, concurrency controls, and recovery procedures.
  • Establish data ownership, validation, reconciliation, refresh procedures, data lineage, and issue-resolution controls for automated reporting.
  • Apply role-based access, least-privilege permissions, connector governance, data-loss prevention, audit logging, credential management, accessibility, and separation-of-duties requirements.
  • Troubleshoot workflow, reporting, integration, access, permissions, and production-support issues and conduct root-cause analysis.
  • Develop solution designs, workflow diagrams, technical documentation, test scripts, administrator guides, deployment plans, operational runbooks, job aids, and training materials.
  • Provide technical guidance, knowledge transfer, training, and ongoing support to authorized users.
  • Track solution outcomes such as reduced cycle time and manual effort, workflow reliability, reporting timeliness, adoption, and data-quality improvements.

Benefits

  • Medical, dental, and vision insurance with an employer contribution
  • Flexible spending or health savings account
  • Life and AD&D insurance
  • Short- and long-term disability coverage
  • Paid time off
  • Employee assistance
  • Participation in a 401(k) program with company match
  • Additional voluntary or legally required benefits
  • Potential eligibility for incentive compensation based on individual and/or company performance
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service