Senior Business Applications Analyst

Full job description
Colt provides network, voice and data centre services to thousands of businesses around the world, allowing them to focus on delivering their business goals instead of the underlying infrastructure.

Job ID 34841
Job Level: S2

Job Location: Gurgaon/Bangalore

Function: Finance (CFO) –

Employment Type: Permanent

Working pattern: Hybrid
Why we need this role:
The purpose of this role is to build and own automation of financial reporting and insight processes, own and manage the best practice of Power BI and Qlik reports.

Be a subject matter expert for all things automated financial reporting with predominant focus on Power BI and Qlik.Interrogate SAP and GCP databases to join and transform data before consolidating in new tables on Microsoft SQL Server databases ready for use in Power BI reports.

What you will do:

Build and own automated financial reporting and insight processes – owning best practice Power BI and Qlik reports.
Be a subject matter expert for all things automated financial reporting with predominant focus on Power BI and Qlik
Data transformation, modelling and visualization.
Interrogate SAP and GCP databases to join and transform data before consolidating in new tables on Microsoft SQL Server databases ready for use in Power BI reports
Write stored procedures and assign to refresh packages in SSIS
Work with various departments to integrate financial data with customer, service, geographic and product level information.
Build suite of reports in Power BI and Qlik with target users ranging from individual contributors to Executive Leadership Team and above.
Query official reported financial metrics data in an ADS/SSAS environment using MDX
Liaise with senior members of staff across regional departments to standardize financial processes – foster an atmosphere of automation and financial insight.
Standardize reporting with a focus on UX to enable business teams to self-serve.