Data Engineer / Analytics Engineer (Databricks & Power BI)

Ambition; Hong Kong; On-site; HKD 600,000 - 1,200,000; Full time

Job summary

Ambition is seeking a hands-on Data Engineer / Analytics Engineer to join a regional data and analytics team supporting enterprise reporting, BI and data platform initiatives in Hong Kong. The role spans both data engineering and reporting layers, building scalable pipelines with Databricks and delivering Power BI dashboards and semantic models for business users.

Candidates should have 5+ years of experience, strong SQL, experience with Databricks, DAX, Power Query, and the ability to translate

Qualifications

• 5+ years of experience in Data Engineering or Analytics Engineering.
• Hands-on Databricks expertise.
• Strong SQL development and data warehousing knowledge.
• Experience building ETL/ELT pipelines.
• Ability to engage with business stakeholders to gather reporting requirements.
• Power BI, DAX and Power Query experience.

Responsibilities

• Design, develop and maintain scalable ETL/ELT pipelines.
• Build and improve reporting datasets within Databricks.
• Develop Power BI dashboards, semantic models and reporting solutions.
• Create and maintain data models, transformation logic and reporting structures.
• Troubleshoot data pipelines, reporting and performance issues across multiple data sources.
• Partner with business stakeholders to gather requirements and translate reporting needs into technical solutions.
• Support enterprise reporting, analytics and data platform modernisation initiatives.
• Ensure data quality, consistency and reliability across reporting and analytics solutions.
• Document data pipelines, business logic and reporting processes to support governance and operational excellence.

Skills

Databricks

Advanced SQL

Power BI

DAX

Power Query

ETL/ELT pipelines

Data warehousing

Dimensional modelling

Python

PySpark

Databricks SQL

Tools

Databricks

Delta Lake

Power BI

Job description

We are looking for a hands-on Data Engineer / Analytics Engineer to join a regional data and analytics team supporting enterprise reporting, business intelligence and data platform initiatives.

This position sits across both the data engineering and reporting layers, making it ideal for candidates who enjoy building scalable data pipelines while also enabling high-quality reporting and analytics solutions for business stakeholders.

The successful candidate will work with modern cloud-based data platforms and play a key role in developing enterprise reporting datasets, maintaining data pipelines and supporting business-critical analytics initiatives.

Key Responsibilities

• Design, develop and maintain scalable ETL/ELT pipelines and data processing workflows.
• Build and improve reporting datasets within Databricks environments.
• Develop Power BI dashboards, semantic models and reporting solutions.
• Create and maintain robust data models, transformation logic and reporting structures.
• Troubleshoot data pipeline, reporting and performance issues across multiple data sources.
• Partner with business stakeholders to gather requirements and translate reporting needs into technical solutions.
• Support enterprise reporting, analytics and data platform modernisation initiatives.
• Ensure data quality, consistency and reliability across reporting and analytics solutions.
• Document data pipelines, business logic and reporting processes to support governance and operational excellence.

Required Skills

• 5+ years of experience in Data Engineering, Analytics Engineering, BI Development or related disciplines.
• Strong hands-on experience with Databricks.
• DAX
• Power Query
• Advanced SQL development skills.
• Experience developing and supporting ETL/ELT pipelines.
• Strong understanding of data warehousing and dimensional modelling concepts.
• Experience working with large enterprise datasets.
• Ability to engage directly with business stakeholders and gather reporting requirements.
• Strong communication skills and ability to work independently.

Preferred Skills

• Python and/or PySpark development experience.
• Experience with Databricks SQL, Delta Lake or modern lakehouse concepts.
• Data quality, validation and data-governance experience.
• Experience supporting reporting and analytics initiatives within enterprise environments.
• Exposure to multinational or regional business environments.

Why Join

• Opportunity to work on an MNC's enterprise analytics and reporting initiatives.
• Exposure to modern cloud-based data platforms and analytics technologies.
• High visibility across multiple business functions and stakeholders.
• Opportunity to work across both the engineering and reporting layers rather than being confined to a single technical discipline.
• Regional role with strong stakeholder engagement and ownership opportunities.