Lead BI/Data/Web Developer
TEGNA · New York, NY · 3 days ago
Engineering$130k–$155k/yrFull-time
Responsibilities
- Lead the entire lifecycle (design, development, testing, and deployment) of complex Tableau dashboards, focusing on key media metrics like subscriber churn, ad impressions, video views, content watch time, audience demographics, and campaign ROI.
- Translate advanced analytical models (e.g., attribution, predictive content scoring) into intuitive, high-impact visualizations for executive and operational users.
- Establish best-in-class visualization standards tailored for media data consumption, ensuring accurate and compliant reporting (e.g., Nielsen standards, privacy compliance).
- Utilize 10+ years of BI experience to architect scalable and highly efficient Tableau data sources, optimizing for query performance against large datasets from various media platforms.
- Collaborate extensively with Data Engineers and Scientists to define and refine data models (e.g., star schemas in Snowflake, AWS Redshift, or Google BigQuery) to ensure optimal structure for media reporting.
- Serve as the Subject Matter Expert (SME) for advanced Tableau functionalities, including complex LOD expressions, sophisticated data blending, dynamic parameters, and performance tuning for 100+ million row datasets.
- Partner directly with Advertising Sales, Marketing, Content Strategy, and Finance teams to elicit and document precise reporting requirements and KPIs.
- Mentor and guide junior developers on data storytelling, dashboard design principles, SQL optimization, and adherence to BI governance policies.
Requirements
- Minimum of 10+ years of professional experience in Business Intelligence development, with at least 5 years dedicated to Tableau in an enterprise environment.
- Deep, demonstrable experience in the Media, Entertainment, Publishing, or Ad-Tech industries, with a strong understanding of core media metrics.
- Expert proficiency in all facets of Tableau Desktop and Tableau Server/Cloud administration and governance.
- Exceptional command of Advanced SQL for complex data querying, ETL processes, and performance tuning.
- Proven experience working with large-scale cloud-based data warehouses (e.g., Snowflake, Google BigQuery, or AWS Redshift).
- Expertise in data modeling and designing data structures specifically for BI reporting efficiency.
- Comfortable with designing, building and supporting a BI Portal environment using Apache tomcat, PHP and JavaScript.
- Develop Custom BI Applications which work as a wrapper around Tableau Reports using Tableau API.
- Integrate BI Portal with backend AI Agents to facilitate user interaction via text prompts.
Preferred Qualifications
- Current Tableau Certified Professional or equivalent high-level certification.
- Familiarity with data from major Ad-Tech platforms (e.g., Google Ad Manager, DSPs, SSPs) or audience measurement tools (e.g., Nielsen, Comscore).
- Experience with scripting languages like PHP and/or Javascript, Python for data wrangling, Tableau APIs for custom Web BI Portal Development.