Business Intelligence Developer
Title: Business Intelligence Developer
Industry: Technology
Location: Culver City, CA
Duration: 12 months (likely to extend)
Responsibilities:
Own and maintain certified Tableau data sources and Tableau Prep flows, including data modeling, joins, dimensions, metadata, alerts, documentation, and reporting infrastructure. Design, develop, and optimize interactive Tableau dashboards and paid media reporting for business stakeholders while ensuring data accuracy, consistency, and performance. Investigate data quality issues, perform recurring QA reviews and quarterly reporting, document root causes, and coordinate resolutions with platform teams. Perform monthly affiliate commission reconciliation and support purchase order setup and financial reconciliation processes for streaming and music programs using Partnerize. Use SQL, Python, and AI tools to automate workflows and improve reporting efficiency while participating in sprint planning, project tracking, status reviews, peer reviews, and established QA standards.
Requirements:
5+ years of experience in marketing analytics, media reporting, or business intelligence development, with a strong understanding of paid media KPIs and cost metrics across Display, Video, Social, SEM, and Affiliate channels. Advanced Tableau expertise, including Tableau Prep, data modeling, published data sources, Level of Detail (LOD) expressions, performance tuning, dashboard design, and governed reporting environments. Strong SQL skills and experience working with complex datasets, interactive dashboards, certified data sources, and financial or invoice reconciliation against source systems. Experience troubleshooting data quality issues; familiarity with Python, Partnerize, AI tools, workflow automation, and standardized reporting frameworks is preferred. Strong attention to detail, documentation, independent delivery management, written communication, and cross-functional collaboration; candidates must provide a portfolio of live interactive Tableau work, such as a Tableau Public profile, live workbooks, or a packaged `.twbx` file. Skills TableauTableau PrepSQLBusiness Intelligence Marketing Analytics Paid Media Analytics Data Visualization Data Modeling PythonAffiliate Reconciliation Hourly rate is commensurate with experience and is an estimated range provided by WorkGenius.ref_id: caa7b750-f5b7-42c1-b4a8-e7de7629cbd9