Data analytics Specialist
Posted Updated
Description
Dreamwork is seeking a Data Analyst to transform raw operational data into actionable insights that support business decisions and improve operational performance. The role emphasizes strong SQL, advanced Google Sheets, and translating business requirements into dashboards and reports.
You will collaborate with cross-functional teams, develop KPI dashboards, conduct root-cause analysis, and help drive data-driven decision-making across the organization.
Write advanced SQL queries using CTEs, window functions, and multi-table joins to extract, aggregate, and analyze large datasets. Build and maintain dynamic dashboards, forecasting models, and operational trackers using Google Sheets. Conduct root-cause analysis, identify trends, and investigate operational performance issues. Define and monitor KPIs to measure business and operational performance. Translate business requests into structured data models and actionable insights. Present analytical findings and recommendations to cross-functional stakeholders and leadership. Develop automated audit checks to ensure data accuracy, consistency, and quality. Support continuous improvement through data-driven recommendations. 2–3 years of experience in Data Analytics or BI. 2+ years hands-on experience writing advanced SQL queries. Strong SQL knowledge, including CTEs, window functions, and complex joins. Advanced Google Sheets skills, including QUERY, IMPORTRANGE, ARRAYFORMULA, XLOOKUP/VLOOKUP, and dynamic Pivot Tables. Experience with Looker Studio or Power BI. Experience with databases such as BigQuery, PostgreSQL, MySQL, or Snowflake. Excellent English communication skills; professional Arabic is strongly preferred. Bachelor’s degree in a relevant field is preferred.Skills
Sign in to read and join the discussion.