Dan Harig
Lake Saint Louis,MO
Summary
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.
Overview
1
1
Certification
5
5
years of professional experience
Work History
BI ANALYST & AUTOMATION ENGINEER
Milestone Marketing Solutions
10.2023 - 07.2026
- 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.
- Engineered automated workflows utilizing Power Automate, incorporating dynamic expressions, JSON parsing, and robust retry/exception handling to establish 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
Potter Electric Signal
06.2022 - 10.2023
- 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 efficiency via clustered and non-clustered indexing approaches, decreasing pipeline runtime by 40% and streamlining 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
Central County 911
10.2021 - 06.2022
- 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
Southeast Missouri State University
Cape Girardeau, MO01-2021
Skills
- AI automation
- Data engineering
- BI visualization
- Automation & Cloud: Power Automate, SharePoint, Dataverse, CRM Automation, Data Pipeline Automation
- Python development
- SQL development
- Pattern recognition
- Trend analysis
- BI & Visualization: Power BI, DAX, Tableau, SSRS-style Reporting, plotly, ggplot2
- Data warehousing
- Data lake architecture
- Excel modeling
- ETL design
- BI tools expertise
- Competitive analysis
- Reliability
Certification
- Data Analysis - Google
- Foundations of Digital Marketing - Google
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)
Timeline
BI ANALYST & AUTOMATION ENGINEER
Milestone Marketing Solutions
10.2023 - 07.2026
DATA ANALYST II
Potter Electric Signal
06.2022 - 10.2023
DATA ANALYST
Central County 911
10.2021 - 06.2022
Bachelor of Computer Information Systems - Minor Business Administration
Southeast Missouri State University