Senior Business Intelligence Engineer

eBay•New York, NY

2d•$118,800 - $205,600•Remote

About The Position

At eBay, Nexpart plays a meaningful role in our mission by offering a B2B marketplace for professional automotive and truck parts companies. Our engineering team builds a world-class business intelligence and reporting platform. This platform helps our teams make faster and more accurate decisions using data from Elasticsearch, SQL Server, Dimensional Insights, flat files, and APIs. As a Senior Business Intelligence Platform Engineer, you will be responsible for crafting, developing, and improving our data platform to ensure smooth data flow and valuable analytics.

Requirements

5+ years of experience in business intelligence engineering, data engineering, or data platform development.
Extensive experience with ClickHouse in live or nearly live settings.
Strong proficiency in Python for ETL, data processing, automation, and production data workflows.
Advanced SQL skills for analytical queries, joins, aggregations, window functions, and query tuning.
Experience in collecting and combining data from systems such as Elasticsearch, SQL Server, APIs, and file-based sources.
Ability to convert business requirements into scalable technical solutions through direct collaboration with business partners.
Excellent debugging and problem-solving skills for data pipelines, SQL queries, and reporting logic.

Nice To Haves

Experience with Node.js, Next.js, TypeScript, React, or modern frontend development.
Experience in crafting APIs or backend services for reporting and analytics.
Experience with orchestration tools like Airflow, Prefect, Dagster, or custom Python schedulers.
Knowledge of Elasticsearch query patterns, indexing concepts, and large-scale search/log analytics data extraction.
Openness to learning TypeScript, JavaScript, and current frontend technologies if not already familiar.

Responsibilities

Develop, launch, and support a scalable BI and reporting platform using ClickHouse as the primary analytical database.
Develop robust Python-based ETL and ELT pipelines to extract, transform, validate, and load data from various sources.
Optimize ClickHouse query efficiency for dashboards, reports, and high-volume reporting tasks.
Build dimensional models, reporting marts, and reusable data assets.
Work alongside business partners to grasp reporting requirements and provide actionable dashboards and reports.
Assist in developing frontend reporting experiences with Next.js, TypeScript, Node.js, Tremor, AG Grid, and open-source charting libraries.
Develop AI-enabled reporting features for natural language queries and business performance insights.
Maintain technical documentation, data dictionaries, pipeline documentation, runbooks, and reporting definitions.