Business Intellignce Analyst (Data Team) Job ID 225077 Posted 19-Jun-2025 Service line Corporate Segment Role type Full-time Areas of Interest Data & Analytics Location(s) Kuala Lumpur - Wilayah Persekutuan Kuala Lumpur - Malaysia **Summary** The Analytics & Insights team is a global function that works in collaboration with business partners to collect, model, store visualize and interpret data. The function enables business leaders to take actionable steps to improve their performance and meet goals through intuitive and insightful data visualizations. The A&I is organized across 3 pillars: + **Design** – Service Oriented point of contact to help customers achieve their reporting needs by designing visual dashboards that make it easy to get and interpret key insights. + **Data** – Facilitating consistent data solutions and definitions to provide a single source of truth for our reporting; improving and streamlining processes to reduce manual work and improve performance and efficiency with control, accuracy, and governance. + **Development** – Rapid prototyping to quickly develop Power BI reports that are consistent, easy to use, and which serve as the primary way for the organization to access standardized information and key insights. **Responsibilities** As a Business Analyst on the Data Team, you will play a crucial role in developing robust business intelligence and data analysis solutions. Your main responsibilities will include: + Performing data transformation (ETL) and data modelling development, leveraging tools like Azure Synapse Analytics and Microsoft Fabric for robust data handling. + Designing, developing, and optimizing complex SQL queries to extract, manipulate, and analyse data for reporting needs. + Ensuring the accuracy, consistency, and reliability of data across all solutions. + Identifying and resolving issues related to data quality and data pipeline performance. + Collaborating with business partners to understand their data requirements and translate them into technical specifications. + Performing high-level complexity troubleshooting for data-related issues. You will also have the opportunity to support the broader Data Team by: + Utilizing learning platforms and professional support to develop and grow your skills in data analytics and data engineering. + Learning about best practices, processes, and methodologies utilized within the A&I function for data management and governance. **Requirements** + Bachelor’s Degree in IT, Business Information, Data Analytics, Finance, Computer Science, Technology, or other relevant fields. + Minimum 1-year experience developing dashboard using Power BI. + Proven experience in handling and processing large datasets using Azure Synapse Analytics or any database/data warehouse tools. + Strong proficiency in SQL, including writing complex queries, stored procedures, and optimizing database performance. + Experience with Microsoft Fabric is highly desired. + Prior experience or exposure to any data preparation applications will be considered. + A team player with high adaptability to changes and a strong problem-solving aptitude. CBRE, Inc. is an Equal Opportunity and Affirmative Action Employer (Women/Minorities/Persons with Disabilities/US Veterans)