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.
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.
Intelligence Manager • Singapore