10/28/2026 updated

**** ******** ****
100 % available

Senior Data Solution Architect

Almada, Portugal
Only remote
Master's degree, Computer Engineering, Universidade Nova de Lisboa
Almada, Portugal
Only remote
Master's degree, Computer Engineering, Universidade Nova de Lisboa

Profile attachments

CV_David_Guerreiro_DataSolutionsArchitect.pdf

About me

I build the data backbone when the stakes are highest: IPO readiness at Klarna, FCA reporting at Vanquis, financial intelligence at BMW, eight AAA launches at 2K. Architecture, engineering, product, and delivery, in parallel, for 17 years. I close the gap between board promises and platform reality.

Business IntelligenceBusiness Intelligence DevelopmentClient Server ModelsData ArchitectureData GovernanceData InfrastructureData IntegrationData Transformation ServicesData VirtualizationData WarehousingIBM WebSphere DataPower SOA AppliancesIBM InfoSphere DataStageEnterprise Architecture FrameworkIBM Systems Network ArchitectureInformation ArchitectureIndustry Standard ArchitectureOracle Business Intelligence Enterprise EditionOracle Data Service IntegratorSoftware ArchitectureSmart DataDataOpsAzure Data LakeScaled Agile FrameworkSun Certified Enterprise Architect (SCEA)Service-Oriented ArchitectureSolution ArchitectureSystems ArchitectureBusiness Intelligence Development StudioData Server InterfaceModel-Driven ArchitectureAzure Data FactorySnowflakeApache SparkAWS Data AnalyticsCitect SCADA SoftwareTerraformAzure Data AnalyticsAzure Synapse AnalyticsDatabricks
Large-scale AWS Solution Architecture
Nearly five years as Solutions Architect across BMW Group programs, designing serverless data ecosystems end to end using S3, Lambda, Aurora, SQS, CloudWatch, SageMaker, Glue, Athena, Kinesis and Kafka, plus the AWS financial engine for Klarna's IPO readiness. Infrastructure governed as code with Terraform.

Snowflake Architecture and Data Integration
Target-state integration architecture across Snowflake, Salesforce, Azure and AWS at Vanquis Banking Group; technical authority over the AWS, Databricks and Snowflake stack at 2K. Definition of data model governance, lineage and integration patterns with embedded data quality controls.

Data Governance and Self-Service BI
Establishment of Data Governance Frameworks and Self-Service BI models with standards, SLAs and validation processes behind trusted KPIs in Tableau, Power BI and Einstein Analytics. Translation of financial, commercial and regulatory requirements into architectures, roadmaps and prioritised backlogs.

Standards and Guidance for Developers
PySpark code reviews, Terraform IaC standards across all environments, Architecture Decision Records, and protocol rules that standardised 20+ source systems at Klarna.

Data Platform Engineering
Hands-on experience with Snowflake, Databricks, Oracle and DB2 as core data platforms, covering near-real-time and batch workloads for analytics, ML and reporting.

Languages and IaC
Proficiency in Python, PySpark, SQL, PL/SQL and Terraform for building and governing data pipelines and reproducible infrastructure environments.

Business Intelligence Tools
Extensive use of Tableau, Power BI, Einstein Analytics and OBIEE to design semantic reporting layers and deliver trusted KPIs to executive stakeholders.

Regulatory and Compliance Reporting
Architecture of FCA-regulated reporting solutions (FCA SUP 16.3.11R / 16.3.12G), FATCA datamart design, and Swedish Tax Authority reporting within Klarna's public-market readiness programme.

Distributed Team Leadership and Delivery Management
Coordination of distributed teams across nine countries and four continents, acting as Technical Program and Delivery Manager within a 5M+ USD program envelope, and as Scrum Master to maintain delivery pace and design quality.

Experience

Professional experience10+ years
Freelancer since2022

Languages

EnglishFluentPortugueseNative speaker

Project history

Senior Data Lead, BI, Data Science & Engineering (Technical Program & Delivery Manager)

2K (via Mindera)
Technical Authority for the data stack on AWS, Databricks and Snowflake, aligning architecture and engineering choices across Data Engineering, Data Science and BI teams. Data infrastructure for 8 AAA game launches covering near-real-time and batch workloads for analytics, ML and reporting. Established the Data Governance Framework and Self-Service BI model. Worked with product managers to turn requirements into data products including a Marketing Mix Model for a 10M USD marketing budget. Coordinated distributed teams across Thailand, India, Ukraine, Poland, the UK, Portugal, Ireland, Brazil and the USA.

Data Architecture and Governance Advisor (Independent Advisory)

Vanquis Banking Group
Designed current-state and target-state integration architecture across Snowflake, Salesforce, Azure and AWS. Defined data model governance, lineage and integration patterns with data quality controls for auditable regulatory reporting (FCA SUP 16.3.11R / 16.3.12G). Aligned target architecture with Compliance, Risk, data engineering and analytics teams under FCA Consumer Duty and PSD requirements.

Solutions Architect & Lead Data Engineer

Critical TechWorks (BMW Group)
Solutions Architect across three BMW Group programs (SOFYA, FS Risk & Finance Management, Scope Analytics) and core member of the Central Architecture Team. Architected serverless AWS data ecosystems from multi-source ingestion to warehousing with SageMaker for ML workloads, improving processing efficiency by 40%. Set engineering standards via PySpark code reviews, Terraform IaC and Architecture Decision Records. Designed the financial domain data model and semantic reporting layer in Tableau and Einstein Analytics. Evaluated platform options across AWS, Azure, Salesforce Einstein and Palantir. Built and mentored the engineering team from scratch, scaling headcount by 100%.

Solutions Architect & Engineering Stream Leader (Independent Advisory)

Klarna
Architected the LEAP Bookkeeping Flow, a mission-critical financial engine on AWS (Kafka, Glue, Athena, PySpark) at the core of Klarna's public-market readiness, including Swedish Tax Authority reporting. Wrote the rules standardising communication from 20+ source systems into the corporate Ledger. Presented and defended architecture decisions in the Central Architecture Forum. Turned financial requirements into the technical roadmap and prioritised backlog for the data engineering team, working with 20+ cross-functional teams.

Senior Consultant, BI & Enterprise Data Solutions

Capgemini
GALP (energy): designed the data model and OBIEE 11g layer for billing, debt and risk indicators on Informatica PowerCenter 10, and extended the Portugal solution to Spain. Portuguese Ministry of Justice (IRN): architected the BI solution on ODI 12c, Oracle and Power BI. Caixa BI (banking): built the FATCA datamart end to end for regulatory reporting to US authorities.

Data Architect and BI Consultant

Earlier roles: PT Sistemas de Informacao, Aubay (SIBS), AGAP2
Data Architect for reference and master data at Portugal Telecom: logical and physical modelling, data strategy and loading policies, member of the Architecture Decisions meetings. Data management on the SIBS payments backbone (DB2, PowerDesigner); ELT architecture for Safaricom (Kenya); BES Bank data warehouse migration from SAS to ODI.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in