Senior Data Analyst – Travel Entertainment

ABOUT TRUELOGIC At Truelogic we are a leading provider of nearshore staff augmentation services headquartered in New York. For over two decades, we’ve been delivering top-tier technology solutions to companies of all sizes, from innovative startups to industry leaders, helping them achieve their digital transformation goals. Our team of 600+ highly skilled tech professionals, based in Latin America, drives digital disruption by partnering with U.S. companies on their most impactful projects. Whether collaborating with Fortune 500 giants or scaling startups, we deliver results that make a difference. By applying for this position, you’re taking the first step in joining a dynamic team that values your expertise and aspirations. We aim to align your skills with opportunities that foster exceptional career growth and success while contributing to transformative projects that shape the future. OUR CLIENT A leading multi-channel digital entertainment network specializing in travel-based media and live sports broadcasting. Reaching millions of viewers across major U.S. airports and luxury hotel properties, they leverage a massive distribution network to connect premier brands with high-value audiences. JOB SUMMARY We are seeking a highly analytical, business-oriented Senior Data Analyst to bridge the gap between large-scale data signals and strategic advertising intelligence. This role is pivotal in transforming mobile location data, audience metrics, and live sports campaign delivery into actionable narratives that drive revenue and client growth. The ideal candidate is a SQL expert who thrives in complex data environments and is eager to leverage GenAI tools to automate workflows and elevate the quality of campaign insights for major global brands and agencies. RESPONSIBILITIES - Build and maintain high-impact dashboards and visualizations focusing on advertising campaign performance, audience delivery, and inventory measurement. - Support a proactive analytics program by providing in-flight pacing insights, optimization strategies, and comprehensive post-campaign wrap reports. - Analyze multi-faceted datasets including audience composition, reach and frequency, geography, and venue-specific performance. - Integrate internal data with third-party measurement sources such as Nielsen, NMI, MRI-Simmons, and iSpot. - Translate technical campaign data into concise, client-ready value propositions for executive leadership and sales teams. - Automate recurring analytical workflows and reporting requests to enhance scalability and data quality control. - Utilize GenAI tools and custom prompts to accelerate insight generation, reporting narratives, and documentation. - Partner with Engineering, Product, and Ad Operations to investigate data anomalies and improve overall data architecture. - Conduct ad hoc strategic analysis to identify inventory opportunities, pricing support, and long-term client growth potential. QUALIFICATIONS AND JOB REQUIREMENTS - 5+ years of experience in Data Analysis, Advertising Analytics, or a similar quantitative role focused on marketing measurement. - Advanced SQL proficiency, including complex joins, window functions, and performance-aware querying against large-scale datasets. - Deep experience with advertising campaign analysis, media planning, attribution, and audience segmentation. - Hands-on experience with cloud-based data environments such as AWS, Redshift, Snowflake, or BigQuery. - Proficiency in Python or R for data automation, statistical analysis, and repeatable reporting workflows. - Strong expertise with BI tools such as Tableau, Power BI, Looker, or Adobe Analytics. - Proven ability to turn complex performance data into clear business narratives that drive renewals and upsells. - Demonstrated interest in using modern AI-enabled tools to improve productivity and analytical consistency. - Solid foundation in descriptive and predictive statistics, data modeling, and quality control. - Familiarity w