Sr. BI Analyst

1. Purpose of the Job:

About the team

Business Insights team is focused on unlocking the value of data as it exists within AkzoNobel operations / systems. We’re an eclectic team of data-oriented doers who love to take on new challenges, are always learning, and looking for ways to improve decision-making.

POSITION OVERVIEW:

The Senior BI Analyst is responsible for developing, maintaining, and leading the execution of the analytics solutions to improve performance and achieve the future vision of stakeholders. Senior BI Analyst reports into the Analytics Manager of GBS – Business Insights team

You will be partnering with various business teams to understand the analytics needs, collaborate with the IT organization to build data driven – Analytics solutions.  You will also be responsible for the end-to-end delivery of descriptive, diagnostic, predictive & prescriptive analytics solutions for stakeholders.

2. Responsibilities:

Business partnering with all the key senior leaders in the organization to determine opportunities / requirements for Data analytics solutions that can drive revenue growth, operational efficiencies, customer value etc.

Project Management: Should be able to independently manage several projects, track actions and reach out to stakeholders when needed.

Solution design & development:

Develop new solution using BI Tools (Power BI, SAP analytics Cloud)

Build wireframes, proof-of-concepts
Translate business logic to technical calculations that will help the technical team to build the metrics
Fetch and embed data from SAP HANA, BW, Azure SQL, Excel, flat files, Sharepoint list etc.
Perform data transformation, engineering, [joint, exclusion, enrichment, pivoting, etc.]  using SQL, Databricks Pyspark,
Automate process using Power Automate, Sharepoint list
Integrate & prepare multi sourced – complex data efficiently
Automate tools/ data flow using best practices in collaboration with internal teams, IM architects and IM consultants
 

Improve and maintain existing solutions:

Suggest technical improvements / automation ideas for existing Analytics solutions
Test and ensure compatibility of existing solutions upon new software version release
Improve and safeguard dashboards performance (latency, downtime)
Educate and train a variety of stakeholders about the dashboard technicalities & features
Keep detailed technical documentation complete and up to date
 

3. Challenges:

Performing numerous analyses on time in full
Working with confidence and accuracy with big numbers
Ensuring accurate translation of business needs into data models for management
Gaining knowledge and understanding of multitude of data sources and database
Combining analytical skills with broad understanding of operations and processes
Liaising and building connection with stakeholders from different background remotely
Working independently and pro-actively with a team based in multiple locations
Performing numerous analyses accurately and on time in full