Andrew Bottemiller

|

Senior consultant specializing in business intelligence, data analytics, and AI strategy. Delivering impactful solutions for Fortune 500 clients while bridging business needs with technical execution.

View Experience Let's Connect
0
Years Experience
0
Fortune 500 Clients
0
Satisfied Clients
Who I Am

Driving Business Value Through Analytics & AI

I'm a client-facing analytics expert with 9+ years of experience delivering impactful business intelligence solutions for enterprise organizations. Currently serving as a Senior Consultant at Sparq, I specialize in BI strategy, scalable analytics delivery, and AI-driven transformation.

Based in Boise, Idaho, my professional focus centers on designing and implementing BI models, dashboards, and custom metrics that drive strategic business objectives. I've worked with Fortune 500 clients including T-Mobile, Microsoft, Motive, and The Gates Foundation, managing technical discovery, pre-sales solutioning, and multi-phase data transformation projects from discovery through deployment.

My technical expertise spans Power BI, Tableau, SQL, Python, and DAX, complemented by Wharton School certifications in AI for Business, AI Strategy & Governance, and AI Applications across marketing, finance, and people management. I'm passionate about translating complex analytics into actionable business outcomes and bridging the gap between business goals and technical execution.

Beyond consulting, I bring a unique perspective through my background in sophisticated options trading, algorithmic system development, and market microstructure analysis. This combination of professional analytics expertise and financial market knowledge allows me to approach business problems with exceptional analytical rigor and strategic thinking. I also run trading-focused Discord communities, create a weekly investor newsletter, and operate an e-commerce business—all of which inform my consulting approach with real-world entrepreneurial insights.

Andrew Bottemiller
Professional Background

Experience & Impact

Senior Consultant

Sparq (formerly Amplify Consulting Partners) October 2024 - Present

Following acquisition, promoted into a specialized role focused on BI strategy and scalable analytics delivery for enterprise clients.

  • Lead design and implementation of scalable BI models, dashboards, and custom metrics to support strategic client objectives
  • Collaborate directly with clients to scope requirements, deliver proof-of-concepts, and iterate solutions that drive adoption
  • Advise stakeholders on data interpretation and decision-making strategies, bridging business goals with technical execution
  • Serve as primary client liaison for data engagements, aligning analytics roadmaps to business KPIs and product feedback loops

Account Manager, Practice Lead & Analyst

Amplify Consulting Partners (now Sparq) October 2017 - October 2024

Held dual role managing client relationships while delivering high-impact BI and analytics solutions for Fortune 500 clients including T-Mobile, Microsoft, Motive, and The Gates Foundation.

  • Led technical discovery and pre-sales solutioning; designed rapid prototypes and proof-of-concept dashboards to influence stakeholder buy-in
  • Partnered with sales and marketing to align client solutions with GTM strategy and drive retention and upsell opportunities
  • Directed multi-phase BI and data transformation projects from discovery through deployment, maintaining >95% client satisfaction
  • Delivered real-time and scheduled reporting systems via Power BI and SQL that streamlined executive reporting and improved forecasting accuracy
  • Created custom performance evaluation and resource optimization frameworks, directly improving delivery efficiency and reducing project risk
  • Liaised between clients and product/engineering teams to communicate technical feedback and influence internal tool development
  • Championed integration between delivery, sales, and operations teams to improve operational efficiency and processes

Notable Client Engagements

T-Mobile

Enterprise BI solutions and data transformation

Microsoft

Analytics strategy and dashboard development

Motive

Technical discovery and reporting systems

Gates Foundation

Custom metrics and strategic analytics

Credentials

Certifications & Education

AI for Business Specialization

The Wharton School, University of Pennsylvania

Comprehensive specialization covering AI strategy, governance, and practical applications across business functions including marketing, finance, and people management.

AI Strategy & Governance

The Wharton School

AI Applications in Marketing & Finance

The Wharton School

AI Applications in People Management

The Wharton School

AI Fundamentals for Non-Data Scientists

The Wharton School

Tableau Analyst

Tableau

Introduction to Generative AI

Google

Bachelor of Science in Finance

Syracuse University • 2016

What I Do

Core Expertise

Business Intelligence & Analytics

Designing and implementing scalable BI solutions, custom dashboards, and data models that drive strategic decision-making. Expert in Power BI, Tableau, SQL, and DAX for enterprise-scale analytics.

  • Power BI Dashboard Development
  • Data Modeling & ETL Design
  • Real-time Reporting Systems
  • KPI Framework Development
  • Executive Analytics & Forecasting

AI Strategy & Implementation

Leveraging AI and machine learning to transform business processes and decision-making. Wharton-certified in AI applications across marketing, finance, governance, and people management.

  • AI Strategy & Governance
  • Generative AI Applications
  • ML Model Integration
  • AI-Driven Process Optimization
  • Predictive Analytics

Technical Project Management

Leading complex, multi-phase data and BI projects from discovery through deployment. Expert in stakeholder management, technical discovery, and cross-functional team coordination.

  • Technical Discovery & Scoping
  • Proof-of-Concept Development
  • Agile Project Delivery
  • Stakeholder Communication
  • Risk Management & Mitigation

Client Solutions & Pre-Sales

Building strategic relationships with enterprise clients and delivering solutions that align business needs with technical capabilities. Proven track record with Fortune 500 organizations.

  • Strategic Account Management
  • Pre-Sales Solutioning
  • Requirements Gathering
  • Solution Architecture
  • Client Success & Retention

Advanced Trading & Market Analysis

Sophisticated options trading with focus on LEAP strategies, 0DTE setups, and market microstructure. Expert in analyzing gamma exposure, vanna dynamics, and institutional flow.

  • LEAP Options (3-6 month holds)
  • 0DTE SPX/SPY Strategies
  • Market Microstructure Analysis
  • Options Flow Interpretation
  • Algorithmic Trading Systems

Development & Automation

Building custom analytics tools, automated systems, and data pipelines. Proficient in Python, SQL, Pine Script, and various APIs for extending BI platform capabilities.

  • Python Data Analysis & Automation
  • SQL Query Optimization
  • API Integration & Development
  • Pine Script Indicators
  • Custom Tool Development
My Projects

Professional Ventures

BI & Analytics Consulting

Providing specialized business intelligence consulting services for enterprise clients. Delivering scalable analytics solutions, AI strategy, and data transformation expertise.

Power BI AI Strategy Fortune 500

Weekly Investing Newsletter

Comprehensive weekly investment newsletter combining accessible writing with deep financial analysis. Covering market trends, individual stock analysis, and sophisticated trading strategies.

Weekly Newsletter Market Analysis Stock Research

Trading Discord Communities

Active investing Discord servers providing market insights, automated data feeds, real-time analysis, and collaborative learning environments for traders of all experience levels.

Real-time Alerts Education Community

Trading Systems Development

Custom Pine Script indicators and automated trading systems for TradingView. Specializing in 0DTE strategies, opening range breakouts, and institutional flow analysis tools.

Pine Script Automation Custom Tools

Overlanding E-commerce

Specialized online retail business offering premium off-roading and overlanding apparel. Built with modern e-commerce best practices and AI-powered shopping discovery optimization.

Premium Products AI-Optimized Niche Market
Technical Proficiency

Tools & Technologies

Business Intelligence & Analytics

Power BI Tableau DAX M (Power Query) SQL KQL Data Modeling ETL/ELT

AI & Development

Python Machine Learning Generative AI API Integration Data Analysis Automation JavaScript

Professional & Strategic

Strategic Planning Project Management Pre-Sales Support Technical Discovery Stakeholder Management Business Intelligence Problem Solving Proof-of-Concepts

Trading Platforms

TradingView Unusual Whales Bookmap Quant Data OpenInsider Interactive Brokers Pine Script
Get In Touch

Let's Connect

Looking for BI consulting or collaboration?

I'm always interested in connecting with organizations seeking analytics expertise, exploring consulting opportunities, or discussing innovative approaches to business intelligence and AI strategy.

Boise, Idaho
mail@andrewbottemiller.com
(509) 595-3857