Data Analyst

Responsibilities

The Data Analyst will partner with cross-functional teams to translate complex business questions into actionable insights and reporting. They will build and maintain dashboards, optimize SQL queries, and improve data-driven decision-making across the organization.

Requirements

Candidates must have a bachelor's degree in a quantitative field and 2-4 years of professional experience in data or business analytics. Strong proficiency in SQL and experience with dashboarding tools like Tableau, Looker, or Sigma are required.

Skills

• SQL
• Data analysis
• Business analytics
• Dashboarding
• Reporting models
• Stakeholder management
• Problem-solving
• Excel
• Google Sheets
• Data visualization
• Communication
• Python
• Statistical analysis

Benefits

• 401(k)
• Medical insurance
• Dental insurance
• Vision insurance
• Equity package

About this role

Company Overview

Flock Freight is the largest Shared Truckload (STL) freight brokerage in the
U.S., transforming underutilized truckload capacity into tangible value: cost
savings for shippers, increased earnings for carriers, and a smaller carbon
footprint.

Their AI-powered, patented pooling technology optimizes across Flock’s entire
customer network, combining shipments from thousands of businesses into
efficient Shared Truckloads. With STL, shippers enjoy truckload-level service
while only paying for the space they need. Trusted by thousands of customers,
from some of the largest enterprises to growing brands, Flock Freight delivers
an unmatched combination of cost efficiency, exceptional service, and a
streamlined shipping experience.

Flock Freight has been a Certified B Corp since 2020, meeting high social,
environmental, transparency, and accountability standards to all of our
stakeholders.

Team/Department Overview: Business Analytics Team – Reporting to the Manager of
Business Analytics.

Flock Freight is hiring a Data Analyst to help turn complex business questions
into meaningful insights that improve decision-making across the organization.
You’ll partner closely with teams across Sales, Account Management, Carrier
Sales, and Operations to understand their challenges, identify opportunities,
and deliver reporting and analysis that supports smarter, more effective
business decisions.

This is a hands-on, business-facing analytics role with a strong emphasis on
SQL, stakeholder collaboration, and practical problem-solving. You’ll build and
maintain reporting models, develop dashboards, manage ad hoc analysis requests,
and translate business processes into reliable, actionable data. You’ll work
closely with experienced analysts and engineers while taking ownership of
analytical work that directly supports the teams driving Flock’s business.

As you grow in the role, you’ll have opportunities to deepen your technical
expertise, develop specialized business knowledge, and contribute to
increasingly complex analytical projects.

KEY RESPONSIBILITIES

* Partner with stakeholders across Sales, Account Management, Carrier Sales,
and other business teams to understand their reporting needs, investigate
challenges, and translate business questions into actionable analysis.
* Write and optimize SQL queries to extract, transform, and analyze data from
multiple sources, supporting accurate reporting and informed decision-making.
* Build, maintain, and improve reporting models, dashboards, and analytical
tools that provide visibility into business performance and operational
workflows.
* Own and prioritize incoming analytics requests, balancing immediate business
needs with accuracy, efficiency, and longer-term analytical priorities.
* Translate business processes and requirements into structured reporting logic
that helps teams categorize information, monitor performance, and improve
workflows.
* Present findings and recommendations clearly to technical and non-technical
stakeholders, helping teams understand the data and make confident decisions.
* Collaborate with analysts, engineers, and cross-functional partners to
improve reporting consistency, data quality, and analytical processes.
* Identify opportunities to streamline recurring reports, automate manual
workflows, and make data more accessible and useful across the organization.

WHAT YOU'LL BRING

* Bachelor’s degree in a quantitative, analytical, or related field, or
equivalent practical experience.
* Approximately 2–4 years of professional experience in data analytics,
business analytics, or a related analytical role.
* Strong SQL proficiency, including experience independently writing complex
queries using joins, common table expressions (CTEs), window functions, and
other advanced SQL techniques.
* Experience building and maintaining dashboards, reporting models, and
analytical solutions using tools such as Sigma, Tableau, Power BI, Looker, or
similar platforms.
* Strong analytical and problem-solving skills, with the ability to interpret
business requirements, investigate data, and translate findings into
practical recommendations.
* Experience partnering directly with business stakeholders to gather
requirements, manage reporting requests, and communicate analytical findings.
* Proficiency with Excel, Google Sheets, or similar spreadsheet tools for data
analysis and reporting.
* Strong organizational skills, with the ability to prioritize competing
requests, manage multiple deliverables, and maintain accuracy in a fast-paced
environment.
* Clear written and verbal communication skills, with the ability to explain
analytical findings to both technical and non-technical audiences.

NICE TO HAVE

* Experience using Python for data manipulation, reporting automation, or
workflow improvements.
* Exposure to statistical analysis, data science libraries, or machine learning
concepts.

WHAT SETS YOU UP FOR SUCCESS

* Enjoy solving practical business problems and using data to help teams make
better decisions.
* Take ownership of your work, from understanding the initial request to
delivering accurate, actionable insights.
* Are naturally curious, ask thoughtful questions, and look beyond the
immediate request to understand the underlying business challenge.
* Build strong relationships with stakeholders and communicate confidently with
colleagues across different functions and levels of technical expertise.
* Can balance competing priorities, adapt to changing business needs, and
deliver quality work without losing sight of the bigger picture.
* Bring strong attention to detail, sound judgment, and a commitment to
producing reliable analysis.
* Are eager to expand your technical capabilities, develop deeper business
knowledge, and grow alongside an experienced analytics team.

COMPENSATION

The expected...

About Flock Freight

Transportation, Logistics, Supply Chain and Storage · 201-500 employees · headquartered in Encinitas, California · founded 2015