Recherche actuelle

Senior BI & Data Warehouse Architect

Level: Senior / Principal · 15-25+ years' experience Discipline: Business Intelligence, Data Warehousing & Data Architecture Profile fit: Permanent, interim, or independent consultant

About the Role

We're looking for a senior, hands-on BI & Data Warehouse Architect who can own analytics solutions end-to-end from architecture and data modeling through build, migration, and governance. This is a "player-coach" profile: someone equally comfortable designing a target-state data platform, building the semantic model themselves, and mentoring the developers around them, while acting as translator between business stakeholders and technical delivery.

Key Responsibilities

* Design and own BI/DW architecture from the ground up, spanning on-prem and cloud environments
* Lead dimensional and semantic data modeling (Kimball methodology, star schema, Medallion architecture); maintain data dictionaries and metadata
* Plan and deliver platform migrations - legacy on-prem to cloud, or one BI/reporting toolset to another
* Build and optimize BI solutions, primarily in Power BI (DAX/MDX), alongside SSRS/SSAS or equivalent
* Design and manage ETL/ELT pipelines
* Own data governance, security/permissions, and Master Data Management (MDM) initiatives
* Translate between business requirements and technical delivery
* Lead and mentor junior BI/data team members
* Contribute to BI strategy across one or more concurrent projects or client engagements

Experience

* 15+ years in BI/Data Warehousing/Analytics; strong candidates for this profile often have 20-25 years
* Demonstrated architect-level ownership - has designed and built solutions from scratch, not only maintained existing ones
* A track record spanning legacy on-prem BI (Cognos, Business Objects, SSAS/SSRS/SSIS) through to modern cloud platforms (Azure, Snowflake, Databricks, Fabric) is a strong differentiator
* Has led at least one significant migration (e.g. on-prem → cloud, SAS → Snowflake, QlikView → Power BI, Hadoop → Microsoft stack)
* Consulting, freelance, or multi-client delivery background is a plus
* Experience leading or mentoring a small BI/data team
* Broad industry exposure rather than a single vertical (e.g. retail, banking/finance, insurance, logistics, telecom, real estate)

Technical Skills

* On-prem / legacy BI: SSIS, SSRS, SSAS, MDX, Cognos, Business Objects, SQL Server
* Cloud platforms: Azure (Azure SQL Database, Data Factory, Synapse, Analysis Services), Snowflake, Databricks, Microsoft Fabric
* BI & visualization: Power BI, DAX
* Data modeling: Kimball dimensional modeling, star schema design, Medallion (bronze/silver/gold) architecture
* Metadata & modeling tools: Erwin, Informatica Analyst (or equivalents)
* Governance & ops: Master Data Management, data security/permissions, data dictionaries
* SQL: Advanced

Education & Certifications (preferred, not required)

* Bachelor's degree in Informatics, Computer Science, Information Systems, or related field
* Vendor certifications/badges such as Microsoft Azure Fundamentals, Power Platform Fundamentals, Databricks or Snowflake credentials
* Formal DW training such as Kimball University

Nice to Have

* Experience running an independent BI consultancy or freelance practice
* Proactive, self-directed upskilling on emerging platforms (e.g. lab/sandbox experience with Fabric or Snowflake ahead of production use)
* Technical project management experience

About the Engagement

We are looking for an experienced Microsoft Fabric Architect to join us on a freelance basis to lead the design and delivery of our enterprise data platform. This is a hands-on contract role, ideal for an independent consultant who can hit the ground running and take ownership of critical architecture decisions from day one.

You will be embedded within our Data & Analytics team, working alongside internal engineers, BI developers, and senior stakeholders to deliver a robust and scalable Microsoft Fabric environment within an agreed timeframe.



Platform Architecture & Design

* Define and document the end-to-end Microsoft Fabric architecture including OneLake, Lakehouses, Warehouses, Data Pipelines, and Semantic Models.
* Establish workspace strategy, capacity planning, and governance frameworks tailored to the organisation's needs.
* Assess and lead migration of existing Azure data assets (Synapse, ADF, ADLS, Power BI Premium) to Microsoft Fabric.
* Produce architecture decision records (ADRs), solution design documents, and technical roadmaps.



Essential stack

* 5+ years in data architecture or senior data engineering, with recent hands-on Microsoft Fabric experience.
* Demonstrable experience delivering Microsoft Fabric solutions including Lakehouses, Warehouses, Pipelines, Dataflows Gen2, and Fabric notebooks.
* Strong background in Azure data services: Synapse Analytics, ADLS Gen2, Azure Data Factory, Azure Databricks.
* Proficient in SQL, PySpark, and Python for data engineering and transformation.
* Experience with medallion / lakehouse architecture and dimensional data modelling.
* Solid Power BI architecture knowledge including Direct Lake and semantic model design.
* Comfortable working in a DevOps / Agile environment with Git-based deployments and CI/CD pipelines.
* Proven ability to deliver independently with minimal supervision in a contract setting.
* Strong documentation skills and the ability to produce clear technical artefacts.

Role Overview:
As a Senior Solution Architect, you'll play a key role in shaping and delivering scalable, secure, and high-performing cloud solutions. You'll work closely with engineering teams, stakeholders, and business leaders to define architecture strategy and ensure best practice across AWS environments.

Key Requirements:

-Proven experience as a Senior Solution Architect in enterprise environments.
-Strong expertise across AWS services (e.g. EC2, Lambda, S3, RDS, VPC, etc.).
-Solid DevOps background - CI/CD pipelines, automation, infrastructure as code (e.g. Terraform, CloudFormation).
-Experience designing scalable, resilient cloud architectures.
-Strong understanding of cloud security and governance.
-Ability to work closely with development and operations teams.
-Excellent stakeholder communication skills.
-Swedish Speaking.

Nice to Have:

-Experience with containerisation (Docker/Kubernetes).
-Prior experience in large-scale digital transformation programmes.
-AWS certifications (e.g. Solutions Architect Professional).

Contract Data Architect (Insurance & Pensions)

📢 URGENT REQUIREMENT
Interviews taking place immediately with a view to commencing Monday 27th July.

Location: Fully Remote (occasional travel to London)
Contract Length: 6 Months Initial Contract
Day Rate: £600-£650 per day
Engagement: Outside IR35
Start Date: Monday 27th July

Overview

We are seeking an experienced Data Architect to join a high-profile data modernisation programme within the insurance and pensions sector. This consultant will play a critical role in defining the target-state data architecture, supporting the migration of legacy data estates into a modern cloud-native platform, and shaping the architectural standards that underpin enterprise-wide data transformation.

This is an ideal opportunity for a Data Architect with strong insurance or pensions experience, a deep understanding of modern data platforms, and the ability to engage effectively with both technical and business stakeholders.

Key Responsibilities

* Lead discovery, assessment and technical design activities for large-scale data modernisation programmes.
* Define conceptual architectures, logical data models and detailed low-level designs (LLDs).
* Design target-state Lakehouse and Medallion architectures, including Bronze, Silver and curated data product layers.
* Develop migration strategies for transitioning legacy and mainframe-based datasets into modern cloud-native platforms.
* Define data ingestion, profiling, mapping, validation, reconciliation and governance processes.
* Produce canonical data models across policy, member, scheme, contribution, benefit, payment, adjustment and reporting domains.
* Design scalable API and microservices-based integration patterns.
* Establish data quality, reconciliation and control frameworks to support regulatory and operational reporting.
* Produce architecture artefacts including:

* Solution designs
* Data models
* Source-to-target mappings
* API specifications
* Security models
* Migration plans
* Runbooks

* Work closely with engineering, platform, security and operations teams to ensure solutions are scalable, secure and production-ready.
* Provide architectural leadership and engage with stakeholders at all levels across business and technology functions.

Essential Experience

* Extensive experience as a Data Architect within insurance or pensions.
* Strong understanding of insurance and pension data domains.
* Proven delivery of enterprise-scale data architecture and modernisation programmes.
* Experience designing modern cloud-native data platforms.
* Strong knowledge of Lakehouse and Medallion architecture patterns.
* Experience migrating legacy, on-premise or mainframe data platforms into cloud environments.
* Ability to create conceptual architecture, logical data models and detailed LLDs.
* Strong understanding of enterprise data modelling and canonical data structures.
* Experience designing API-led and microservices architectures.
* Excellent stakeholder management and communication skills.
* Strong understanding of data governance, data quality, reconciliation and regulatory reporting requirements.

Highly Desirable

* Experience with:

* Bulk Purchase Annuities (BPA)
* Pension Risk Transfer
* Actuarial Reporting
* Scheme Administration Data
* Regulatory Reporting
* Operational Analytics

* Experience within highly regulated financial services environments.
* Exposure to enterprise data engineering and cloud transformation initiatives.

Key Skills

* Data Architecture
* Insurance & Pensions
* Data Modernisation
* Cloud Data Platforms
* Lakehouse Architecture
* Medallion Architecture
* Data Modelling
* Legacy/Mainframe Migration
* Conceptual Architecture
* Low-Level Design (LLD)
* APIs & Microservices
* Data Governance
* Data Quality & Reconciliation
* Stakeholder Management
* Solution Design

About the Role

On behalf of our client, [Client Company Name], we're hiring a Senior BI Architect to design, govern, and scale their business intelligence ecosystem. You'll own the technical vision for how data is modeled, warehoused, and delivered to the business - turning raw data into trusted, decision-ready insight. This is a high-impact role for someone who thrives at the intersection of data architecture, analytics engineering, and stakeholder strategy.

What You'll Do

* Design and own the enterprise BI architecture, including data warehouse/lakehouse structures, semantic layers, and reporting frameworks
* Define and enforce data modeling standards (dimensional modeling, star/snowflake schemas, medallion architecture) to ensure consistency and performance across BI assets
* Lead the selection, implementation, and governance of BI tools and platforms (e.g., Power BI, Tableau, Looker) and their integration with the broader data stack
* Architect and lead migrations to Microsoft Fabric, including OneLake, lakehouses/warehouses, Data Factory pipelines, and Power BI semantic models
* Design solutions that remain cloud-agnostic where appropriate, ensuring architecture isn't unnecessarily locked to a single vendor and can integrate across AWS, Azure, and GCP data sources
* Partner with data engineering to design scalable, reliable data pipelines that feed BI systems
* Establish data governance practices - access controls, data quality standards, metadata management, and documentation
* Translate business requirements into scalable technical solutions, working closely with analysts, product, and executive stakeholders
* Mentor BI developers and analysts on architecture best practices, performance tuning, and self-service enablement
* Evaluate emerging BI/analytics technologies and make recommendations to keep the architecture future-proof
* Own performance optimization for large-scale dashboards, semantic models, and queries
* Drive self-service analytics adoption through well-governed, reusable data models

What You'll Bring

* 7+ years of experience in business intelligence, data architecture, or analytics engineering, including prior BI development experience
* Proven track record architecting enterprise-scale BI solutions from the ground up
* Hands-on experience leading multiple end-to-end migration projects onto Microsoft Fabric (OneLake, Lakehouse/Warehouse, Data Factory, Power BI semantic models), including planning cutover strategy and minimizing disruption to existing reporting
* Deep expertise in dimensional modeling and modern data warehouse/lakehouse design
* Cloud-agnostic mindset - comfortable architecting solutions that span or move between AWS, Azure, and GCP rather than being tied to a single ecosystem
* Advanced proficiency with Power BI (DAX, semantic modeling) and working knowledge of other major BI platforms (Tableau, Looker)
* Strong SQL skills and familiarity with ELT/ETL tooling (e.g., dbt, Data Factory, Fivetran, Airflow)
* Experience with data governance, security, and role-based access frameworks
* Excellent communication skills - able to translate between technical architecture and business needs
* Experience mentoring or leading technical teams

Nice to Have

* Experience migrating off legacy platforms (e.g., Synapse, SSAS, Snowflake, Redshift, BigQuery) onto Fabric
* Experience with Python or scripting for data automation
* Familiarity with CI/CD for analytics (version-controlled BI development, Fabric deployment pipelines)
* Background in a specific industry vertical (finance, retail, healthcare, SaaS, etc.)
* Relevant certifications (e.g., Microsoft Certified: Fabric Analytics Engineer, Power BI, Snowflake SnowPro, AWS/GCP data certifications)

Senior Solution Architect - Finance Systems (Contract)

New York, NY (Hybrid, Tue-Thurs onsite) Global Life Sciences Company

A publicly traded, AI-forward life sciences business is looking for a Senior Solution Architect on a contract basis to lead NetSuite architecture and third-party integration best practices across their finance systems ecosystem. Operating through a portfolio of nimble, focused subsidiaries, this organization combines startup agility with the resources of a public company - and technology is central to how they deliver on their mission of getting innovative medicines to patients faster.

Key Responsibilities

* Own end-to-end solution architecture and design across the finance systems stack - NetSuite, Coupa, OneStream, Concur, and Workiva
* Design and implement cloud-to-cloud, API, and file-based integrations using platforms such as Celigo, Boomi, or MuleSoft
* Define the AI strategy for financial systems, identifying where AI-enabled workflows can replace or improve existing processes
* Conduct technical impact assessments for system and master data changes across integrated platforms
* Ensure all solutions meet SOX compliance standards and relevant regulatory requirements

Requirements

* Deep, hands-on NetSuite ERP experience with a strong integration background across financial platforms
* Proficiency with third-party finance systems including OneStream, Anaplan, FloQast, Workiva, and Concur
* Strong SOX compliance experience within a publicly traded organization
* Must be commutable to midtown Manhattan Tuesday through Thursday; US work authorization required - no visa sponsorship

Send your resume to j.gendler@andersonfrank.com or call +1 646-540-7487.



Anderson Frank International is the leading NetSuite recruitment firm in the US, advertising more NetSuite roles than any other agency. We work with both NetSuite partners and end users across the United States and have an unrivalled understanding of where the best opportunities are. Anderson Frank International Ltd is acting as an Employment Agency in relation to this vacancy.