Senior BI Engineer

Gebze, Kocaeli
Roof Stream – GAİN /
Full Time /
Remote
As Roof Stacks, we have been carrying out innovative projects since 2015. We aim to become a global actor in Tourism Systems, Extended Reality(AR/VR), Blockchain Technologies, Game Development, and Financial Technology, which are our areas of expertise.

We focus on creating a difference with the technologies we develop and designing the future. In addition to our central office in Gebze Bilişim Vadisi, we have branches in Antalya and Elazığ in Turkey. We have strengthened our position in the global market by opening a new office in Austin, USA, which hosts world technology giants from all over the world.

Job Purpose:
As a Senior BI Engineer at Roofstacks, you will be responsible for developing, maintaining, and optimizing business intelligence solutions to support data-driven decision-making across the organization. You will work closely with cross-functional teams to provide actionable insights into user behavior, video streaming performance, and content consumption patterns. Your work will help drive key strategic decisions to enhance user experience and optimize content delivery.

Key Responsibilities:
Design, develop, and maintain BI solutions, including data warehouses, data lakes, ETL processes, and reporting systems.
Create and manage dashboards and reports to monitor key performance indicators (KPIs) related to video streaming, user engagement, content performance, and other business metrics.
Collaborate with data scientists, data engineers, and product teams to understand business requirements and translate them into technical solutions.
Conduct in-depth data analysis to identify trends, patterns, and opportunities to improve content recommendation systems, user retention, and video streaming quality.
Optimize data models and database performance for faster query response and efficient data retrieval.
Utilize cloud platforms such as AWS for building and maintaining data pipelines and BI solutions (e.g., AWS Glue, Redshift, QuickSight).
Develop and maintain comprehensive documentation for BI solutions, including data definitions, processes, and technical specifications.
Stay updated with the latest BI technologies, data visualization tools, and industry best practices.
Mentor junior BI engineers and contribute to the overall data strategy of the organization.

Requirements:
Bachelor’s or Master’s degree in Computer Science, Data Science, Information Systems, Business Analytics, or a related field.
5+ years of experience in business intelligence, data engineering, or a related field.
Strong experience with BI tools such as Tableau, Power BI, Looker, or AWS QuickSight.
Proficiency in SQL and experience with database management systems (e.g., MySQL, PostgreSQL, Redshift).
Experience with ETL tools and processes (e.g., Apache Airflow, AWS Glue, Talend).
Familiarity with data modeling concepts and practices, including star schema and snowflake schema designs.
Experience with cloud platforms such as AWS, including services like AWS Redshift, Glue, S3, and Lambda.
Strong analytical and problem-solving skills with a focus on driving actionable insights from data.
Excellent communication skills with the ability to present complex data insights to non-technical stakeholders.
Experience with video streaming analytics and understanding of metrics such as viewer engagement, content performance, and streaming quality is a plus.