Position Purpose
The Digital Solutions & Data Integration Analyst is responsible for designing, developing, and maintaining automated business solutions, data integrations, and reporting frameworks using Microsoft platforms and database technologies. The role bridges business needs and technical delivery, working closely with internal teams and external stakeholders to deliver scalable, secure, and efficient digital solutions.
Primary Responsibilities
Microsoft Platform Development & Automation
* Design, build, and maintain solutions using the Microsoft suite, including:
o Power Automate (workflow and process automation)
o Power Apps (canvas and model-driven applications)
o Power Pages (internal & external-facing portals)
o SharePoint (content management and data structures)
o Azure services (data storage, app services, integration components)
o Develop and maintain macros and advanced Excel automation to streamline business processes.
o Ensure solutions adhere to organisational governance, security, and best-practice standards.
Data Management & SQL Development
* Write and optimise SQL queries to extract, transform, and load data into Excel and reporting tools.
* Support business reporting and analytics through structured data access.
* Assist in the design and understanding of database schemas.
* Contribute to the creation and maintenance of a data warehouse, including:
o Data modelling and structuring
o Data quality validation
o Documentation of data sources and flows
API & Systems Integration
* Develop and manage API integrations between Microsoft platforms and the organisation's data warehouse.
* Enable seamless data flow across internal systems and external platforms.
* Monitor and troubleshoot integration performance and data consistency issues.
Stakeholder Management & Collaboration
* Work closely with internal stakeholders to gather requirements, translate business needs into technical solutions, and provide ongoing support.
* Engage with external vendors and partners to coordinate integrations, enhancements, and issue resolution.
* Communicate technical concepts clearly to non-technical audiences.
* Manage expectations, timelines, and deliverables across multiple stakeholders.
Continuous Improvement & Innovation
* Identify opportunities to improve business processes through automation and digital tools.
* Stay up to date with Microsoft platform updates and emerging technologies.
* Recommend enhancements that improve efficiency, data integrity, and user experience.
Key Skills & Experience
Technical Skills
* Strong experience with Microsoft Power Platform (Power Automate, Power Apps, Power Pages).
* Solid understanding of SharePoint architecture and usage.
* Experience with Azure services relevant to application and data integration.
* Proficient SQL skills for querying and data manipulation.
* Working knowledge of databases, schemas, and data warehouse concepts.
* Experience with API integration and data exchange methods.
* Advanced Excel skills, including macros.
#J-18808-Ljbffr