About the role

Roku is looking for a Business Intelligence Engineer (BIE) to play an instrumental role in helping Roku continue its success by providing end-to-end business intelligence solutions that democratize data across the business. You will work closely with analysts, data engineers, and business stakeholders to understand business questions, write robust pipelines to create analytical data assets, and use visualization to create informative reports and dashboards that allow stakeholders to answer questions quickly and with confidence. You will become an expert in our data infrastructure and create/maintain pipelines that are critical to conducting robust analyses. This role will partner closely with our financial planning and analysis stakeholders in identifying and building datasets critical to our Customer Acquisition Cost (CAC) optimization efforts.  The ideal candidate for this role loves building tools and reports that empower others to make high impact decisions and tell stories with data.

What you’ll be doing

• Work directly with analysts, engineers and stakeholders to understand goals, gather requirements, and develop new data assets
• Build and support robust data pipelines that are resilient to poor quality data sources for business tools and analytical needs and meet SLAs
• Conduct UAT on new tables
• Liaise with data engineers to understand and communicate the impacts of underlying changes in the data and update dependent pipelines
• Identify and fill gaps among our data assets and key metrics
• Serve as the resident expert in understanding the nuance of our data infrastructure. You will be the go-to-person when questions arise around the correct dataset, proper joins, bugs, etc.
• Create reports, dashboards, visualizations, and self-service tools that help partners monitor business trends and key metrics
• Monitor key metrics and business processes to identify trends and uncover root causes that drive business impact

We’re excited if you have

• 2 years of relevant work experience in Analytics, Business Intelligence, or Technical Operations
• Fluency in SQL, Python, and ETL using big data tools (HIVE/Presto)
• Previous experience with web frameworks for Python such as Django/Flask is a plus
• Experience writing data pipelines using Airflow preferred
• Fluency in Looker and/or Tableau
• Strong understanding of data warehousing principles, pipelines, and APIs
• Strong communication skills
• The ability to work independently and across multiple time zones
• Ownership mindset- you own the end-to-end lifecycle of a product starting from ideation to adoption and maintenance
• Bachelors or Masters in engineering, math, physics, computer science, economics or equivalent

#LI-KR3