Key Responsibilities
Power BI / Reporting
- Build and maintain interactive Power BI dashboards, KPI reports, and operational insights.
- Develop models using DAX, Power Query (M), Power Automate, dataflows, and composite models.
- Connect to APIs requiring token-based authentication (OAuth 2.0, bearer tokens, JWT).
- Handle token refresh, credential expiry, and secure storage of secrets.
- Publish and embed Power BI dashboards into SharePoint Online or internal websites.
- Produce documentation on datasets, token flows, refresh schedules, and governance.
SharePoint / Website / Intranet Development
- Build, configure, and maintain SharePoint Online communication sites where reporting and dashboards are published, pages, lists, libraries, and navigation.
- Embed dashboards securely into SharePoint and maintain permissions.
- Support UX, governance, and content structure improvements.
Integration & API Security
- Integrate systems using secure token-based API authentication, including:
- OAuth 2.0 (various flows), bearer tokens, refresh tokens
- Secure handling of secrets (Key Vault, M365 secure stores)
- HTTPS/TLS-only connections
- Avoid exposing tokens in PBIX files, workflows, code, or logs.
- Monitor token usage, errors, rate limits, throttling, and failures.
ITSM & RMM Tool Integrations (NEW)
- Ideally have experience integrating with ITSM (IT Service Management) tools, such as:
- Servicely
- ServiceNow
- ConnectWise
- Halo, Jira Service Management, etc.
- Ideally have experience integrating with RMM (Remote Monitoring & Management) tools, such as:
- NinjaOne
- Auvik
- Datto RMM
- ConnectWise Automate
- Extract incident, SLA, device, alerting, and asset data via:
- API endpoints
- Webhooks
- Scheduled exports
- Custom connectors
- Build Power BI dashboards for:
- SLA performance
- Incident trends
- Device health
- Patch compliance
- Inventory and asset reporting
- Financial Reporting
- Automate workflows (e.g., ticket notifications, device status processing) using:
- Power Automate
- API calls
- Webhooks
(These lines remain optional in reading but strongly desirable for MSP environments.)
Stakeholder Engagement
- Work directly with Service Delivery, Operations and technical teams.
- Produce documentation, UAT support, training and handovers.
- Communicate clearly with technical and non‑technical audiences.
Required Skills & Experience (Essential)
Core Technical Skills
- Strong end-to-end Power BI development experience.
- Strong DAX, Power Query (M), modelling, and dataflow experience.
- Experience building and administering SharePoint Online sites.
- Deep experience with token-based APIs, including:
- OAuth 2.0 flows
- Bearer/JWT tokens
- Refresh token lifecycle
- Secure key/token storage
- Experience embedding Power BI dashboards in SharePoint or websites.
- Ability to parse JSON/XML payloads and handle complex API schemas.
ITSM & RMM Integration (New Essential/Desirable Section)
- Ideally worked with ITSM platforms for:
- Pulling incident/SLA/CMDB data
- API-based reporting integration
- Dashboards for service performance
- Ideally worked with RMM platforms, especially in MSP settings:
- Device monitoring
- Alert/patch compliance data
- Automation hooks
- Experience ingesting this data into Power BI or SharePoint is highly desirable.
Security & Governance
- Strong understanding of secure API communication and GDPR.
- Knowledge of least‑privilege access and permission scopes.
- Ability to design governed, secure reporting environments.
Behavioural Competencies
- Customer-focused and proactive.
- Strong communication skills.
- Analytical, logical thinker with attention to detail.
- Collaborative and supportive team player.
- High personal integrity and security awareness.
Success Measures (First 3–6 Months)
- Required reports and dashboards developed and up and running
- At least one secure token‑based API integration delivered.
- ITSM and/or RMM data integrated into Power BI dashboards.
- Dashboards successfully embedded into SharePoint with correct governance.
- Documented API flows (tokens, refresh, failures).
- Improved visibility of service performance for stakeholders.