Shane Christian
  • Home
  • Resume
  • Projects

Resume

  • Edward Shane Christian
  • Professional Summary
  • Career Highlights
  • Professional Experience
  • Technical Skills
  • Education

Edward Shane Christian

Principal Data Engineering & Analytics Analyst

📍 Tennessee Ridge, TN · 📧 schristian625@aol.com · 📱 615-852-0233 · 🔗 LinkedIn

⬇ Download PDF

Professional Summary

Principal Data Engineering & Analytics Analyst promoted from Senior Data Analyst for consistently operating a level above the role — architecting and owning production data platforms, not just building dashboards on top of them. Built and maintain 8+ FastAPI analytics applications on a shared company platform, backed by governed dbt data models rather than application-layer logic. Authored the platform’s row-level-security access pattern (now the reference implementation across every dashboard) and led a test-coverage initiative that put a CI gate in front of every merge. Known for root-causing data-integrity failures at their source — from a join fan-out that had silently inflated a live cost KPI by 500x, to a pipeline-orchestration gap that froze a production dashboard for days — and fixing them rather than patching the symptom. Brings a unique dual background in transportation operations and complex data architecture, having previously managed a fleet of 60+ drivers and optimized fuel/speed compliance to boost revenue by 12%. Expert in SQL, Python, dbt, Power BI, and Dataverse, with a demonstrated ability to translate complex technical tradeoffs into actionable insights for non-technical stakeholders.

Career Highlights

$1.2M Saved

Led enterprise-wide Domo → Power BI migration, eliminating external consulting fees

3 wks → 2 days

Cut Medicare fraud case preparation turnaround at TN Attorney General’s Office

12% Revenue Growth

Accelerated gross revenue through fuel and speed management optimization

$4K/mo Found

Identified unbilled medication revenue through government-required opioid audit

55% → 20% Idle

Reduced fleet idle time managing 60+ drivers at Knight Transportation

99% Satisfaction

Customer satisfaction rating at MEDHOST — first-ever promotion to Focus Manager

Professional Experience

Principal Data Engineering & Analytics Analyst

Select Water Solutions

January 2026 – Present

  • Analytics Platform Engineering: Built and own 5 additional production FastAPI dashboard apps on the company’s shared analytics platform — chemical logistics operations, EHS compliance, workforce turnover, disposal-facility volumes, and the company’s primary financial/volumes reporting app (also the shared landing page for the full platform)
  • Data Integrity & Incident Response: Root-caused and fixed a join fan-out bug that had inflated a live cost KPI to $17.3B (corrected to ~$29M), and diagnosed a silent multi-day data freeze traced to an upstream pipeline model archived by another engineer — restored with zero downstream impact
  • Platform Security & Test Coverage: Authored the platform’s first row-level-security admin pattern (scoped viewer access by business unit, region, and site), now the reference implementation being ported to every dashboard, and led a test-coverage initiative that put a CI gate in front of every merge across multiple apps
  • Data Governance at Scale: Led a 139-item audit moving business logic out of application code and into governed dbt SQL models across the entire analytics platform — scoping, sequencing, and prioritizing the migration by risk and value across 7+ production apps

Senior Data Analyst

Select Water Solutions

July 2024 – January 2026 (CTR via Insight Global: May–July 2024)

  • Enterprise AI Analytics Platform (BI Forge): Architected and built a company-wide BI platform combining a role-based dashboard hub (Azure AD/Entra ID) with an AI Prompt Studio that translates plain-English questions into SQL-backed visuals — serving 8 dashboard domains and eliminating the ad-hoc analyst request backlog
  • AI-Powered BI Pipeline (Streamline): Built a 7-stage AI-assisted pipeline taking dashboard visuals from stakeholder requirements to production Power BI artifacts — with live data validation, automated quality checks, DAX generation, and a formal sign-off gate
  • Data Quality Diagnostic Tool (Data Detective): Developed a chat-based AI tool that autonomously traces dbt lineage, runs live SQL, and diagnoses data quality issues in minutes — identifying root cause and fix owner across both active dbt repositories, reducing diagnosis time from hours to minutes
  • Advanced SQL & Query Optimization: Write and maintain complex SQL queries across 40+ Postgres site inventory tables to retrieve, analyze, and validate high-volume operational data with 100% accuracy
  • Enterprise BI Migration: Spearheaded the migration from Domo to Power BI, eliminating $1.2M in external consulting fees through internal resource optimization and technical leadership
  • Executive Dashboards: Delivered multiple production dashboards including an AFE Portfolio Dashboard (capital project budget/spend/CIP tracking), SCADA Volumes Dashboard (disposal facility utilization with 6-month forecast), and Labour & Chemical Cost Dashboards (cost-per-barrel efficiency with employee-level drill-down) across TRE Chem facilities
  • Process Improvement & Data Governance: Designed a multi-region data reconciliation framework across NE, Rockies, Permian, and MidCon; enforced data quality in Dataverse; documented dbt schema for 18+ models to power AI query accuracy

Business Data Analyst

HP Inc (via Insight Global)

April 2023 – April 2024

  • Developed high-level dashboards with drill-through capabilities for global teams across multiple business units
  • Acted as liaison between business requirements and dashboard development, translating stakeholder needs into technical specifications
  • Collaborated with data engineering teams to implement corrections and deploy new data pipelines
  • Promoted to lead senior management’s highest-priority dashboard initiative based on performance

Lead Healthcare Data Analyst

Tennessee Attorney General’s Office

February 2021 – April 2023

  • Produced analytical datasets supporting Medicare Fraud legal cases, directly contributing to prosecution outcomes
  • Designed new data organization processes to standardize attorney-facing reports for courtroom presentation
  • Gained direct TennCare database access, reducing dataset turnaround from 3 weeks to 2–3 days
  • Transitioned team presentations from Excel to Power BI for improved clarity and compliance documentation

Senior Application Analyst

Covenant Health, Knoxville

October 2018 – February 2021

  • Managed EHR systems and departmental workflows to strengthen operational efficiency across clinical departments
  • Performed server maintenance, daily backups, and custom reporting using SQL tools
  • Identified $4K/month in uncharged medication revenue via government-required opioid audit
  • Implemented new radiology procedures and automated backend nursing documentation forms

Focus Manager

MEDHOST Incorporated

April 2018 – October 2018

  • Increased customer satisfaction by 15% within three months through process improvements and communication channel redesign
  • Provided executive visibility into hospital performance and future regulatory needs
  • Promoted from Clinical Support Analyst — first such promotion in company history

Clinical Support Analyst Tier 1

MEDHOST Incorporated

January 2016 – April 2018

  • Troubleshot clinical software and HL7 interface issues with high accuracy across multiple hospital clients
  • Achieved 99% customer satisfaction by resolving technical and operational issues
  • Redesigned knowledge system that significantly improved first-call resolution rates

Driver Development & Safety Division Manager

Knight Transportation

September 2012 – August 2015

  • Led and supervised 60+ drivers, overseeing contracts, scheduling, and operational compliance
  • Accelerated gross revenue by 12% through fuel and speed management optimization
  • Reduced fleet idle time from 55% to 20% and significantly improved fuel component compliance
  • Received ‘Best Dispatcher’ award from drivers for leadership and operational excellence

Technical Skills

Data & Query Languages

SQL · Postgres · Microsoft SQL · AS400 · Dataverse · Azure Databases

BI & Visualization

Power BI · Dashboard Design · Data Modeling · DAX · Quarto

Engineering & Tools

Python · DBT · DBeaver · Sequel ViewPoint · Automation Tools · ETL

Domain & Industry

EHR Systems · MEDHOST · TMS/WMS · HL7 Interfaces · Healthcare · Transportation

Workflow & Collaboration

Jira · Service Desk · MS Office Suite · QuickBooks · Agile

Core Strengths

Stakeholder Communication · Data Governance · Process Optimization · Mentorship

Education

Lebanon High School

Lebanon, TN

© 2026 Edward Shane Christian

 

Built with Quarto