Lead BI/Data/Web Developer

Lead BI/Data/Web DeveloperOur 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 ROIBuild and maintain complex Tableau dashboards and reports for large-scale media and audience dataBuild and customize a BI web portal around Tableau, including Tableau APIs, JavaScript, and PHPDevelop custom BI applications that function as a wrapper around Tableau reports using the Tableau APIIntegrate 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 reportsArchitect 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 BigQueryServe as SME for advanced Tableau functionality, including complex LOD expressions, data blending, dynamic parameters, and performance tuningPartner with Advertising Sales, Marketing, Content Strategy, and Finance teams to define reporting requirements and KPIsMentor junior developers on data storytelling, dashboard design, SQL optimization, and BI governanceMinimum Requirements:10+ years of professional BI development experience, including at least 5 years dedicated to Tableau in an enterprise environmentExpert-level Tableau Desktop and Tableau Server/Cloud proficiencyAdvanced SQL skills for complex querying, ETL, and performance tuning against large/complex datasetsHands-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 TableauExperience 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 dataAI fluency — able to intelligently explain what AI can and cannot do, and understands how to integrate AI into products/workflowsStrong stakeholder communication skills, comfortable working directly with business users from day oneBachelor's degree or equivalent relevant work experience (degree in Data, Computer Science, or Math preferred)Preferred Qualifications:Current Tableau Certified Professional certification or equivalentFamiliarity with Ad-Tech platforms (Google Ad Manager, DSPs, SSPs) or audience measurement tools (Nielsen, Comscore)Experience with Python for data wranglingStreaming/CTV experience (e.g., Roku, Fire TV, or similar large-scale digital media environments)