LK Data Solutions LLC

Expert Business Intelligence & Analytics Consulting

Transform your data into strategic advantage. I provide end-to-end analytics solutions—from pipeline development to executive dashboards—backed by proven experience at Amazon and deep expertise across the AWS ecosystem.

What I Offer

BI & Dashboard Development

Executive-facing dashboards in QuickSight, Tableau, or Power BI that turn complex data into clear, actionable insights. Self-service analytics that reduce ad-hoc requests and empower stakeholders to explore data independently.

  • Custom QuickSight dashboard design and deployment
  • Interactive visualizations with drill-down capabilities
  • KPI framework definition and metric tracking
  • User training and documentation

Data Pipeline & ETL Engineering

Production-grade data pipelines using AWS Glue, Spark, and SQL. Automated, scalable solutions that unify disparate data sources and deliver reliable outputs for analytics and reporting.

  • AWS Glue ETL job development (PySpark/Spark SQL)
  • S3 data lake architecture and optimization
  • Redshift and Athena query optimization
  • Automated data quality monitoring and alerting

Analytics & Experimentation

Rigorous statistical analysis to inform business decisions. From A/B testing to causal inference, I help you understand what's driving your metrics and quantify the impact of your initiatives.

  • A/B test design, analysis, and interpretation
  • Customer journey and funnel analysis
  • Segmentation and behavioral analytics
  • ROI modeling and business case development

Data Strategy & Advisory

Strategic guidance on building analytics capabilities, selecting the right tools, and developing data-driven cultures. I help organizations establish scalable analytics foundations that grow with their business.

  • Analytics maturity assessments
  • Technology stack recommendations (AWS, BI tools)
  • Metric framework and KPI development
  • Team training and knowledge transfer

Technology Expertise

Cloud & Data Platforms

AWS Glue Amazon S3 Amazon Redshift Amazon Athena AWS SageMaker

BI & Visualization

Amazon QuickSight Tableau Power BI Plotly

Programming & Analysis

Python SQL PySpark Pandas NumPy

Track Record

With 3.5 years as a Business Intelligence Engineer at Amazon, I've delivered analytics solutions across Fulfillment Technology AI and Selling Partner Services. My work spans the full analytics lifecycle—from building production ETL pipelines processing millions of records to creating executive dashboards that drive strategic decisions.

4
Analytical products delivered in 6 months
Multiple
Production ETL pipelines in AWS Glue
Executive
Self-service QuickSight dashboards

I bring technical depth in cloud data engineering, statistical rigor in analytics, and business acumen from my policy analysis background—enabling me to translate complex technical solutions into business value.

Let's Work Together

Whether you need a one-time analytics project or ongoing BI support, I'd love to hear about your data challenges and discuss how I can help.

Email: lawrencekarongo@gmail.com

Location: Greater Seattle, WA