Senior Data Analyst – Travel Entertainment

Truelogic Software

Senior Data Analyst leveraging SQL and GenAI tools to optimize advertising campaigns and drive revenue growth. Collaborating with global teams on impactful data projects.

Posted 5/15/2026full-timeRemote • 🇨🇴 ColombiaSeniorWebsite

Tech Stack

Tools & technologies

Amazon RedshiftAWSBigQueryCloudPythonSQLTableauUnix

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Data AnalysisAdvertising AnalyticsSQLPythonRDescriptive StatisticsPredictive StatisticsData ModelingQuality ControlAudience Segmentation

Soft Skills

Communication SkillsInvestigative MindsetAnalytical ConsistencyClient-ready Value PropositionsProactive AnalyticsOptimization StrategiesProblem SolvingCollaborationNarrative DevelopmentStrategic Analysis