Reporting & Data Analyst
Job Description
Paul Logistics is hiring a technical, AI-first Reporting & Data Analyst to help build reporting and dashboarding capabilities from the ground up. This onsite role in Tulsa, OK focuses on SQL-based data work, KPI reporting, and automating recurring outputs using Claude, with an emphasis on accuracy against source systems and the general ledger.
What you’ll do
- Design and build reporting from scratch, including defining what to measure, identifying data sources, and structuring the data accordingly.
- Write and optimize SQL to extract and transform data from multiple systems, primarily McLeod, along with APIs, flat files, and spreadsheets, into clean and reusable datasets.
- Develop and maintain KPI dashboards and scorecards for leadership, pricing, operations, and finance using interactive dashboards, Power BI, Excel workbooks, and presentation-ready summaries.
- Track and report freight KPIs such as revenue and cost per mile, margin, utilization, and deadhead by customer, lane, truck, and business unit.
- Use Claude daily to analyze data, produce reports and dashboards, and verify every output against the general ledger and source data.
- Build reusable Claude workflows and automate recurring reports using scheduled tasks and connected apps, including Microsoft 365, SharePoint, and Excel.
- Support budgeting, forecasting, and cash flow projections, plus ad hoc analysis for decisions such as equipment purchases, pricing, new locations, and acquisitions.
Required qualifications
- Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or a related field.
- Strong SQL experience including joins, query optimization, and data modeling, in an IT-first role.
- A track record of building reports and dashboards from the ground up.
- Expert-level, daily use of Claude or similar AI tools, with strong prompting skills; a portfolio of 2–3 reports, dashboards, or automated workflows is required.
- Strong Excel skills, including pivot tables, lookups, formulas, and data modeling.
- Highly detail-oriented with a consistent habit of validating work against source data.
Tools and technologies
- SQL, Power BI, Excel, Claude, Microsoft 365, SharePoint
Compensation and schedule
- Salary: USD 55,000–65,000 per year
- Job type: Full-Time, Monday–Friday, 8:00 AM–5:00 PM
- Location: Tulsa, OK (On-site)
- Reports to: Chief Financial Officer
- Experience: 1–3 years in SQL, database, BI, or data reporting roles
Benefits
- Medical, dental, and vision insurance
- 401(k) with company match
- Paid time off and paid holidays
- Career growth opportunities
Preferred background
- FP&A or accounting background with solid understanding of the P&L, balance sheet, and cash flow
- Experience in logistics or transportation, and familiarity with McLeod
- Power BI experience including data modeling and DAX
- Experience with Claude Code, Claude skills, or connecting AI to business tools