Data Architect - Azure

As a Data Architect, you will define how commercial and customer data works across the combined estate, starting with the contract and entitlement model that several in-flight programmes depend on a CRM rebuild in HubSpot, a finance transformation onto NetSuite, a new commercial model, automated usage rating, and a platform integration programme.

This is a hands-on architecture role, not a governance-only one. You will be modelling, profiling real data, and writing the specifications that engineering and finance teams build from. Our client is open about the starting position: the data landscape is fragmented and the two platforms model the same concepts differently. That is the problem, and it is an interesting one., * Produce an enterprise data entity map across core business entities, identifying systems of record, relationships, and conflicts.

• Establish canonical definitions and named owners with commercial, finance, product, and engineering.
• Design the canonical contract and entitlement model, supporting prepaid wallet, subscription-with-overage, and a new blended model - with effective dating, versioning, and full lineage from invoice line back to usage event.
• Define the target quote-to-cash flow, keeping operational billing and analytical reporting paths cleanly separated.
• Profile contract, entitlement, and usage data, and assess quality and migration remediation.
• Specify the data contracts between CRM, rating/billing, and finance, and the requirements for usage rating and metering., This is a rare opportunity to define the data model an entire group’s commercial future depends on, at the point where the decisions are still open. Reporting to the Group Director of Architecture, you will have genuine autonomy over your domain and visible impact across several major transformation programmes.

• Strong enterprise data modelling across conceptual, logical, and physical layers in a multi-system estate, with real examples of entity maps and canonical models produced.
• Experience modelling contract, entitlement, subscription, or usage-based billing data - temporal modelling and point-in-time reconstruction are non-negotiable.
• Data architecture in a regulated environment: auditability, lineage, retention, and PII handling under UK GDPR.
• Ability to design both OLTP and OLAP pathways without conflating them.
• Data governance in practice - glossaries, ownership, stewardship, data quality.
• The ability to get commercial, finance, product, and engineering people into a room and come out with agreed definitions.

Key Technologies

• Microsoft Fabric (OneLake, Lakehouse, Warehouse, Pipelines, Dataflows Gen2)
• Power BI and medallion architecture patterns
• CDC, streaming ingestion, and entity resolution
• SQL Server, Azure SQL Database, MySQL, Cosmos DB
• Azure integration services (API Management, Service Bus, Event Hubs, Functions, Logic Apps)
• Entra ID, Key Vault, Azure Policy, Purview
• HubSpot, NetSuite, and Azure DevOps

Desirable

• Microsoft Fabric, or directly transferable depth on AWS or GCP data platforms.
• Experience in RegTech, fintech, or another compliance-driven domain.
• Post-acquisition integration experience - two estates, two data models, one target.

• 10% Bonus
• Private Healthcare
• Lots more!

Our client is a fast-growing RegTech group providing identity verification, AML, and digital compliance solutions to regulated businesses. Following a recent acquisition, they are bringing two established platforms together and investing heavily in the data foundations that will underpin the combined group.