Data Analyst

Orbee; Irvine (CA); On-site; USD 70,000 - 100,000; Full time

Job summary

Orbee, headquartered in Irvine, is seeking a highly skilled Data Analyst to join our Reporting and Data Services team. You will query databases, investigate data discrepancies, audit marketing lists, and build client-ready reports that power Orbee’s analytics platform.

You will collaborate with the US-based reporting team on a daily basis, write complex SQL, validate data quality, and ensure accuracy before delivering insights to automotive clients.

Qualifications

• 2–4 years of experience as a Data Analyst or BI Analyst.
• Strong SQL skills with complex joins and aggregations.
• Experience with marketing, SaaS, or automotive data preferred.

Responsibilities

• Write, debug, and optimize SQL queries to extract and analyze large automotive marketing data.
• Investigate data logic issues from HubSpot and Jira tickets.
• Audit and standardize external data sets for reporting.
• Build, update, and maintain client-facing dashboards and reports in BI tools.
• Perform QA to ensure accuracy before delivering to CS team.
• Collaborate with US-based team via daily stand-ups to handle ad-hoc data requests.

Skills

SQL

PostgreSQL

Clickhouse

Data QA

Tools

HubSpot

Jira

Job description

Orbee provides digital marketing analytics, data, and automation solutions to the automotive industry. Franchise and independent dealers and large dealership groups utilize the company’s platform to make actionable decisions based on analytics of their campaigns, inventory, and consumer experiences, build comprehensive buyer profiles by connecting first-party data signals from their web sites and integrated partners and automate messaging across all paid and earned channels with personalization and segmentation. The company partners with dealer-centric media agencies, service providers, and OEM programs to expand the reach of its powerful technologies. Orbee’s core technology products include its proprietary data collection, processing, and reporting pipeline, its robust set of dashboards and APIs, and campaign and creative tools for email, search, social, on and off-site display, and video. Orbee was founded in 2015 and is headquartered in Irvine, California. Learn more at www.orbee.com .

Description

We are looking for a highly skilled and detail-oriented Data Analyst to join our Reporting and Data Services team. Working directly from requests funneled through our US-based reporting leads, you will be the analytical engine of the team. Your primary goal is to query our databases, investigate data discrepancies, audit marketing lists, and build the reporting deliverables that power Orbee’s Data Platform and Analytics, Marketing, and Advertising Applications. You will handle the heavy analytical lifting, ensuring that the data presented to our automotive clients is accurate, unified, and actionable.

Key Responsibilities:

• Write, debug, and optimize complex SQL queries to extract, aggregate, and analyze massive sets of automotive marketing and inventory data.
• Investigate and resolve specific data logic issues assigned via HubSpot and Jira, such as tracking down historical CRM and data discrepancies.
• Audit and standardize large external data sets (e.g., reviewing automated email lists, ad platform performance data, and vendor feeds) to ensure data cleanliness before reporting.
• Build, update, and maintain client-facing dashboards and reports within our BI environments, working strictly to the product vision outlined by the team lead.
• Perform rigorous QA on data sets and reports to ensure flawless deliverables for our Customer Success (CS) team.
• Collaborate with the US-based reporting team via daily stand-ups to clear the analytical backlog and fulfill ad‑hoc data requests.

Qualifications:

• 2-4 years of experience as a Data Analyst, BI Analyst, or similar role, ideally dealing with marketing, SaaS, or automotive data.
• Advanced proficiency in SQL (PostgreSQL and Clickhouse preferred), with the ability to comfortably write complex joins, CTEs, and aggregations.
• Exceptional attention to detail and a proactive approach to investigating "why" numbers might not match up.
• Ability to take structured analytical requirements (Jira tickets) and execute them efficiently with minimal oversight.