Data Analyst

Flock Freight • Encinitas, CA

6d • $75,000 - $105,000 • Hybrid

About The Position

Flock Freight is hiring a Data Analyst for its Business Analytics Team. Reporting to the Manager of Business Analytics, this business-facing role turns complex business questions into meaningful insights that improve organizational decision-making. The analyst partners with teams across Sales, Account Management, Carrier Sales, and Operations to understand challenges, identify opportunities, and deliver reporting and analysis that supports effective business decisions.

The role emphasizes SQL, stakeholder collaboration, and practical problem-solving. Responsibilities include building and maintaining reporting models, developing dashboards, managing ad hoc analysis requests, and translating business processes into reliable, actionable data. The analyst works closely with experienced analysts and engineers, owns analytical work that supports business teams, and can grow technical expertise, specialized business knowledge, and contributions to increasingly complex projects.

The position targets candidates in the San Diego/Encinitas and Los Angeles areas, with candidates local to or willing to relocate to Flock Freight’s San Diego headquarters. The company uses a hybrid work model, with in-office days on Monday, Tuesday, and Thursday.

Requirements

• 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 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 Sigma, Tableau, Power BI, Looker, or similar platforms.
• Strong analytical and problem-solving skills, including interpreting business requirements, investigating data, and translating 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 to prioritize competing requests, manage multiple deliverables, and maintain accuracy in a fast-paced environment.
• Clear written and verbal communication skills, including explaining analytical findings to technical and non-technical audiences.

Nice To Haves

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

Responsibilities

• Partner with stakeholders across Sales, Account Management, Carrier Sales, and other business teams to understand 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.
• 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 to help teams categorize information, monitor performance, and improve workflows.
• Present findings and recommendations clearly to technical and non-technical stakeholders.
• 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.

Benefits

• Equity package for full-time employees.
• Competitive benefits supporting employees and their families.
• Hybrid work model with scheduled in-office and work-from-home days; in-office days are Monday, Tuesday, and Thursday.
• 401(k).
• Medical, dental, and vision coverage for employees and dependents, with HMO and PPO options.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level