BI & Analytics Engineering
Ethan Fleming · Senior Data Analyst · Twin Falls, Idaho
From the pipeline and the dimensional model to the report on someone's screen, I own BI end to end. The projects I enjoy most are the ones that make a measurable difference: hours handed back, calls that never needed to happen, and decisions made with data instead of instinct.
Every project starts with the question someone needs answered and the decision it feeds. Then I work backwards to the data.
Clean, tested dimensional models in dbt and SQL, so every report draws on one trusted source of truth.
Reports and automations people actually use, plus the training that lets them answer the next question themselves.
Projects
Built on my own time, end to end, so you can see exactly how I work.
Data engineering · Analytics
A full analytics stack on every Formula 1 session since 2023. A Python pipeline loads the OpenF1 API into DuckDB, dbt models it into a tested medallion architecture, and a dashboard publishes 130+ pages of race analysis, from fuel-corrected tyre wear to who left the most time on the table in qualifying.
More projects are in progress, including Power BI and semantic-modelling work on public data.
Work
Two projects from my current role as the sole analytics developer on a three-person data team at a direct-to-consumer healthcare company. Details stay general; the outcomes are real.
Toolkit
Both voted by colleagues.
About
I started my career as an Advanced EMT in Wyoming. On an ambulance you make fast, high-stakes decisions from incomplete information, and you document everything precisely because the next person depends on it. I also kept the service's inventory system running, tracking usage and forecasting supply orders, which turned out to be my first analytics project.
From there I moved into healthcare sales as a hearing consultant, where I built my first Tableau dashboards and realised the data was the part of the job I loved.
That still shapes how I work. The people using my reports are making decisions with whatever is in front of them, so my job is to make sure it's the right data, that they can trust it, and that it arrives before the decision does.
Today I own the BI stack end to end, from source-system integrations to the reports people open every morning, and I'm growing deeper into analytics engineering: dbt, testing, and treating data like software.