Sample healthcare claims analytics dashboard with synthetic data
Illustrative sample in a Power BI report layout, built with synthetic data. Not an actual UHG or Optum report and contains no client data.

Enterprise Data-Driven Reporting Layer

As Sr. Data Architect and Lead Big Data Engineer, led the Enterprise Data-Driven Reporting Layer project for United Health Group (UHG) Optum.

Designed star-schema models, Erwin ERDs and migration plans for an AWS Redshift integrated data warehouse. Built ETL and ELT pipelines with AWS Glue, Glue Data Catalog, Lake Formation, S3, Step Functions, PySpark, dbt, Airflow, NiFi, Kafka and Snowflake.

Implemented GDPR governance and lineage with AWS DataZone on a Medallion Architecture, along with data validation, schema evolution and Delta archival.

Delivered WBS claims and fraud analytics on Snowflake, Athena and Power BI.

Built an AWS Lakehouse on S3 and Delta Lake, with Amazon Bedrock and SageMaker for GenAI and RAG.

  • Amazon Bedrock
  • Amazon SageMaker
  • GenAI & RAG
  • Snowflake
  • AWS Redshift
  • AWS Athena
  • AWS Glue & Data Catalog
  • AWS Lake Formation
  • AWS DataZone
  • AWS Step Functions
  • PySpark
  • dbt
  • Apache Airflow
  • Apache Kafka & NiFi
  • Delta Lake
  • Power BI
Category
Data & AI Engineering
Client
United Health Group (UHG) - Optum
Role
Sr. Data Architect | Lead Big Data Engineer
Location
Dublin, Ireland
Period
March 2025 - January 2026

Sample Dashboards

Sample claims fraud and anomaly monitoring dashboard with synthetic data
Illustrative sample in a Power BI report layout, built with synthetic data. Not an actual UHG or Optum report and contains no client data.

Project Summary

Led an enterprise reporting layer spanning star-schema modeling, ETL and ELT on AWS and Snowflake, GDPR governance on a Medallion Architecture, and claims and fraud analytics in Power BI, with an AWS Lakehouse using Amazon Bedrock and SageMaker for GenAI and RAG.