Jackie Schroeder

Solutions Architect · Data Analyst · AI Practitioner

I design data and cloud solutions that are reliable, scalable, and actually used.

About

I have 13+ years of experience in data analytics, cloud architecture, and AI-driven solutions, with a focus on building reliable, maintainable systems that support real business decisions.

My work spans AWS architecture, SQL engineering, dashboarding, and workflow optimization— especially in complex operational environments.

Skills

Cloud & Architecture

  • AWS (S3, CloudFront, Lambda, IAM, RDS, Athena)
  • Data lake and ETL design
  • Security and access patterns

Data & Analytics

  • SQL, data modeling, performance tuning
  • Spotfire, dashboard design, UX for analytics
  • Operational reporting and monitoring

AI & Automation

  • LLM-assisted workflows
  • Automation of repetitive analysis tasks
  • Integration of AI into existing toolchains

Selected Projects

Demo Data Lake for Client Showcases

Designed and implemented an anonymized, date-shifted demo data lake to safely showcase analytics capabilities without exposing sensitive information.

Tech: AWS, SQL, Athena, ETL

Operational Dashboards for Midstream Assets

Built performance-focused dashboards for gas plants and gathering systems, balancing usability, speed, and data fidelity.

Tech: Spotfire, SQL, Databricks

UI/UX Review Framework for Analytics Tools

Created a scenario-based, checklist-driven approach to reviewing analytics UIs, improving adoption and reducing user friction.

Focus: UX, workflow optimization

How This Site is Built

This portfolio is deployed on AWS using a fully infrastructure-as-code setup managed with Terraform.

Hosting & CDN

  • S3 — private static file hosting
  • CloudFront — global CDN with HTTPS
  • OAC — CloudFront-only S3 access

Security

  • ACM — DNS-validated TLS certificate
  • TLS 1.2 minimum enforced
  • SSL enforced on S3, no HTTP access

Infrastructure

  • Terraform — all infrastructure as code
  • Route 53 — DNS and domain management
  • CloudFront access logging enabled

View the full source on GitHub.

Contact

I’m open to remote roles and collaborations focused on data, cloud, and analytics.