Solutions Architect

i3; Greater London; Hybrid; GBP 65,000 - 90,000; Part time

Job summary

i3 is seeking a Developer & Solutions Architect (Contract) to own and develop the enterprise Data Warehouse, build data integrations and deliver automation solutions using the Microsoft stack. The role combines hands-on development with technical leadership to modernise data, integrations and business processes.

You will design and deliver technical solutions, partner with business stakeholders to improve reporting, automate manual processes and ensure data reliability for strategic

Qualifications

• Strong commercial experience in software development and solution design.
• Experience designing, developing and supporting enterprise Data Warehouses.
• Excellent SQL and database development 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, including Power Automate, Power Apps and Power BI.
• Experience developing APIs and system integrations.
• Knowledge of Microsoft 365 services and architecture.
• Strong stakeholder management and communication skills.
• Experience working within regulated or governance-driven environments.

Responsibilities

• Take technical ownership of the enterprise Data Warehouse, driving its ongoing development and improvements.
• Design, develop and maintain ETL/ELT pipelines and integrations across business-critical systems.
• Build and optimise data models that support reporting, analytics and business intelligence.
• Ensure high standards of data quality, governance and performance.
• Support reporting solutions using Power BI and other analytical tools.
• Work with stakeholders to identify new reporting requirements and data opportunities.
• Produce and maintain technical documentation including data models, architecture diagrams and data dictionaries.

Skills

Data Warehouse

ETL/ELT

SQL

Azure

Power Platform

APIs

System Integrations

Power BI

Tools

Power Automate

Power Apps

Azure Data Factory

Azure Synapse

Job description

Developer & Solutions Architect (Contract)

Contract: 6 Months

Location: Hybrid – 3 days per week in the office

About the Opportunit

y
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 processe
s.
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 documentati
on.
Working closely with business stakeholders, you'll help improve reporting, automate manual processes and ensure data is reliable, accessible and fit for strategic decision-mak
ing.

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