Elijah Parfitt

Senior Business Intelligence Developer

Columbus, OH elijah@databyelijah.com LinkedIn GitHub
↓ Download Resume (PDF)

Professional Summary

Business Intelligence Developer with 5+ years of experience designing and supporting enterprise reporting and analytics solutions within cloud data warehouse environments. Skilled in translating business requirements into scalable BI solutions through semantic data modeling, advanced SQL, and dimensional data warehouse design.

Key Achievements

$650K+
Annual Savings

Automated contact center performance data pipelines, eliminating manual workflows and driving over $650K in annual savings.

$100K+
Return Mitigation

Engineered data models to uncover hidden insights, driving strategic changes that directly reduced annual return rates.

80%
Faster Reporting

Optimized foundational reporting data layers to drastically cut Power BI dashboard refresh times.

Technical Skills

BI & Reporting

Power BI, DAX, Power Query, Tableau, MicroStrategy (foundational exposure), Executive KPI Reporting, Self-Service Analytics, Semantic Data Modeling (Metrics, Attributes, Hierarchies)

Contact Center Platforms

NICE CXone (Interaction Analytics / AI Intents & Actions, Performance Management, Quality Management, ACD Reporting), Salesforce (Call Coding), IVR Routing Data

Data Warehousing & Modeling

Dimensional Modeling, Star Schema, Snowflake Schema, Fact & Dimension Tables, Surrogate Keys, Relational Data Modeling, Entity Relationships, Normalization

Cloud & Databases

Azure Databricks, Microsoft Fabric, Unity Catalog (Data Governance & Audit Logging), Google Cloud Platform (Cloud Run, Cloud Scheduler, Cloud Storage), PostgreSQL, Relational Database Management Systems (RDBMS)

Languages & Automation

SQL (Advanced Query Development, Performance Tuning, Troubleshooting, SSMS), Python, PySpark, Power Automate, API Integration, Workflow Automation

Power Platform & Collaboration

Power Automate, Power Apps, SharePoint (Lists, Document Libraries, Automated Forms)

Applied AI

Gemini API / LLM Integration, Claude Code, GitHub Copilot, Agentic AI Tools, Prompt Engineering, AI-Assisted Development, Computer Vision & Image Processing

AI-Enabled Analytics

Sierra AI (Chat Conversation Analysis), Microsoft Copilot for Power BI (Semantic Model Enrichment, Natural-Language Query Feasibility Assessment)

Professional Experience

Business Intelligence Developer

Gap Inc. May 2021 – July 2026 Hybrid, United States

Independent Projects

CFPB Consumer Complaint Analysis

Built an automated Databricks-to-Power BI pipeline analyzing 8.3M+ consumer complaint records, with scheduled API-based ingestion, root-cause decomposition analysis, and geospatial mapping of company response times.

Databricks Power BI Scheduled API Ingestion
View Case Study →

Contact Center SLA Performance Dashboard

Hand-built a Python ELT pipeline and Power BI dashboard processing 52,000+ calls end-to-end with no managed cloud platform; identified the drivers behind 92% SLA compliance.

Python Local ELT Pipeline Power BI
View Case Study →

AI-Driven Inventory & E-Commerce Analytics Pipeline

Designed and built a serverless Google Cloud Platform pipeline (Cloud Run, Cloud Scheduler, Cloud Storage) using Gemini AI computer vision to automatically generate structured product listings from raw photos, feeding a Databricks warehouse and a Power BI layer that tracks AI-estimated pricing against actual sale outcomes.

Google Cloud Platform Gemini AI Databricks Power BI Streamlit

Certifications

↓ Download Resume (PDF) Let's Work Together