Lead BI/Data/Web Developer

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) Mondo Staffing