Business Intelligence Engineer - II

Job Description:

Key Responsibilities

Partner with product managers, engineers, and business stakeholders to define KPIs and success metrics for Creator Success

Create comprehensive dashboards and self-service analytics tools using Quick Sight, Tableau, or similar BI platforms

Perform deep-dive analysis on customer behaviour, content performance, and livestream engagement patterns

Design, build, and maintain robust ETL/ELT pipelines to process large volumes of streaming and batch data from Creator Success platform

Develop and optimize data warehouses, data lakes, and real-time analytics systems using AWS services (Redshift, S3, Kinesis, EMR, Glue)

Implement data quality frameworks and monitoring systems to ensure data accuracy and reliability

Build automated data validation and alerting mechanisms for critical business metrics

Generate actionable insights from complex datasets to drive product roadmap and business strategy

Required Qualifications

Bachelor's degree in Computer Science, Engineering, Mathematics, Statistics, or related quantitative field

6+ years of experience in business intelligence/analytic roles with proficiency in SQL, Python, and/or Scala

Strong experience with AWS cloud services (Redshift, S3, EMR, Glue, Lambda, Kinesis)

Expertise in building and optimizing ETL pipelines and data warehousing solutions

Proficiency with big data technologies (Spark, Hadoop) and distributed computing frameworks

Experience with business intelligence tools (QuickSight, Tableau, Looker) and data visualization best practices

Collaborative approach with cross-functional teams including product, engineering, and business teams

Customer-obsessed mindset with focus on delivering high-quality, actionable insights

Non-Negotiable Skills

High proficiency in SQL and Python

Expertise in building and optimizing ETL pipelines and data warehousing solutions

Experience with business intelligence tools (QuickSight, Tableau, Looker) and data visualization best practices

Experience in working with cross-functional teams including product, engineering, and business teams

Experience with AWS cloud services (Redshift, S3, EMR)