Data Analyst Lead

Lead the end-to-end development of complex reporting, measurement, and analytics solutions within Madhive’s product platform Translate business, product, and customer needs into technical requirements, reporting specifications, and implementation plans Design scalable reporting frameworks, dashboards, and automated solutions for internal teams and external customers Develop advanced analyses to identify performance trends, business opportunities, data quality issues, and actionable recommendations Serve as a subject matter expert for media measurement, reporting methodologies, data interpretation, and visualization design Ensure reporting solutions are accurate, intuitive, scalable, and aligned with business and customer needs Design, develop, and optimize ETLs, data pipelines, scheduled queries, and reporting automation Write and review advanced SQL queries for transforming, validating, and analyzing large datasets Partner with backend and data engineers on data models, reporting structures, system integrations, and technical requirements Investigate and resolve complex data discrepancies, reporting inconsistencies, and performance issues Establish validation, documentation, testing, and quality-control standards Evaluate tools, technologies, and approaches to improve reporting scalability, efficiency, and reliability Contribute to web-based reporting integrations, including iframe implementations and embedded analytics experiences Lead high-impact analytics projects involving multiple teams, systems, and stakeholders Define project scope, requirements, milestones, dependencies, risks, and success measures Partner with Product leaders to shape the analytics, measurement, and reporting roadmap Communicate technical concepts, project risks, analytical findings, and recommendations to technical and nontechnical audiences Act as an escalation point for complex reporting, data, and analytical issues Provide technical guidance, coaching, and mentorship to data analysts and team members Review analytical approaches, SQL, dashboards, technical documentation, and reporting solutions Establish standards for data analysis, visualization, documentation, and quality assurance Lead knowledge-sharing sessions and support project prioritization and work allocation Requirements 5 or more years of professional experience in data analytics, business intelligence, media analytics, data engineering, or a related field Bachelor’s degree in Data Analytics, Computer Science, Statistics, Mathematics, Engineering, or a related discipline Advanced proficiency in SQL Experience with Google BigQuery or comparable cloud-based data platforms Experience leading complex analytics or reporting projects from requirements gathering through implementation Strong experience designing and maintaining ETLs, data pipelines, scheduled queries, and reporting automation Experience with Google Cloud Platform, Airflow, GitHub, or comparable technologies Advanced experience with Looker, Tableau, Domo, Datorama, Looker Studio, TapClicks, or similar tools Strong experience wrangling, exploring, cleaning, validating, and analyzing large structured and unstructured datasets Ability to identify insights and translate findings into practical business and product recommendations Experience developing data models, technical requirements, testing plans, and reporting documentation Experience with embedded analytics, iframe integrations, APIs, or web development concepts Working knowledge of Python Experience across data environments such as Google Cloud, AWS, Hadoop, or similar platforms Experience mentoring analysts, reviewing technical work, or providing leadership across projects Strong written and verbal communication skills Ability to operate independently, manage competing priorities, and make sound decisions in an evolving environment Experience with advertising technology, streaming television, digital media, campaign measurement, or marketing analytics is an advantage Experience building customer-facing analytics or reporting products is an advantage Strong understanding of media performance metrics, attribution, audience measurement, or campaign reporting is an advantage Master’s degree is a plus Core Competencies Demonstrates advanced proficiency in SQL and experience with data analytics, reporting automation, and ETL processes. Capable of leading complex analytics projects, mentoring team members, and translating technical findings into actionable business insights. Highest-signal resume keywords Advanced SQL Proficiency ETL Development and Optimization Data Analytics Project Leadership Hard Skills Data Analytics Business Intelligence Data Engineering Data Pipeline Development Reporting Automation Data Validation Data Cleaning Data Modeling Technical Requirements Documentation Analytical Problem Solving Soft Skills Mentoring Independent Decision-Making Prioritization Collaboration Communication Industry Keywords Media Analytics Advertising Technology Campaign Measurement Digital Media Streaming Television Audience Measurement Performance Metrics Tools & Technologies Google Cloud Platform Airflow GitHub Looker Tableau Domo Datorama Looker Studio TapClicks APIs #J-18808-Ljbffr