The Role
Build Snowflake tables, Tableau dashboards, and financial reports supporting subscription and promotional offer decisions. Conduct variance, quantitative, retention, lifetime value, and discount-strategy analyses; monitor data quality and resolve anomalies. Provide insights on customer behavior and respond to ad hoc requests from Finance, Marketing, Product, and other stakeholders. Collaborate with analytics teams to integrate marketing and content data into a holistic customer view.
Summary Generated by Built In
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 a 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 insights for Finance, Marketing, and Product teams. SQL, Python, and strong analytical judgment are central here.
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.
- 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, 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 escalate.
- Must maintain substantial overlap with US Eastern Time hours (roughly 10 AM – 4 PM eastern time).
NICE TO HAVES
- Previous work experience with subscription and promotional offers data analysis is a plus.
- Specialized experience with AWS/S3, SageMaker, R, Airflow, and dbt.
PERKS AND BENEFITS
- 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
Skills Required
- 4+ years of experience with independent project ownership
- Fluent or business-level English, written and verbal
- College degree in Mathematics, Statistics, Industrial Engineering, Data Science, Economics, Operations Research, Computer Science, or equivalent work experience
- Daily proficiency in SQL, Snowflake, Tableau, Excel, and Python
- SQL proficiency, including CTEs, window functions, and date and time functions
- Tableau proficiency for building and maintaining dashboards
- Familiarity with database models, raw columnar data transformation, and loading large datasets
- Basic knowledge of statistics and/or machine learning
- Familiarity with generative AI tools, prompt engineering, and data security and accuracy risks
- Strong communication skills for explaining business implications of data analysis and visualizations
- Ability to work independently in a small, fast-paced environment and exercise sound judgment
- Availability for substantial overlap with US Eastern Time hours, approximately 10 AM to 4 PM Eastern
- Experience analyzing subscription and promotional offers data
- Experience with AWS, S3, SageMaker, R, Airflow, and dbt
Similar Jobs
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
AgileEngine is a privately held company established in 2010 that builds dedicated teams of designers and developers. We turn good ideas into awesome software that people actually want to use. Some of the biggest names and the hottest startups around the world chose us to build their tech.
