Junior BI Developer

Peoplebank Hong Kong Limited; Hong Kong Island; Vor Ort; HKD 360.000 - 600.000; Vollzeit

Zusammenfassung

Peoplebank Hong Kong Limited is seeking a BI Developer to drive scalable data models, dashboards, and automated reporting pipelines across the organization.

You will design T-SQL queries and star-schema models, build Power BI dashboards with DAX and M, and manage SSRS reporting. The role also covers CI/CD for reports and RLS-based security.

Qualifikationen

• Proficiency in T-SQL, data modeling, SSRS, and Power BI development.
• Hands-on experience with Power Query (M), DAX, and workspace management.
• Exposure to PowerShell scripting, REST APIs, and deployment automation.
• Knowledge of query optimization, database performance tuning, and Row-Level Security.

Aufgaben

• Design T-SQL queries, stored procedures, and star-schema dimensional data models.
• Develop paginated reports, RDL layouts, and manage Report Server administration using SSRS.
• Build interactive Power BI dashboards utilizing DAX, Power Query (M), and deployment pipelines.
• Configure on-premises data gateways, REST API integrations, and PowerShell automation scripts.
• Implement CI/CD workflows for automated report deployment and workspace governance.
• Optimize database queries, caching performance, and Row-Level Security (RLS) policies.

Kenntnisse

T-SQL

Data modeling

SSRS

Power BI

Power Query

DAX

Workspace management

PowerShell

REST APIs

Deployment automation

Row-Level Security

English Mandarin

Tools

SSRS tools

Jobbeschreibung

You will drive business intelligence and data accessibility across the organization by developing scalable data models, dynamic analytics dashboards, and automated reporting pipelines.

Responsibilities

• Design T-SQL queries, stored procedures, and star-schema dimensional data models.


• Develop paginated reports, RDL layouts, and manage Report Server administration using SSRS.


• Build interactive Power BI dashboards utilizing DAX, Power Query (M), and deployment pipelines.


• Configure on-premises data gateways, REST API integrations, and PowerShell automation scripts.


• Implement CI/CD workflows for automated report deployment and workspace governance.


• Optimize database queries, caching performance, and Row-Level Security (RLS) policies.

Requirement

• Proficiency in T-SQL, data modeling, SSRS, and Power BI development.


• Hands-on experience with Power Query (M), DAX, and workspace management.


• Exposure to PowerShell scripting, REST APIs, and deployment automation.


• Knowledge of query optimization, database performance tuning, and Row-Level Security.


• Fluency in spoken and written English and Mandarin.


• At least 1 year of relevant working experience; open to fresh graduates with related internship experience.