Job Purpose
The BI Manager will be responsible for interpreting and analysing results as well as the delivery of a new high profile Microsoft Power BI solution, and develop the data processes, reporting, dashboards and data visualisations to meet the data analysis requirements of the business. Thereafter, be responsible for the continual improvement and administration of the Power BI system and related data infrastructure.
The successful candidate will be the BI champion - well versed in effectively promoting the benefits of BI across the business to deliver a mind-set change. This role requires ongoing engagement with directors, department heads, key managers and stakeholders, as well as managing relationships with external trusted partners involved in delivering a Business Intelligence solution with high data quality to align with business strategic objective.
This is a key role which involves determining project needs and resources to deliver the technical and functional requirements for the plan, as well as ensuring budget and deadline expectations are met and resources managed efficiently.
Summary of Main Duties and Responsibilities:
Data Analysis
- Interpret data, analyse results using statistical techniques and provide ongoing reports.
- Develop and implement databases, data collection systems, data analytics and other strategies that optimise statistical efficiency and quality.
- Acquire data from primary or secondary data sources and maintain databases/data systems.
- Identify, analyse, and interpret trends or patterns in complex data sets.
- Filter and clean data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
- Work with management to prioritise business and information needs.
- Locate and define new process improvement opportunities.
Project Implementation
- Assist in the development and management of Power BI implementations, objectives, project scope, business objectives, with an overarching focus on customer experience.
- Utilisation of previous hands-on experience with Power BI projects, facilitating workshops to challenge current business thinking ensuring BI is implemented with the best-in-class processes and approaches.
- Determine project needs and business resources required to execute the BI project successfully.
- Develop data governance to manage data sources, data processing and data quality.
- Work as partner with business owners to understand business requirements and data requirements, and using the Power BI tool to deliver BI reporting, dashboards, data visualisation etc.
- Define the data and reporting specifications. Manage and control related documents for Power BI system standardisation.
- Develop and manage the data warehouse, ETL (Extract, Transform, Load), and data schedule which are hosted in Azure PaaS and data centres.
- Support SQL server Database running, manage the database log, performance and efficiency.
- Troubleshoot data and report issues and provide the resolution to support the business to get accurate data and report results.
- Work closely with the Group BI team (UK) and the APAC regional BI team and roll out the Group standard Power BI solution to meet local business demands.
- Work with vendors and third-party data providers to ensure seamless integration of external data into internal systems, maintaining data quality, consistency, and licensing compliance.
Training, Collaboration & Change Management
- Develop the internal Power BI course and training materials. Regularly provide high quality training for business owners, key users, and end users in the region.
- Budget, supplier and stakeholder management.
- Identification and communication of risks and mitigating actions and conducting readiness assessments.
- Regular communication of project progress to sponsor, project teams and the leadership group.
- Collaborate with Group and external suppliers to build/manage relationships.
- Act as an agent of change - drive and coach behaviour change in our businesses to maximise value and adoption of the systems.
- Can identify and design localisations, workarounds, and enhancements required to meet customer needs.
- Serves as an internal subject matter expert and supports all company activities including but not limited to BI system implementations, integrations, and process consultations.
- Power BI tenant administration
- Work with 13 countries across various APAC time zones, as well as UK teams.
Required Skills
- Degree in a related field and 5-8 years of experience in Microsoft Power BI, SQL server database (include SSRS and SSIS), Microsoft Azure Cloud and Python.
- Proven working experience as a Data Analyst or Business Data Analyst.
- Deep experience in Power BI with in-depth SQL coding experience with recent versions of SQL server.
- Experienced in the successful implementation of end-to-end Power BI, data warehouse and ETL, including integration with JD Edwards & Dynamics 365 ERP, CRM and other business systems.
- Understand the data warehouse, data mart and data model.
- Knowledge in developing automated reports, dashboards, and data visualisation using Power BI.
- Connect to multiple datasets to bring all the relevant data together in one place and create reports that provide a consolidated view of the different sources.
- Understand master data management for data consolidation and standardisation for different data sources.
- Gather and understand business requirements to set functional specification for reporting applications.
- Understanding of multi-channel data, including the impact of integrating third party data (experience working with external data insight agencies advantageous).
- Hands on professional with thorough knowledge of scripting, data source integration and advanced GUI development in Power BI.
- Strong aesthetics for designing reports, dashboards and data visualisation that are easy to use and that provide actionable insights. Be an expert in UI/UX for Power BI.
- Strong BI modelling skills using analysis services with the ability translate reporting needs to a BI model personnel, providing in-depth knowledge of BI information delivery/presentation methodology.
- Proven communication and interpersonal skills, with the ability to quickly build relationships and manage the interrelationship between projects and stakeholders (written, verbal, listening, and reasoning).
- Experience creating calculated measures and columns with DAX (Data Analysis Expressions) in Power BI desktop.
- Expert knowledge using advanced calculations using Power BI desktop (aggregate, date, logical, string, table, etc.)
- Proven experience with Microsoft Power Platform (Power Automate and Power Apps)
- Strong understanding of workflow design, process automation and system integration.
- Experience with RPA tools (Example UiPath, Blue Prism) is a plus.
- Capable of troubleshooting data and database issues.
- Skilled in training and knowledge transfer
- Knowledge of cross border data transfer patterns, taking into consideration APAC data privacy (SG PDPA), CN PIPL, KR PIPA).
- Knowledge of Internal security Practices & standards when handling sensitive business data and managing Power BI tenant settings.
- Regional travelling expected (approx. 10%) within APAC.
Technical skills
- Microsoft Power BI, Power Automate, SQL server 2012 to 2019 (including SSIS and SSRS), Azure Cloud.
- Technical expertise regarding data models, database design development, data mining and segmentation techniques.
- Strong knowledge of and experience with reporting packages (Business Objects etc.), databases (SQL etc.), programming (XML, JavaScript, or ETL frameworks).
- Knowledge of statistics and experience using statistical packages for analysing datasets (Excel, SPSS, SAS etc.).
- Strong analytical skills with the ability to collect, organise, analyse, and disseminate significant amounts of information with attention to detail and accuracy.
- Skilled in writing queries and reports and presenting findings.
