Business Intelligence Analyst

Value Truck of AZ. Inc.
South Jordan, United States of America
9 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior
Compensation
$ 80K

Job location

South Jordan, United States of America

Tech stack

Microsoft Excel
API
Artificial Intelligence
User Authentication
Business Systems
Information Systems
Information Engineering
ETL
Data Transformation
Dataspaces
Data Systems
Data Visualization
Data Warehousing
Cursor (Graphical User Interface Elements)
Software Debugging
Excel Formulas
JSON
Python
Pivot Tables
Sage Accounting
SQL Databases
Data Streaming
Systems Integration
Sql Optimization
Informatica Cloud
Powerquery
Pandas
Information Technology
Data Analytics
QlikView
SQL Server Management Studio (SSMS)
REST
Pagination
Code Restructuring
Data Pipelines
Api Management
Web Api

Job description

We are seeking a motivated Business Intelligence Analyst with a strong data engineering orientation to join our growing analytics team. This high-visibility role is pivotal to our hyper-growth journey: you will engineer robust data pipelines, integrate systems via APIs, leverage AI coding tools daily to move fast and deliver quality, and produce insights that directly shape financial strategy and operational excellence across our trucking and logistics business.

This is a perfect role for someone early in their career who loves coding, is genuinely excited about using generative AI tools to supercharge productivity and creativity, understands the nuances of finance and logistics metrics, and wants to wear multiple hats in a collaborative, problem-solving culture. Your contributions will have immediate, visible impact as we scale., * Design, build, and maintain scalable ETL/ELT data pipelines and dimensional data models that consolidate data from financial systems (including Sage Intacct), TMS platforms, telematics, external APIs, and other sources into a reliable analytics foundation.

  • Write efficient, well-documented SQL and Python code for data transformation, analysis, automation, and API integrations. Extensively leverage generative AI coding assistants (Claude, Grok, Cursor, etc.) to accelerate development, improve quality, and innovate.

  • Create clear, interactive dashboards and KPI reports in Qlik and other BI tools that deliver actionable visibility into financial metrics (revenue, margins, cost analysis, profitability by lane/customer) and logistics KPIs (asset utilization, on-time delivery, fuel efficiency, route performance, etc.).

  • Integrate and consume data from RESTful APIs and various business systems, handling authentication, JSON parsing, and error management to automate and enrich data flows.

  • Perform ad-hoc analyses and root-cause investigations to uncover trends, inefficiencies, cost-saving opportunities, and strategic growth levers in our trucking and finance operations.

  • Collaborate closely with finance, operations, and leadership stakeholders in an agile environment-translating business questions into technical solutions and delivering insights that drive better decisions.

  • Establish and promote data quality, documentation, and governance best practices as our data ecosystem expands rapidly with company growth.

  • Proactively identify opportunities and prototype innovative data solutions, automations, or analytics capabilities that support our hyper-growth objectives and competitive positioning.

Requirements

  • 1-3 years of hands-on professional experience in business intelligence, data analytics, or data engineering roles. Direct experience supporting finance teams or working in trucking, logistics, or supply chain industries is a strong advantage.

  • Strong Excel knowledge is required (advanced formulas, PivotTables, Power Query, data modeling).

  • Advanced SQL skills (complex joins, window functions, optimization) using tools such as SSMS and solid Python programming experience for data work (pandas, requests or similar for APIs, scripting).

  • Practical experience designing and implementing data pipelines, ETL/ELT processes (including Prefect and SnapLogic), and data modeling (star/snowflake schemas, facts & dimensions).

  • Hands-on experience consuming and integrating REST APIs (authentication methods, JSON handling, pagination, error handling).

  • Proficiency with BI/visualization tools such as Qlik and others for building insightful, executive-ready reports and dashboards.

  • Working knowledge of key finance concepts/metrics (Sage Intacct experience a plus) and/or core trucking & logistics KPIs (e.g., revenue per mile, cost per mile, load factor, deadhead percentage, on-time performance).

  • Demonstrated comfort, enthusiasm, and regular hands-on use of generative AI coding tools to write better code faster, debug efficiently, refactor, and explore creative solutions. Examples of your AI-assisted work are welcome!

  • Bachelor's degree in Data Analytics/Science, Computer Science, Information Systems, Finance, Business Analytics, or a closely related field (or equivalent practical experience).

  • Strong problem-solving mindset, innovative thinking, self-motivation, and adaptability to excel in a hyper-growth, fast-moving, sometimes ambiguous environment.

  • Excellent verbal and written communication skills with the ability to bridge technical details and business impact for diverse stakeholders.

Preferred / Nice-to-Have

  • Familiarity with logistics or transportation technology platforms (TMS systems, ELD/telematics like Samsara or Geotab).

  • Prior work experience in a high-growth startup, scale-up, or rapidly expanding company or team.

  • Understanding of data visualization best practices, dashboard storytelling, or basic statistical/analytical techniques.

Benefits & conditions

401(k), Health insurance, Paid time off, Vision insurance, Dental insurance Full-time South Jordan, UT 84065, Salary Range: $70,000 - $80,000 per year | Full-Time, * Competitive Pay & Growth: $70,000 - $80,000 base salary (based on experience). Clear, accelerated career path in a growing analytics function.

  • High-Impact, Visible Role: Your work will directly influence strategy, operations, and financial outcomes in a hyper-growth logistics company where data and technology are central to competitive advantage. High visibility with leadership.

  • Innovative Tech Environment: Daily access to cutting-edge AI coding tools, modern data platforms (including Qlik, SnapLogic, Prefect, SSMS, Sage Intacct), and the freedom to experiment and prototype. We invest in the tools that let you do your best work.

  • People-First Culture: Collaborative, supportive team that values innovation, continuous learning, psychological safety, and work-life balance. We're building something meaningful together.

  • Flexibility & Benefits: In-office preferred in South Jordan, Utah, with hybrid considered only as an exception. Comprehensive benefits including medical, dental, vision, generous PTO, and more.

  • Real-World Mission: Contribute to optimizing supply chains that move goods across North America-tangible impact on efficiency, sustainability, and the economy., * 401(k)

  • Dental insurance

  • Health insurance

  • Vision insurance

About the company

Value Truck is a dynamic, technology-forward trucking and logistics leader with over 20 years of proven success in trucking and supply chain solutions across North America. We operate a robust fleet of 300+ trucks and 1,000+ trailers through our trucking logistics department, with offices and strategic terminals in the US and Mexico-including our South Jordan, UT office. We specialize in cross-border freight (US-Mexico), refrigerated, open deck, dry van, and specialized hauling. We are in an exciting hyper-growth phase, rapidly scaling operations while embracing data, automation, and AI to optimize finance, fleet performance, and customer experiences. Our people-first, innovation-driven culture empowers team members to solve meaningful problems, drive efficiency, and make high-impact contributions in a fast-paced environment that combines startup agility with established industry stability. If you thrive on using data and code to power real-world logistics innovation, Value Truck is the place for you.

Apply for this position