Solutions Architect

Role description

Developer & Solutions Architect (Contract)
Contract: 6 Months
Location: Hybrid – 3 days per week in the office
About the Opportunit
yWe're looking for an experienced Developer / Solutions Architect to join a specialist organisation on an initial six-month contract. This role is ideal for someone who enjoys combining hands‑on development with technical leadership and wants to play a key role in modernising data, integrations and business processes.The primary focus of the role is ownership and development of the organisation's enterprise Data Warehouse, building new data integrations and delivering automation solutions using the Microsoft technology stack. While solution architecture forms part of the role, the emphasis is on someone who can design and deliver technical solutions rather than purely producing architectural documentation.Working closely with business stakeholders, you'll help improve reporting, automate manual processes and ensure data is reliable, accessible and fit for strategic decision-making.
What You'll Be
DoingData Warehouse & Data Integr

ationTake technical ownership of the enterprise Data Warehouse, driving its ongoing development and improve
ment.Design, develop and maintain ETL/ELT pipelines and integrations across business-critical sys
tems.Build and optimise data models that support reporting, analytics and business intellig
ence.Ensure high standards of data quality, governance and perform
ance.Support reporting solutions using Power BI and other analytical t
ools.Work with stakeholders to identify new reporting requirements and data opportuni
ties.Produce and maintain technical documentation including data models, architecture diagrams and data dictiona

Automation & Application Devel

opmentDesign and develop business applications, APIs and system integra
tions.Build automation solutions using Microsoft Power Automate and Power
Apps.Identify opportunities to replace manual processes with scalable digital work
flows.Support the adoption of Microsoft 365 capabilities, including Copilot and Power Platform technologies where approp
riate.Develop secure, maintainable solutions that follow software development best prac

tices.Solution Archi

tectureProvide technical guidance across applications, integrations and data pla
tforms.Produce solution designs and architecture documentation where re
quired.Ensure solutions are scalable, secure and aligned with wider technology obje
ctives.Evaluate emerging technologies and recommend improvements where appro
borationWork closely with business users to translate requirements into technical so
lutions.Collaborate with third-party suppliers and technical p
artners.Provide technical leadership across development and change init
iatives.Share knowledge and promote best practice within the wid

er team.What We're Lo
oking For

EssentialStrong commercial experience in software development and solutio
n design.Proven experience designing, developing and supporting enterprise Data Wa
rehouses.Excellent SQL and database developmen
t skills.Experience building ETL/ELT processes and integrating data from multiple
systems.Strong experience with Microsoft Azure data
services.Hands-on experience with Microsoft Power Platform, i
ncluding:Power
AutomateP
ower App
sPower BIExperience developing APIs and system inte
grations.Knowledge of Microsoft 365 services and arch
itecture.Strong stakeholder management and communicatio
n skills.Experience working within regulated or governance-driven envi

ronments.

DesirableExperience within insurance, financial services or other regulated i
ndustries.Knowledge of Azure Data Factory, Microsoft Fabric or Synapse
Analytics.Experience with AI-enabled automation and Microsof
fications.

fications.During the initial contract you'll be e

xpected to:Take ownership of the organisation's Data Warehouse and establish a clear techni
cal roadmap.Deliver new data integrations that improve reporting and busin
ess insight.Build practical automation solutions that reduce manual effort and improve operational
efficiency.Improve integration across business systems and Mi
crosoft 365.Introduce technical standards and documentation that improve supportability and
scalability.Identify opportunities to leverage AI and automation to enhance busines

#J-18808-Ljbffr