Watch Jobs
Henkel logo
汉高
Senior Reporting & Advanced Analytics Analyst
立即应聘

Senior Reporting & Advanced Analytics Analyst

发布于 1 天前

普通员工/个人贡献者

Egypt, Cairo
中级经验
全职员工
混合式弹性办公
本科
数据分析与科学
Dax
Knime
Power Bi
Sql
Star Schema
Vba

AI 估算 · 18k–30k

Based on senior analyst roles in multinational companies in Egypt, this salary range is estimated.

职位详情

关于这个职位

This role focuses on executing and leading reporting and advanced analytics for market, client, and customer data. You will drive data extraction, modeling, and visualization using tools like Power BI, Python, and SQL, while supporting team members and ensuring data quality.

最低要求

Bachelor’s degree in Business Informatics, Information Systems, or a related field.

–6 years of hands-on experience in business analysis, reporting, and data analytics.
Fluent in English (written and spoken).
Strong expertise in Power BI, including advanced DAX, Row level security, large-data modeling (Star Schema, Snowflake Schema), and performance optimization.
Strong knowledge of databases, data concepts and SQL for data transformation.
Hands-on experience or working knowledge in Python for data transformation, analysis, and automation.
Advanced proficiency in Microsoft Office, especially Excel (advanced functions, Power Query, VBA) and PowerPoint.
Strong analytical thinking, problem-solving skills, and ability to translate data into business insights.
Excellent communication and presentation skills.

工作职责

Execute and Lead market, client, and customer reporting, and perform data analysis across key business areas such as market share, brand performance, sales effectiveness, promotions, and pricing.

Perform data extraction, processing, and transformation to support reporting and analytics solutions using Excel, VBA, Power Query, KNIME, and Python, sourcing data from multiple systems while ensuring accuracy, quality, and consistency.
Design and build data models following best-practice methodologies (e.g., Star Schema, Snowflake Schema) with strong structuring, scalability, and best practice governance.
Develop, enhance, and troubleshoot sophisticated Power BI dashboards using complex DAX, advanced modeling, incremental refresh, and optimized performance for large/complex datasets.
Ensure data reliability through rigorous preprocessing, validation, and quality checks.
Drive reporting automation, process optimization, and system enhancement initiatives, ensuring continuous improvement and innovation.
Mentor and support team members by sharing technical knowledge, best practices, and analytical methodologies.
Support the team in building, optimizing, and troubleshooting Power BI reports and dashboards, including handling large and complex datasets.

优先资格

Experience with KNIME and/or Alteryx is a plus.

FMCG Background is a huge plus.

AI 洞察

优缺点分析

优点

  • Work with a global leader in consumer goods, gaining exposure to FMCG analytics.
  • Use a modern tech stack (Power BI, Python, SQL) with opportunities to innovate.
  • Flexible work model including hybrid work and work from anywhere up to 30 days per year.
  • Comprehensive benefits: health insurance, employee share plan, parental leave, and wellbeing programs.
  • Managing large and complex datasets may require advanced optimization skills.
  • Need to balance reporting automation with ad-hoc analysis requests.
  • Working across time zones if collaborating with global teams.
  • This role is ideal for an experienced data analyst who enjoys technical challenges, mentoring, and working in a dynamic FMCG environment with flexibility.

缺点 / 挑战

暂无明显挑战项

角色解读

  • Progress to senior analytics roles or management positions leading analytics teams.
  • Expand into specialized areas like data engineering or data science with deeper technical skills.
  • Leverage diverse growth opportunities within Henkel globally, including international assignments.
  • Lead reporting and analytics on market, client, and customer data across areas like market share, brand performance, and sales effectiveness.
  • Extract, process, and transform data from multiple systems using Excel, VBA, Power Query, KNIME, and Python.
  • Design and build scalable data models (Star/Snowflake Schema) and develop advanced Power BI dashboards with complex DAX.
  • Support automation initiatives and mentor junior team members on best practices.
  • Strong expertise in Power BI, DAX, and data modeling (Star/Snowflake Schema).
  • Proficiency in SQL, Python for data transformation and automation.
  • Advanced Excel skills including Power Query and VBA.
  • Analytical thinking, problem-solving, and communication skills.

申请策略

  • Tailor your resume to show impact of your analytics work on business outcomes.
  • Research Henkel's FMCG brands and prepare to discuss how analytics can drive growth.
  • Highlight hands-on Power BI experience with complex DAX, data modeling, and performance optimization.
  • Showcase Python and SQL projects involving data transformation and automation.
  • Emphasize experience in FMCG or related industries with market and sales analytics.
  • Include examples of mentoring or leading reporting projects.
  • Deepen knowledge of Power BI optimization techniques for large datasets.
  • Learn KNIME or Alteryx if not already familiar, as they are a plus.

面试指南

  • For technical questions, use the STAR method: Situation, Task, Action, Result with specific details.
  • For modeling questions, outline the business context, then discuss schema design and trade-offs.
  • For mentoring questions, focus on your approach to knowledge sharing and outcomes.
  • Can you walk us through a complex Power BI dashboard you built and how you optimized performance?
  • Describe a time you automated a reporting process. What tools did you use and what was the impact?
  • How would you design a data model for sales and promotion analysis?
  • Explain how you ensure data quality when pulling data from multiple sources.
  • Tell us about a time you mentored a colleague on a technical skill.

职位点评

74
综合评分

Flexible analytics role with modern tech, strong benefits, and global growth, but moderate industry excitement.

从薪资福利、成长空间、工作节奏和岗位方向综合评估，方便横向比较。

更适合这类人
Best for candidates seeking flexibility, modern tech stack, and global growth opportunities who are less driven by strong social mission.
表现最好
工作生活
相对薄弱
使命价值
薪资福利70
成长发展80
工作生活85
使命价值50

薪资福利

70中等

The role offers competitive compensation for the region and comprehensive benefits including health insurance, share plan, and parental leave. However, exact salary is not disclosed, and cost of living in Cairo may vary.

薪资信号未披露（AI估算：18K-30K/月）
福利待遇Flexible work scheme、Hybrid work model、Work from anywhere policy、Health and preventive care programs、Gender-neutral parental leave、Employee Share Plan、Comprehensive Health Insurance、Employee Assistance Programme

成长发展

80较高

The role uses modern technologies (Power BI, Python, SQL) and provides opportunities to mentor, automate processes, and grow internationally. Diverse growth opportunities are explicitly mentioned.

技术前沿主流现代技术
技术栈Power BI、DAX、Python、SQL、KNIME、Excel、VBA
成长机会Mentor and support team members、Diverse national and international growth opportunities
业务类型profit_center

工作生活

85较高

The hybrid work model and work from anywhere policy (up to 30 days) offer significant flexibility. Benefits include wellbeing programs and parental leave. Office location in Cairo is not specified but likely urban.

工作模式混合式弹性办公
办公地点未明确
加班情况未提及（无法判断）
工作生活平衡Flexible work scheme、Hybrid work model、Work from anywhere policy、Global wellbeing standards

使命价值

50较低

FMCG is a stable industry but not high-growth or transformative. The role contributes to business efficiency and insights, but social impact is moderate.

行业发展稳定成熟行业
社会影响中性/一般
创新程度积极采用新技术

汉高 的其他在招职位

相似职位推荐

Watch Jobs