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.
- 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.