Senior Analyst

Hace 22 horas

Colombia AgileEngine Trabajo remoto Jornada completa $ 90 - $ 150 Por obra

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