Manager, Data Visualisation (Power BI)

Manager, Data Visualisation (Power BI)

Job Description:

This role will be a part of Performance Reporting & Analytics team based in Bengaluru. The role involves collaborating with Finance Business Partners across LSEG Group’s Divisions and Functions to prepare and deliver insightful analysis to support and drive decision making.

This role would be responsible to deliver strong progress in development, upkeep and maintenance of Dashboards that would be critical for business performance management, review and analysis. The successful candidate should have the ability to work in a dynamic, fast paced environment, ability to provide valuable insight and a focus on continuous improvement.

Job Roles & Responsibilities:

• Designing and developing high quality interactive dashboards and scorecards in Power BI fully leveraging for use by Senior Leadership Teams in the organisation.
• Writing Complex SQL queries and custom views.
• Developing ETL queries with M language in Power Query to cleanse and transform unstructured data or flat files.
• Building data models in Power BI based on Star Schema or snowflake.
• Connecting and mashup of different sources like SQL, Excels, CSV's, API's, Online sources, etc (On-Premises/Cloud) and building an efficient data model to feed data into the Power BI Dashboards.
• Streamlining processes end to end and automating data flows that facilitate ‘straight through’ processing and refresh of Dashboards with minimal to no manual intervention.
• On going maintenance and upkeep of Dashboards (in production) to incorporate changes in hierarchy, metrics, organisation alignments, etc.
• Developing reports with Static/Dynamic RLS with complex scenarios.
• Responsible for access management of users for various Dashboards in production.
• Building advanced DAX functions/calculations on the data set.
• Monitor Dashboard performance, usage and share usage statistics.
• Building Power Automate cloud flows
• Developing simple apps through Power app.

Required Skills & Experience:

• 9+ years of experience in Dashboarding / Data visualisation roles with specific exposure in Microsoft Power BI for 7+ years and with knowledge of any other data visualisation tools like Tableau/QlikView/Looker.
• Strong knowledge of Power BI - Power Query, data modelling, DAX and visualisations (Default/Custom).
• Good knowledge in ETL and any workflow tool like Alteryx, ADF, SSIS, etc.
• Strong on data modelling, database & data warehousing concepts
• Strong in SQL (SQL server/ Oracle/Snowflake)
• Solid understanding of different data sources (OnPrem/Cloud) for mashup or data models development.
• Working knowledge on Power BI report builder/SSRS for paginated reports.
• Strong Power BI dataflows/Datamart working knowledge with variety of data sources.
• Good understanding of Power BI licensing, Power BI service, Gateway connection creations.
• Knowledge of power automate/power apps/UI path.
• Integration of Power automate/Power app in Power BI dashboard.
• Strong knowledge of Microsoft Excel.
• Experience in seamlessly integrating end-end flow "Power BI- Microsoft forms-Power Automate-Power App"
• Good interpersonal skills and ability to understand requirements clearly and deliver within agreed timelines.
• Ability to collaborate effectively with diverse teams and across various business functions, including both finance and non-finance teams.

Preferred Skills:

• Microsoft certification in Power BI/Fabric/Power platform.
• Understanding of Finance domain/Financial concepts.
• Experience in training users on different tools.
• Knowledge of Python/R for data analytics.
• Experience in leading a team.

LSEG is a leading global financial markets infrastructure and data provider. Our purpose is driving financial stability, empowering economies and enabling customers to create sustainable growth.

Our purpose is the foundation on which our culture is built. Our values of Integrity, Partnership, Excellence and Change underpin our purpose and set the standard for everything we do, every day. They go to the heart of who we are and guide our decision making and everyday actions.

Working with us means that you will be part of a dynamic organisation of 25,000 people across 65 countries. However, we will value your individuality and enable you to bring your true self to work so you can help enrich our diverse workforce. You will be part of a collaborative and creative culture where we encourage new ideas and are committed to sustainability across our global business. You will experience the critical role we have in helping to re-engineer the financial ecosystem to support and drive sustainable economic growth. Together, we are aiming to achieve this growth by accelerating the just transition to net zero, enabling growth of the green economy and creating inclusive economic opportunity.

LSEG offers a range of tailored benefits and support, including healthcare, retirement planning, paid volunteering days and wellbeing initiatives.

We are proud to be an equal opportunities employer. This means that we do not discriminate on the basis of anyone’s race, religion, colour, national origin, gender, sexual orientation, gender identity, gender expression, age, marital status, veteran status, pregnancy or disability, or any other basis protected under applicable law. Conforming with applicable law, we can reasonably accommodate applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs.

Please take a moment to read this privacy notice carefully, as it describes what personal information London Stock Exchange Group (LSEG) (we) may hold about you, what it’s used for, and how it’s obtained, your rights and how to contact us as a data subject.

If you are submitting as a Recruitment Agency Partner, it is essential and your responsibility to ensure that candidates applying to LSEG are aware of this privacy notice.