Job description

Job Title: Lead BI/Data/Web Developer Location-Type: Hybrid (3 days/week onsite: Mon/Tue/Thu, in NYC or Tysons, VA) Start Date Is: ASAP Duration: Permanent, Direct Hire Compensation Range: $130,000-$155,000/yr Benefits: Eligible for Health, Dental, Vision, 401K This position is not eligible for sponsorship. Job Description: Our client, a major media company, is seeking a highly experienced Lead BI/Data/Web Developer to join a newly formed data team. This is a hands-on development role, not just analytics/strategy — the ideal candidate will have 10 years of BI reporting experience, including 5 years of deep, hands-on Tableau development, and will architect and build performance-optimized Tableau solutions that transform complex media data into clear, actionable dashboards. This person will sit on the front-end/user-facing side of the business (data engineers handle the backend), working closely with a strong India-based Tableau development team as the senior US counterpart — not managing them directly, but serving as the go-to technical expert. Reporting will span audience/viewership, streaming/CTV, content performance, subscriptions, and advertising performance. This is not a "build me a dashboard" role — the ideal candidate understands the backend data, Tableau itself, and custom development around Tableau. Day-to-Day Responsibilities: • Lead the full lifecycle (design, development, testing, deployment) of complex Tableau dashboards covering metrics like subscriber churn, ad impressions, video views, content watch time, audience demographics, and campaign ROI • Build and maintain complex Tableau dashboards and reports for large-scale media and audience data • Build and customize a BI web portal around Tableau, including Tableau APIs, JavaScript, and PHP • Develop custom BI applications that function as a wrapper around Tableau reports using the Tableau API • Integrate the BI portal with backend AI agents to enable user interaction via text prompts (chatbot integration) • Work directly with business stakeholders from the start of a project to understand needs and translate them into dashboards and reports • Architect scalable, highly efficient Tableau data sources, optimizing query performance against large datasets (100 million rows) • Collaborate with Data Engineers and Scientists to define and refine data models (e.g., star schemas) in Snowflake, Redshift, or BigQuery • Serve as SME for advanced Tableau functionality, including complex LOD expressions, data blending, dynamic parameters, and performance tuning • Partner with Advertising Sales, Marketing, Content Strategy, and Finance teams to define reporting requirements and KPIs • Mentor junior developers on data storytelling, dashboard design, SQL optimization, and BI governance Minimum Requirements: • 10 years of professional BI development experience, including at least 5 years dedicated to Tableau in an enterprise environment • Expert-level Tableau Desktop and Tableau Server/Cloud proficiency • Advanced SQL skills for complex querying, ETL, and performance tuning against large/complex datasets • Hands-on experience with large-scale cloud data platforms (Snowflake, BigQuery, or Redshift) • Full-stack/web development skills — Tableau APIs, JavaScript, and PHP — with the ability to build and customize a web interface around Tableau • Experience designing, building, and supporting a BI portal environment (e.g., Apache Tomcat, PHP, JavaScript) • Media, entertainment, publishing, or AdTech industry experience, with an understanding of advertising, audience, content, viewership, or media performance data • AI fluency — able to intelligently explain what AI can and cannot do, and understands how to integrate AI into products/workflows • Strong stakeholder communication skills, comfortable working directly with business users from day one • Bachelor's degree or equivalent relevant work experience (degree in Data, Computer Science, or Math preferred) Preferred Qualifications: • Current Tableau Certified Professional certification or equivalent • Familiarity with Ad-Tech platforms (Google Ad Manager, DSPs, SSPs) or audience measurement tools (Nielsen, Comscore) • Experience with Python for data wrangling • Streaming/CTV experience (e.g., Roku, Fire TV, or similar large-scale digital media environments)

Requirements

Must-haves

Job Title: Lead BI/Data/Web Developer
Location-Type: Hybrid (3 days/week onsite: Mon/Tue/Thu, in NYC or Tysons, VA)
Start Date Is: ASAP
Duration: Permanent, Direct Hire
Compensation Range: $130,000-$155,000/yr
Build and maintain complex Tableau dashboards and reports for large-scale media and audience data
Build and customize a BI web portal around Tableau, including Tableau APIs, JavaScript, and PHP
Develop custom BI applications that function as a wrapper around Tableau reports using the Tableau API
Integrate the BI portal with backend AI agents to enable user interaction via text prompts (chatbot integration)
Work directly with business stakeholders from the start of a project to understand needs and translate them into dashboards and reports
Architect scalable, highly efficient Tableau data sources, optimizing query performance against large datasets (100 million rows)
Collaborate with Data Engineers and Scientists to define and refine data models (e.g., star schemas) in Snowflake, Redshift, or BigQuery
Serve as SME for advanced Tableau functionality, including complex LOD expressions, data blending, dynamic parameters, and performance tuning
Partner with Advertising Sales, Marketing, Content Strategy, and Finance teams to define reporting requirements and KPIs
Mentor junior developers on data storytelling, dashboard design, SQL optimization, and BI governance
10 years of professional BI development experience, including at least 5 years dedicated to Tableau in an enterprise environment
Expert-level Tableau Desktop and Tableau Server/Cloud proficiency
Advanced SQL skills for complex querying, ETL, and performance tuning against large/complex datasets
Hands-on experience with large-scale cloud data platforms (Snowflake, BigQuery, or Redshift)

Nice-to-haves

Bachelor's degree or equivalent relevant work experience (degree in Data, Computer Science, or Math preferred)
Current Tableau Certified Professional certification or equivalent
Familiarity with Ad-Tech platforms (Google Ad Manager, DSPs, SSPs) or audience measurement tools (Nielsen, Comscore)
Experience with Python for data wrangling
Streaming/CTV experience (e.g., Roku, Fire TV, or similar large-scale digital media environments)

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

gojavascriptapiaisqlpython

Platform: careers-html
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401k