About Orbee

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.
• C1 English required