BI Developer: Power BI, ETL & Data Modeling

Automated Systems (HK) Ltd; Hong Kong; On-site; HKD 420,000 - 720,000; Full time

Job summary

Automated Systems (H.K.) Limited is seeking a seasoned BI Software Developer to design and implement BI solutions for reporting and analytics across business units. The role emphasizes Power BI, SSIS/SSRS/SSAS proficiency, ETL, data modeling, and close collaboration with IT and business stakeholders to translate requirements into robust BI capabilities.

The candidate will contribute to data visualization, data integrity, and performance improvements while partnering with cross-functional teams

Qualifications

• University degree in IT or related discipline with 3+ years of BI development experience.
• Proficient in Power BI, SSIS, SSRS, and SSAS; highly skilled in Excel PowerQuery and PowerPivot.
• Expertise in SQL queries, Stored Procedures, and Functions.
• Solid knowledge of Oracle PL/SQL development and performance tuning.
• Full-Stack exposure with Java, Spring Boot, and ReactJS to integrate with core applications.

Responsibilities

• BI Development: design, develop, and deploy PoCs, BI reports, and dashboards.
• ETL & Data Integration: build and maintain ETL processes using SSIS, C#, and .NET.
• Data Modeling: apply dimensional modeling for robust reporting structures.
• Collaboration: work with IT teams and stakeholders to translate requirements into BI solutions.
• Documentation: document specifications, data mappings, and system changes throughout enhancements.

Skills

Power BI

SSIS

SSRS

SSAS

Excel PowerQuery

Excel PowerPivot

SQL

Oracle PL/SQL

Java

Spring Boot

ReactJS

Data Visualization

Education

University degree in IT or related discipline

Job description

Automated Systems (H.K.) Limited is seeking a seasoned BI Software Developer to design and implement BI solutions for reporting and analytics across business units. The role emphasizes Power BI, SSIS/SSRS/SSAS proficiency, ETL, data modeling, and close collaboration with IT and business stakeholders to translate requirements into robust BI capabilities.

The candidate will contribute to data visualization, data integrity, and performance improvements while partnering with cross-functional teams