Title:  *Senior Executive, BI & Data Analytics Engineer

About The Role

Build and operate an end-to-end BI architecture—from data ingestion and orchestration to data warehousing, Power BI analytics, and automation/monitoring—to deliver trusted, consistent KPIs for the business.

What You Will Deliver

Key responsibilities

• Ingestion & Orchestration (Python, Dagster): Develop automated ingestion pipelines (e.g., via SharePoint APIs), implement scheduling/orchestration, and manage dependencies, retries, and logging for stable daily runs.
• Data Warehousing (SQL Server): Design and maintain a centralized, normalized warehouse; standardize data definitions and naming conventions; optimize reporting performance via indexing and query tuning.
• Business Intelligence (Power BI): Build analytic data models (relational/star schema), develop KPI dashboards, and ensure metric consistency across reports (single source of truth).
• Automation & Monitoring (Power Automate): Automate health checks and alerts for SQL jobs and Dagster runs; enable proactive incident handling to reduce downtime.

What You Bring

Required tech stack (must be proficient)

• Python
• Dagster
• SQL Server (Management and Analysis)
• Power BI (data modeling, measures/KPIs, DAX)
• Power Automate (workflow automation, monitoring/alerts, RPA)

Technical skills

• Strong SQL & database foundations
• Data warehousing
• Data governance & architecture
• Programming
• Data visualization tools

Analytical skills

• Work efficiently with large datasets
• Critical thinking and structured problem solving

Communication skills

• Collaborate effectively with cross-functional teams
• Translate technical outputs into clear business insights

Industry-specific knowledge

• KPIs, metrics, and reporting requirements in FMCG (or similar fast-paced commercial environments)

Business thinking

• Understand business processes and decision needs
• Troubleshoot, optimize, and continuously enhance data systems

Soft skills

• Prioritization and basic project management
• High attention to detail and accuracy
• Continuous learning mindset

Why Join DKSH

 #LI-DT1