Analytics Engineer

Office: India based (Hybrid) – Travel (Internationally) may be required therefore access to major transport hub very desirable.

Department: Technology  

Reports to:  Head of Data Analytics & BI Development

You will play a pivotal role in the development and maintenance of interactive client, investor and operational team facing dashboards using Tableau, Power BI and other visual analytics tools. You will work closely with clients and senior stakeholders to capture their BI requirements, conduct data analysis using SQL, Python (or other open-source languages), and visualise the insights in an impactful manner.

Tasks (what does the role do on a day-to-day basis)

• You’ll engage with external clients, vendors, project representatives, and internal stakeholders to gather analytics and dashboard requirements and translate them into effective BI solutions.
• You’ll maintain and enhance the existing BI database architecture, performing exploratory data analysis and defining business‑critical features to support advanced reporting and insights.
• You’ll design and deliver best‑practice data warehouse and analytics solutions using on‑premise or cloud platforms, leveraging ETL/ELT tools such as Azure Data Factory, SSIS, Python, PowerShell, Alteryx, or other open‑source technologies.
• You’ll optimise SQL Server queries, stored procedures, and views using dimensional data modelling principles to ensure efficient and reliable data retrieval.
• You’ll manage tickets and delivery updates effectively, document analytics solutions and processes, and resolve IT and data issues—including legacy system challenges—through help desk and development requests.

What we offer 

• Comprehensive remuneration: Competitive financial packages based upon market rates for your role, proportionate to your qualifications, level of experiences and skills profile 
• Pension Scheme: Generous employer contribution with the ability to increase employee contributions 
• Wellbeing: Additional social benefits such as medical insurance & life assurance, discounted gym memberships and the opportunity to engage with our local community via sports activities, charity programmes & environmental initiatives 
• Flexible working: We recognise the value of working flexibly and enable our employees to enjoy an excellent work-life blend 
• Support and development: We will ensure you have the right training, tools and development plan to grow and improve your skills every day.

• You have a degree in Data Analytics, Computer Science, or equivalent professional IT certification, with at least 5 years’ experience in a data engineering, developer, or database-focused role.
• You bring strong, hands‑on expertise in SQL Server (2016+), T‑SQL, and cloud data platforms, including Microsoft Fabric, Azure Synapse, Azure Databricks, Azure Data Factory, and cloud data stores across Azure, AWS, or GCP.
• You have proven experience designing end‑to‑end data architectures and dimensional data models, working with structured, semi‑structured, and unstructured data, and delivering batch, near‑real‑time, or low‑latency ETL/ELT solutions using tools such as Fabric, SSIS, Python, dbt, Kafka, or Airflow.
• You are proficient in analytics, BI, and visualisation, with hands‑on experience using Power BI, Tableau (and ideally QlikView, Looker, or ThoughtSpot), Python/Spark libraries, Excel (including PowerPivot), and frontend or embedding technologies such as D3, React, or Node.js.
• You communicate effectively with clients and stakeholders, demonstrate strong analytical and critical thinking, collaborate across cultures and teams, and show a results‑driven, adaptable mindset with a commitment to continuous learning and innovation in line with Group Values (Authentic, Bold, and Collaborative).

OUR COMMITMENT TO YOU AND THE ENVIRONMENT

As a forward-looking business, sustainability is integral to our strategy and operations. Our sustainability depends on us building and maintaining meaningful, long-term relationships with all our stakeholders – including our employees, clients, and local communities – while also reducing our impact on our natural environment.

There is always more we can, and should do, to improve – whether in relation to our people, our clients, our planet, or our governance. Our ongoing success as a business depends on our sustainability and agility in a changing and challenging global landscape. We’re committed to fostering an inclusive, equitable and diverse culture for our people, led by our Diversity, Equity, and Inclusion steering committee.

Our learning and development programmes and systems enable us to invest in growing our employees’ careers, while our hybrid working approach supports our employees in achieving balance and flexibility while remaining connected to their colleagues. We want to empower our 5,800+ employees - from 94 nationalities, speaking 41 languages across 25 countries - to each achieve their potential. Through IQ-EQ Launchpad we support female managers launching their first fund, in an environment where only 15% of all private equity and venture capital firms are gender balanced.

We’re committed to growing long-term relationships with our clients and supporting them in achieving their objectives. We understand that our client’s sustainability and success leads to our sustainability and success. We’re emotionally invested in our clients right from the beginning.