Dan Harig
Milestone Marketing Solutions
Lake Saint Louis
1
Certification
5
years of professional experience
Experienced Business Intelligence Analyst with 5 years providing employers with valuable and actionable data to drive profit growth. Practiced at filtering information to find and highlight vital metrics and revelatory findings. Keen to support business growth by leveraging intelligence assets to predict and reveal optimal business strategies.
Work History
BI Analyst & Automation Engineer
2 Years 9 Months- Designed and deployed AI-enhanced ETL pipelines using Python and SQL to ingest, transform, and enrich marketing, CRM, and operational data at scale.
- Processed cloud-based data stored in Azure Data Lake Storage Gen2 through Azure Databricks to support business analytics and reporting.
- Designed and implemented an end-to-end Azure data engineering pipeline using Azure Databricks, Azure Data Lake Storage Gen2, and PySpark.
- Integrated Salesforce Marketing Cloud and external REST APIs (including weather APIs for operational planning) to automate real-time data ingestion and predictive enrichment.
- Automated real-time data ingestion and predictive enrichment by integrating Salesforce Marketing Cloud with external REST APIs, including weather data for operational planning.
- Orchestrated automated workflows using Power Automate, leveraging dynamic expressions, JSON parsing, and retry/exception handling to create resilient, self-healing pipelines.
- Implemented intelligent logging, alerting, and exception-handling frameworks in Python to increase pipeline observability and reduce manual intervention.
- Delivered AI-driven analytics insights to executive leadership, translating model outputs into actionable business strategies.
Data Analyst II
1 Year 4 Months- Designed and implemented a star schema data warehouse with fact and dimension tables to support AI-ready, analytics-grade data modeling across 5M+ transaction records.
- Engineered predictive SQL models for demand forecasting and order planning, automating procurement decision support through statistical logic.
- Automated CRM and operational data ingestion pipelines (SSIS-style ETL workflows), reducing manual data handling and enabling continuous downstream reporting.
- Optimized SQL query performance through clustered and non-clustered indexing strategies, reducing pipeline runtime by 40% and accelerating BI refresh cycles.
- Built Power Automate workflows triggered by SharePoint, Outlook, Forms, and Dataverse events, automating critical data flows and reducing manual intervention.
- Developed stored procedures, views, and aggregated reporting tables, enhancing scalability and automation of BI dashboard workloads.
Data Analyst
8 Months- Developed predictive statistical models in R (lm, glm, caret) to analyze regional operational differences and model equipment demand across dispatch zones.
- Developed predictive statistical models in R (lm, glm, caret) to analyze regional operational differences and inform equipment demand planning across dispatch zones.
- Created interactive visualizations using ggplot2, plotly, and Shiny to convey model outputs and operational trends, enhancing understanding for non-technical leadership.
- Designed SQL data transformations to clean and aggregate operational datasets, streamlining preparation for downstream analytics and reporting.
Education
Bachelor of Computer Information Systems - Minor Business Administration
Skills
AI automation
BI & Visualization: Power BI
DAX
Tableau
SSRS-style Reporting
plotly
ggplot2
Data engineering
Data warehousing
BI visualization
Data lake architecture
Automation & Cloud: Power Automate
SharePoint
Dataverse
CRM Automation
Data Pipeline Automation
Excel modeling
Python development
ETL design
SQL development
Certification
- Data Analysis - Google
- Foundations of Digital Marketing - Google
Timeline
BI Analyst & Automation Engineer
Milestone Marketing Solutions
10.2023 - 07.2026Read More
Data Analyst II
Potter Electric Signal
06.2022 - 10.2023Read More
Data Analyst
Central County 911
10.2021 - 06.2022Read More
Southeast Missouri State University
Bachelor of Computer Information Systems from Minor Business Administration
Read More
CORE COMPETENCIES
- AI & ML Engineering
- Intelligent Pipeline Automation
- ETL / ELT Architecture
- Power Automate & Workflow Automation
- Data Warehouse & Star Schema Design
- REST APIs, JSON, ODBC
- LLM Integration & Prompt Orchestration
- Predictive & Statistical Modeling
- API Data Ingestion & Integration
- Python (Pandas, PySpark, Requests, PyODBC)
- Power BI, DAX & Semantic Modeling
- SQL (T-SQL, Stored Procs, Indexing, Windows Functions)