Senior Data Analyst – Travel Entertainment (Colombia) at Truelogic

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 with Unix commands, regular expressions, and structured data workflows. - Exceptional communication skills with the ability to explain technical findings to non-technical stakeholders. - Investigative mindset with a track record of identifying root causes in complex data scenarios. WHAT WE OFFER - 100% Remote Work: Enjoy the freedom to work from the location that helps you thrive. All it takes is a laptop and a reliable internet connection. - Highly Competitive USD Pay: Earn an excellent, market-leading compensation in USD, that goes beyond typical market offerings. - Paid Time Off: We value your well-being. Our paid time off policies ensure you have the chance to unwind and recharge when needed. - Work with Autonomy: Enjoy the freedom to manage your time as long as the work gets done. Focus on results, not the clock. - Work with Top American Companies: Grow your expertise working on innovative, high-impact projects with Industry-Leading U.S. Companies. WHY YOU’LL LIKE WORKING HERE - A Culture That Values You: We prioritize well-being and work-life balance, offering engagement activities and fostering dynamic teams to ensure you thrive both personally and professionally. - Diverse, Global Network: Connect with over 600 professionals in 25+ countries, expand your network, and collaborate with a multicultural team from Latin America. - Team Up with Skilled Professionals: Join forces with senior talent. All of our team members are seasoned experts, ensuring you're working with the best in your field. Apply now!