SharePoint Automation & Reporting Technical Consultant
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+30 more
Job description
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 will also assume ownership of existing automation and reporting solutions, stabilize and enhance those solutions, and establish 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 position will collaborate with State stakeholders, program leadership, PMO and delivery workstreams, technical teams, consulting resources, systems integrators, and other vendors., * 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, review, and approval
- Risks, issues, actions, and decisions
- Status and executive reporting
- Document review and approval
- Notifications and escalations
- Governance and project intake
- Milestones and dependencies
- 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.
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.
Preferred Skills:
- 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.
Benefits & conditions
Where required by law, NTT DATA provides a reasonable range of compensation for specific roles. The starting pay range for this remote role is $81,936 - $170,700. This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on a number of factors, including the candidateβs actual work location, relevant experience, technical skills, and other qualifications. This position may also be eligible for incentive compensation based on individual and/or company performance. This position is eligible for company benefits including 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 401k program with company match, and additional voluntary or legally-required benefits.
About the company
NTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. We are committed to accelerating client success and positively impacting society through responsible innovation. We are one of the worldβs leading AI and digital infrastructure providers, with unmatched capabilities in enterprise-scale AI, cloud, security, connectivity, data centers and application services. our consulting and Industry solutions help organizations and society move confidently and sustainably into the digital future. As a Global Top Employer, we have experts in more than 50 countries. We also offer clients access to a robust ecosystem of innovation centers as well as established and start-up partners. NTT DATA is a part of NTT Group, which invests over $3 billion each year in R&D.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦