Developer & Solutions Architect (Contract)

Contract: 6 Months

Rate: £600 per day (Outside IR35)

Location: Hybrid – 3 days per week in the office

About the Opportunity
We'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 BeDoing

Data 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

ries.
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

priate.
Colla

• 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
• t Copilot.TOGAF, Azure or Microsoft Power Platform certi

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

s processes.