Senior Business Intelligence Engineer

About the team

When you join our Core Analytics Team, you will be part of a centralized analytics team, with all the benefits that entails: a world class peer group to support you, centrally maintained tools, career growth, and more.

About the role

Roku is looking for a Senior Business Intelligence Engineer (Sr. 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. 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 will be doing

• Work directly with analysts and engineers to understand goals, gather requirements, and guide development of new data assets by producing robust feature guides
• Build and support robust data pipelines to support 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 for the analytics team. 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

• 4+ years of relevant work experience in Analytics, Business Intelligence, or Technical Operations
• Master in SQL, Python, and ETL using big data tools (HIVE/Presto, Redshift)
• Previous experience with web frameworks for Python such as Django /Flask is a plus
• Experience writing data pipelines using Airflow
• 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 math, physics, computer science, economics or equivalent

• Technical Assessment (Python and SQL)
• Hiring Manager Interview
• Panel Interview (Peer, Stakeholders etc.)