Senior Analyst

AgileEngine; Colombia; Remote; COP 90,000,000 - 150,000,000; Full time

Benefits offered by this job

Remote work 100%

Flexible hours

Annual learning budget

Mentorship and TechTalks

Global collaboration

Job summary

AgileEngine's Senior Analyst builds Snowflake tables, Tableau dashboards, and reports to turn complex data into clear, actionable insights for Finance, Marketing, and Product teams.

You will translate findings into executive insights, communicate ROI to senior stakeholders, and apply SQL and Python to support revenue management, retention, and LTV analyses while ensuring data accuracy.

Qualifications

• 4+ years of experience with independent project ownership.
• Ability to translate analytical outputs into actionable insights for C-suite.
• Fluent/business‑level English (written and verbal) is required.
• Proficiency with SQL, Snowflake, Tableau or PowerBI, Excel, and Python.

Responsibilities

• Develop analytical and reporting database tables to track subscription and promotional performance.
• Produce and maintain monthly financial reports and variance analyses.
• Build reports and Tableau dashboards for Finance, Marketing, and Product.
• Apply quantitative analysis to understand customer behavior and impact of promotions.
• Support revenue management through discount modeling and retention/LTV analyses.
• Ensure data accuracy through data collection, quality controls, and anomaly resolution.
• Respond to ad hoc requests from multiple stakeholders in a timely manner.
• Collaborate with Insights & Analytics to integrate marketing and content data for holistic view.

Skills

SQL

Snowflake

Tableau/PowerBI

Python

Excel

Data storytelling

Education

Mathematics

Statistics

Industrial Engineering

Data Science

Economics

Operations Research

Computer Science

Tools

AWS/S3

SageMaker

Airflow

dbt

Job description

We are looking for an Senior Analyst to support data-driven decisions around subscriptions and promotional offers for a major OTT streaming business. This person builds Snowflake tables, Tableau dashboards, and reports that turn complex data into clear, actionable insights for Finance, Marketing, and Product teams. The role also involves translating analytical findings into executive-level insights and communicating business impact and ROI to senior stakeholders. SQL, Python, and strong analytical judgment are central to the role.

What you will do

• Develop analytical and reporting database tables to facilitate subscription and promotional offers performance tracking through efficient querying of large databases.
• Produce and maintain critical monthly financial reports, conducting variance analysis to resolve complex anomalies and provide clear explanations.
• Build reports and Tableau dashboards summarizing pertinent metrics and equipping various stakeholders with information for decision-making.
• Apply quantitative analysis on complex data to support the Insights team in efforts to understand customer behavior and impact of promotional offers.
• Support revenue management strategies by modeling discount strategies and analyzing subscriber retention and LTV.
• Ensure data accuracy through conscientious data collection and monitoring, development and execution of quality control processes, investigation and resolution of anomalies.
• Respond to a wide variety of ad hoc requests from Finance, Marketing, Distribution, Product, etc. in a timely and accurate manner.
• Work closely with other members of the Insights & Analytics team to incorporate marketing and content data, creating a holistic understanding of customers and how they interact with our products.

Must haves

• 4+ years of experience with independent project ownership for the Senior Analyst level.
• Data storytelling and strategic communication: Translating complex analytical outputs into actionable C-suite insights, executive presentations, and quantifiable ROI is crucial for the role.
• Fluent/business-level English (written and verbal) is required.
• College degree in Mathematics, Statistics, Industrial Engineering, Data Science, Economics, Operations Research, Computer Science, or equivalent work experience.
• Daily proficiency required in SQL, Snowflake, Tableau or PowerBI, Excel, and Python.
• Demonstrated proficiency in SQL (verified via test), including hands-on experience with CTEs, window functions, and date & time functions.
• Primary BI tool proficiency in Tableau to build and maintain dashboards.
• Familiarity with database models, transforming raw columnar data, and loading large datasets.
• Basic knowledge of statistics and/or machine learning.
• Familiarity with generative AI tools (e.g., Gemini, ChatGPT) for workflow efficiency, including effective prompt engineering and awareness of data security and accuracy risks.
• Strong communication skills for explaining the business implications of data analysis and visualizations.
• Thrives in small fast-paced environments with high individual accountability; capable of driving priorities to the finish line independently while exercising sound judgment on when to elevate.

Nice to haves

• Previous work experience with subscription and promotional offers data analysis.
• Specialized experience with AWS/S3, SageMaker, R, Airflow, and dbt.
• Growth without limits: build your skills through mentorship, internal TechTalks, challenging projects, and a dedicated annual learning budget
• Competitive compensation: get recognition that reflects your skills and impact, with regular performance and compensation reviews
• Flexibility: work 100% remotely with flexible hours that support focus, autonomy, and a healthy work rhythm
• Meaningful, modern projects: build impactful products using modern technologies alongside global teams and leading brands
• Collaborative culture: join a supportive environment with zero micromanagement where ideas are welcomed and contributions are recognized
• Well-being & support: access local well-being programs and people-focused support tailored to your location