About Me

PL-300 & DP-900 Certified· Power BI Developer

Power BI reporting, built to aerospace standards.

I spent eight years in aerospace engineering, helping optimize the performance of aircraft and rocket engines. Structural test and simulation data drove every design decision. Now I bring that foundation to Power BI data solutions and reporting. Trusted across multiple industries, I help companies turn complex data into clear, reliable insights.

Power BIMicrosoft FabricSQLDAXPower QueryCopilot
Joshua Lamothe
Joshua Lamothe
Power BI Developer
Middletown, DE
At a glance
Current role
Power BI Developer, we-do-ITSince January 2026
Experience
12+ years working with data8 years in aerospace engineering
Certifications
Microsoft PL-300 and DP-9002025
Education
B.S. Aerospace EngineeringUniversity of Florida, 2014
Career Trajectory, 2014 to Present 5 roles · 2014 to present · engineering to BI
Toolkit

BI Tools & Skills

The core stack behind every dashboard, model, and analysis I ship.

BI
Power BI
PL-300 certified
Fx
Microsoft Fabric
Lakehouses, semantic models, governance
Dx
DAX & M Code
Advanced measures, Power Query ETL
SQL
SQL
T-SQL, Azure SQL, Snowflake
AI
Copilot & AI
Copilot, Claude, agentic workflows
Career

Where I’ve Worked

From aerospace structural analysis to enterprise Power BI development. These are the roles that shaped how I build reporting systems today.

Jan 2026 –
Present

Power BI Developer

Current

we-do-IT · Utilities

Leading Power BI reporting for a geospatial and data services company for utilities, from revenue and invoicing to tracking every customer account, and delivering customer analytics dashboards its managers rely on.

Sep 2024 –
Jul 2025

Business Intelligence Developer

Broadway Ventures · Healthcare

Helped a Medicare audit department go from 80+ manual reports to reliable Power BI dashboards, cutting reporting time by 60%. Teams could track 100,000+ HIPAA-regulated cases in one place and answer their own questions.

Nov 2023 –
Jul 2024

Business Data Analyst

Suited Connector · Marketing

Showed a home services lead marketplace which of its 40+ U.S. markets were working and which weren’t, across 15,000+ leads a day, helping grow margins, partner ROI, and client retention.

Mar 2022 –
Jun 2023

Senior Engineer, Structural Data & Reporting

Belcan · Space

Led a team of four that turned simulation data from 200+ rocket engine components into the validation reports engineers used to sign off on designs, delivered ahead of schedule and 20% faster to review.

Oct 2014 –
Dec 2021

Structural Data & Reporting Engineer

Agilis Engineering · Aerospace

Analyzed structural simulation and test data from over 300 aircraft and rocket engine models, refining designs until they met requirements. Built dashboards and automated data workflows that cut manual calculation time in half and rework by 40%.

Portfolio

Featured Projects

Dashboards and analysis built end to end, from raw data to the finished report.

Sales vs budget SalesBudget
Power BISQLData modeling

Sales Management Dashboard

A three-page Power BI report that replaces static sales reports, so managers can track sales against budget and drill into any customer or product.

3 report pages · AdventureWorks data · budget from Excel
Read the case study →
Orders by day & month FewerMore
Power BISQL

Pizza Sales Analytics

A two-page report on a full year of orders: what sells, when it sells, and which pizzas drag the menu down. KPIs calculated in SQL, then built out in Power BI.

21K orders · 2015 sales data
Read the case study →
Rides by hour MembersCasual
Rggplot2Statistics

Bike-Share Rider Analysis

Cleaned and analyzed 5.7 million trips in R to show how members and casual riders use the service differently, ending in three marketing recommendations.

5.7M rows · Divvy public data · Google capstone
Read the case study →
Orders by category ConsumerCorporateHome office
Looker StudioExcel

Orders Dashboard

An interactive Looker Studio dashboard covering 9,994 orders, with filters for region, segment, category and ship mode so anyone can find their own answer.

1 page · retail orders dataset, 2014 to 2017
Read the case study →
Credentials

Certifications & Education

Microsoft · 2025
Azure Data Fundamentals
DP-900
Google · 2023
Data Analytics Certificate
Certificate
Macquarie University · 2023
Excel Skills for Business: Essentials
Course
Coursera · 2023
Mastering Advanced SQL Queries
Course
University of Florida · 2014
B.S. Aerospace Engineering
Degree
Core strengths Interactive Dashboard Development Data Modeling & Transformation KPI Design & Metric Alignment Stakeholder Communication Data Governance & Lineage ETL Process Design Advanced DAX Calculations Ad Hoc & Executive Reporting
Joshua Lamothe
About

About Joshua

I started my career as an aerospace engineer, spending eight years analyzing structural test and simulation data for aircraft and rocket engine components. The work was detail-heavy and the data had to be right, which is what carried over when I moved into analytics full time in 2023.

Since then I’ve earned my Microsoft PL-300 and DP-900 certifications and built BI systems across marketing, healthcare, and now enterprise data.

Today I’m a Power BI Developer at we-do-IT. I build and govern reporting on Microsoft Fabric, and I’ve been using Copilot and Claude to speed up how I build and validate dashboards.

Let’s connect.

Always glad to talk Power BI, Fabric, data governance, or analytics. Reach out anytime.