Job description

Location:
Mumbai
Department:
AI & Data(IBP)
Division:
IBP Digital and Technology
Employment Type:
Full time
Salary:
Competitive

Data Analyst (12730)

Investec is a distinctive Specialist Bank serving clients principally in the UK and South Africa. Our culture gives us our edge: we work hard to find colleagues who'll think out of the ordinary and we put them in environments where they'll flourish. We combine a flat structure with a focus on internal mobility. If you can bring an entrepreneurial spirit and a desire to learn and collaborate to your work, this could be the boost your career deserves.

Key Responsibilities:

We are seeking a highly analytical and technically strong Power BI Data Analyst with solid programming expertise to transform complex datasets into meaningful insights. The ideal candidate combines advanced Power BI skills with strong programming capabilities (Python, SQL, DAX, etc.) to design scalable data models, automate workflows, and deliver impactful business intelligence solutions.

This role involves working closely with various stakeholders to understand their data needs and delivering high-quality, performant reports / dashboards and visualisations.

1. Data Collection and Management:

- Gather data from various sources, ensuring accuracy and consistency.

- Support Data Engineers to maintain and manage databases, ensuring data integrity and security.

2. Data Analysis:

- Conduct exploratory data analysis to identify trends, patterns, and anomalies.

- Apply statistical techniques and models to interpret data and generate insights.

3.. Data Modelling and Transformation

- Define data‑model attributes

- Build efficient data models using best practices (star schema, relationships, measures).

Optimization of Data models and Semantic Models using tools

4. Reporting and Visualisation:

- Design, develop, and maintain interactive Power BI dashboards and reports as per persona/stakeholder requirements.

- Develop complex DAX calculations, KPIs, and time-intelligence metrics.

- Optimize report performance and implement row-level security (RLS).

- Ensure data visualizations communicate insights clearly to stakeholders.

5. Reusable scripts/ Reports/ CI/CD

- Develop Python scripts for automation, data processing, and advanced analytics.

- Integrate Power BI with external systems and APIs.

- Automate recurring reports and data refresh workflows.

- Implement version control and documentation for BI solutions.

5. Collaboration with Stakeholders:

- Work closely with business analyst to understand their data requirements and provide analytical support.

- Communicate findings and recommendations clearly to both technical and non-technical stakeholders.

6. Quality Assurance:

- Ensure the accuracy and reliability of data through validation and quality control processes.

- Identify and address data quality issues proactively.

7. Continuous Improvement:

- Stay updated on industry trends, tools, and best practices in data analysis.

- Suggest improvements to data processes and methodologies for enhanced efficiency.

- Develop and promote reuse, standards and practices via playbooks

- Collaborate with COE community to drive group analytics context within /across teams via knowledge sharing sessions

Cultivate & participate in culture focused on data quality, data governance, data security best practices

Core Skills and Knowledge-

4-8 years of Proven experience as a Data Analyst or in a similar analytical role.
Strong understanding of data warehousing, data modelling, dimensional modelling methodologies such as Kimball and BI / analytics.
Proficiency in data analysis and manipulation using SQL, stored procedures.
Proficiency in data visualization software (Power BI)
Able to build Data Models (Semantic Models) and optimize them for reporting.
Proven experience in Azure Data Platform technologies: Databricks/ Microsoft Fabric, / Microsoft Fabric, Power BI, Azure Data Lake, SQL.
Experience developing or supporting executive-level reporting or dashboards.
Strong analytical and problem-solving skills with attention to detail.
Excellent communication skills, both verbal and written, with the ability to present complex information clearly.
Knowledge of programming languages Python.
Ability to work with large, complex datasets.

Any other attributes that would be helpful, but not essential for the role.

Experience working in data mesh architecture.
Experience in Fabric Agents, Power BI to Fabric Migration.
Ability to translate business requirements into data and technical design artifacts.
Exposure to data lineage / metadata management tools (e.g., Purview)
Understanding of KPIs in financial services / capital markets (e.g., balance sheet metrics, profitability, risk indicators)
Experience with statistical analysis and forecasting.
Experience of analytics in financial services or banking.

As part of our collaborative & agile culture, our working week is 4 days in the office and one day remote.

Investec offers a range of wellbeing benefits to make our people feel healthier, balanced and more fulfilled in their lives inside and outside of work.

Embedded in our culture is a sense of belonging and inclusion. This creates an environment in which everyone is free to be themselves which helps to drive innovation, creativity and ultimately business performance. At Investec we want everyone to find it easy to be themselves, and to feel they belong. It's a responsibility we all share and is integral to our purpose and values as an organisation.

Research shows that some candidates can be reluctant to apply to a role unless they meet all the criteria. We pride ourselves on our entrepreneurial spirit here and welcome you to do the same – if the role excites you, please don't let our person specification hold you back. Get in touch!

Recite Me

We commit to ensure that everyone is fairly assessed during our recruitment process. To assist candidates in completing their application form, Recite Me assistive technology is available on our Careers pages. This can be accessed by clicking on the ‘Accessibility Options' link at the top of the page.

The Recite Me tool includes a screen reader, styling and customisation options, a series of reading aids, a translator and more.

If you have any form of disability or neurodivergent need and require further assistance in completing your application, please contact the Careers team at [email protected] who will be happy to assist.