Senior BI & Analytics Engineer

Morgan Mckinley Limited; Hong Kong Island; On-site; HKD 500,000 - 800,000; Full time

Job summary

Morgan Mckinley Limited seeks a senior BI/Analytics Engineer to design, develop and maintain enterprise dashboards using Power BI and Databricks AI/BI dashboards. You will build semantic models, complex DAX, and robust data pipelines, while ensuring governance and performance.

You will configure and optimize Databricks Genie Agents, document data lineage, and work with stakeholders to translate business needs into trusted analytics products in English.

Qualifications

• Bachelor’s degree or higher in a relevant field.
• 5+ years in BI, analytics engineering, data engineering, or enterprise reporting.
• Proficiency with Power BI, DAX, Power Query, semantic modelling, and performance optimization.
• Experience with Databricks SQL and AI/BI dashboards.
• Experience managing Databricks Genie Agents/Spaces and testing
• Strong SQL skills and dimensional modelling knowledge.
• Knowledge of data governance, metadata, lineage, privacy, and production releases.
• Ability to translate complex business requirements into trusted analytics products.
• Excellent written and spoken English.

Responsibilities

• Design, develop, deploy, and support enterprise dashboards using Power BI and Databricks AI/BI dashboards.
• Build scalable Power BI semantic models, advanced DAX measures, Power Query transformations, and interactive reporting experiences.
• Create, configure, test, and improve Databricks Genie Agents for business domains.
• Develop Genie Agent instructions, definitions, synonyms, sample SQL, and benchmarks.
• Review and troubleshoot NL-to-SQL outputs for accurate filters, joins, and calculations.
• Design governed dimensional models and reusable semantic layers for reporting and analytics.
• Document KPI definitions, data lineage, calculation logic, and data ownership.
• Apply security and governance with row filters and row-level security.
• Optimize queries, models, dashboards, and datasets for performance and reliability.
• Conduct data validation, UAT, and production-readiness reviews, and post-production support.
• Partner with business and technical teams to reduce manual reporting and improve analytics adoption.
• Contribute to group-wide standards for dashboards and Genie Agent deployment.

Skills

Power BI

DAX

Power Query

Semantic modelling

SQL

Databricks SQL

Genie Agents

Data governance

Dimensional modelling

Stakeholder communication

English proficiency

Education

Bachelor’s degree in CS/IS/Data Analytics/Engineering/Math/Stats

Tools

Power BI

Databricks

SQL tooling

Job description

Design, develop, deploy, and support enterprise dashboards using Power BI and Databricks AI/BI Dashboards.

Build scalable Power BI semantic models, advanced DAX measures, Power Query transformations, and interactive reporting experiences.

Create, configure, test, and continuously improve Databricks Genie Agents for approved business domains

Develop Genie Agent instructions, business definitions, synonyms, sample SQL queries, trusted assets, and benchmark questions.

Review and troubleshoot natural‑language‑to‑SQL outputs to ensure accurate filters, joins, calculations, aggregations, and business interpretations.

Design governed dimensional models, metric definitions, and reusable semantic layers across reporting and conversational analytics.

Document KPI definitions, data lineage, calculation logic, assumptions, ownership, and refresh requirements.

Apply appropriate security and governance controls using row filters, column masks, and Power BI row‑level security.

Optimize SQL queries, semantic models, dashboards, and analytical datasets for performance, reliability, and scalability.

Conduct data validation, reconciliation, UAT, production‑readiness reviews, and post‑production support.

Partner with business and technical teams to reduce manual reporting and improve adoption of governed self‑service analytics.

Contribute to group‑wide standards for dashboard development, semantic modelling, Genie Agent configuration, testing, and deployment.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, Statistics, or a related discipline.
• Over 5 years of experience in business intelligence, analytics engineering, data engineering, or enterprise reporting.
• Advanced hands‑on experience with Power BI, including DAX, Power Query, semantic modelling, workspace administration, security, deployment, and performance optimization.
• Strong experience with Databricks SQL and AI/BI Dashboards.
• Practical experience creating or managing Databricks Genie Agents/Spaces, including instructions, semantic metadata, example SQL, testing, monitoring, and accuracy improvement.
• Expert‑level SQL skills and strong knowledge of dimensional modelling, star schemas, facts, dimensions, relationships, and data‑grain management.
• Understanding of data governance, metadata, lineage, privacy, access control, and production‑release processes.
• Experience translating complex business requirements into trusted and user‑friendly analytical products.
• Strong communication skills with the ability to explain technical concepts to business and senior stakeholders.
• Microsoft Power BI and Databricks certifications are advantageous.
• Strong written and spoken English.