Analyst Subscriptions And Pricing Id86906

Agileengine; Curitiba; Presencial; BRL 120 000 - 180 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Professional growth

Competitive USD compensation

Varied projects

Flextime / remote options

Resumo da oferta

AgileEngine seeks an Analyst/Senior Analyst to drive data-driven decisions around subscriptions and promotional offers for a major OTT streaming business. You will build Snowflake tables, Tableau dashboards, and reports turning complex data into actionable insights for Finance, Marketing and Product teams.

The role emphasizes translating findings into executive-level insights, ROI, and communicating business impact, with strong SQL, Python, and storytelling expectations.

Qualificações

• 4+ years of independent project ownership for the Senior Analyst level.
• Data storytelling and strategic communication: translating complex analytics into executive-level insights and ROI.
• Fluent/business-level English (written and verbal).
• Bachelor’s degree in Mathematics, Statistics, Industrial Engineering, Data Science, Economics, Operations Research, Computer Science, or equivalent work experience.
• Daily proficiency in SQL, Snowflake, Tableau or PowerBI, Excel, and Python.
• Proficiency in SQL with hands-on experience using CTEs, window functions, and date/time functions.
• Tableau as primary BI tool for dashboards.
• Familiarity with transforming raw columnar data and loading large datasets.
• Basic knowledge of statistics and/or machine learning.
• Familiarity with generative AI tools for workflow efficiency and data security awareness.
• Strong communication skills to explain business implications of data analysis and visualizations.
• Ability to work in fast-paced environments with high accountability and drive priorities to completion.
• Experience with subscription and promotional offers data analysis is a plus.

Responsabilidades

• Develop analytical and reporting tables to track subscription and promotions performance with efficient SQL querying.
• Produce monthly financial reports and conduct variance analysis to explain anomalies.
• Build reports and Tableau dashboards to summarize metrics for decision-makers.
• Apply quantitative analysis to understand customer behavior and promo impact.
• Support revenue management by modeling discount strategies and analyzing retention and LTV.
• Ensure data accuracy and implement quality control processes.
• Respond to ad hoc requests from Finance, Marketing, Distribution, Product, etc.
• Collaborate with Insights & Analytics to incorporate marketing and content data.

Conhecimentos

Independent project ownership

Data storytelling

English proficiency

SQL

Snowflake

Tableau

PowerBI

Excel

Python

Data modeling

Statistics / ML basics

Gen AI tools

Communication

Adaptability

Subscriptions data analysis

Formação académica

Bachelor's or equivalent in Mathematics, Statistics, Industrial Engineering, Data Science, Economics, Operations Research, Computer Science

Ferramentas

Snowflake

Tableau

PowerBI

Excel

Python

AWS S3

SageMaker

dbt

Airflow

Descrição da oferta de emprego

AgileEngine is an Inc. 5000 company that creates award-winning software for Fortune 500 brands and trailblazing startups across 17+ industries. We rank among the leaders in areas like application development and AI/ML, and our people-first culture has earned us multiple Best Place to Work awards.

WHY JOIN US

If you're looking for a place to grow, make an impact, and work with people who care, we'd love to meet you!

ABOUT THE ROLE

We are looking for an Analyst/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.

PERKS AND BENEFITS

• Professional growth: Accelerate your professional journey with mentorship, TechTalks, and personalized growth roadmaps.
• Competitive compensation: We match your ever-growing skills, talent, and contributions with competitive USD-based compensation and budgets for education, fitness, and team activities.
• A selection of exciting projects: Join projects with modern solutions development and top-tier clients that include Fortune 500 enterprises and leading product brands.
• Flextime: Tailor your schedule for an optimal work-life balance, by having the options of working from home and going to the office – whatever makes you the happiest and most productive.

Requirements

Experience: 4+ years of experience with independent project ownership for the Senior Analyst level. Data Storytelling & Strategic Communication: Translating complex analytical outputs into actionable C-suite insights, executive presentations, and quantifiable ROI is crucial for the role. Language: Fluent/business-level English (written and verbal) is required. Education: College degree in Mathematics, Statistics, Industrial Engineering, Data Science, Economics, Operations Research, Computer Science, or equivalent work experience Core Tech Stack: 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. Previous work experience with subscription and promotional offers data analysis is a plus. Important comment about the role: While the team builds many dashboards and reports, the main purpose of the reports is to facilitate answering business questions. The data analyst is expected to build those dashboards, but the more important responsibility is to analyze the data from those reports and provide clear answers to questions like “What caused the increase in churn rates?”, "What is driving the increase in subscriptions?", "How did Project X impact involuntary churn?"

Analyst Subscriptions and Pricing ID86906 Curitiba, PR, br