Senior Data Analyst – Travel Entertainment

Remote from: LATAM
Annual salary: Undisclosed
Salary information is not provided for this position. Check our Salary Directory to estimate the average compensation for similar roles.
Department: Data Science & Analytics
Employment type: Full Time,
Job posted: 16 Jun 2026
Apply before: 16 Jul 2026
Experience level: Senior
Views / Applies: 103 / 18

About company

About Truelogic

Accelerate Your Digital Transformation

Computer Software
2011

Actively Hiring

AI Summary

This Senior Data Analyst role at Truelogic involves supporting a leading travel entertainment network by translating complex data into actionable advertising insights. The position requires advanced SQL, Python, and BI tools to build dashboards, analyze campaign performance, and automate workflows using GenAI. The ideal candidate has 5+ years of experience in advertising analytics and a strong business acumen to drive revenue growth. This role offers the opportunity to work with massive datasets and collaborate with engineering, product, and sales teams.

Role DNA

Job Complexity

Easy Hard

Pace & Pressure

Relaxed Fast-paced

Autonomy Level

Guided Full Ownership

Communication Load

Independent Highly Collaborative

AI Insight Requires 5+ years of experience with advanced technical skills (SQL, Python, cloud) and the ability to translate complex data into business narratives, making it challenging but manageable for a seasoned professional.

Salary Analysis

AI Insight The salary for this role is not explicitly stated, but based on market data for senior data analysts in advertising/media, the estimated median is $115,000, which is competitive for the required skill set and industry.

Key Skills

SQL Python Data Visualization AWS Advertising Analytics Audience Segmentation Tableau GenAI Snowflake Business Intelligence

Cover Letter Sample

Dear Hiring Manager,

I am excited to apply for the Senior Data Analyst position at Truelogic's client, a leader in travel entertainment. With over 5 years of experience in advertising analytics, I have honed my skills in SQL, Python, and BI tools to deliver impactful campaign insights. I am particularly drawn to this role because of the opportunity to leverage GenAI and work with large-scale datasets to drive strategic decisions.

My background includes building dashboards for audience segmentation, automating reporting workflows, and collaborating with cross-functional teams to optimize campaign performance. I am confident that my technical expertise and business acumen would add value to your team.

Thank you for considering my application. I look forward to discussing how I can contribute to your organization's success.

Sincerely, [Your Name]

Possible Interview Questions

Describe a complex SQL query you wrote to analyze advertising campaign performance. What was the business question, and how did you structure the query?

I wrote a query to calculate reach and frequency for a multi-channel campaign across TV and digital. I used CTEs to join impression data from a Redshift table with audience demographics from Snowflake, applied window functions for deduplication, and optimized with distribution keys. The result helped the sales team demonstrate incremental reach to a client.

How have you used GenAI tools to automate analytics workflows? Provide a specific example.

I used a custom GPT prompt to generate automated narrative summaries from campaign dashboards. The prompt ingested Tableau exports, and the output was a concise report highlighting key performance trends and anomalies. This reduced manual report writing time by 40%.

Explain how you would approach integrating third-party measurement data (e.g., Nielsen) with internal campaign data for a client report.

I would first identify common keys like campaign ID or date range, then perform a join in SQL after cleaning and normalizing the data. I'd validate against a known benchmark to ensure consistency, and then build a Tableau dashboard that overlays both data sources to show deduplicated reach and audience overlap.

Describe a time you turned complex performance data into a compelling narrative for a non-technical audience.

I presented to a client who was not data-savvy. I used a simple story arc: 'Here's the challenge, here's what the data shows, and here's the actionable recommendation.' I avoided jargon, used visual charts, and framed the results in terms of ROI and audience growth, which led to a contract renewal.

How do you stay updated on the latest trends in data analytics and advertising technology?

I follow industry blogs like AdExchanger and Data Engineering Weekly, participate in webinars on GenAI in analytics, and experiment with new tools in my personal projects. I also attend meetups and contribute to open-source projects related to data visualization.

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!

Apply now >