ESG -Data Analyst / PowerBI Engineer

The Apex Group was established in Bermuda in 2003 and is now one of the worlds largest fund administration and middle office solutions providers.

Our business is unique in its ability to reach globally, service locally, and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide. Your career with us should reflect your energy and passion.

Thats why, at Apex Group, we will do more than simply empower you. We will work to supercharge your unique skills and experience.

Take the lead and well give you the support you need to be at the top of your game. And we offer you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities.

For our business, for clients, and for you.

PowerBI Engineer

About Holtara

Holtara is one of the fastest growing ESG and sustainability services providers in Europe, experiencing triple digit growth over the past 36 months. Our team consists of approximately 150 people from various backgrounds across Spain, the Netherlands, UK, US, South Africa, and India all driven by the ambition to make a real impact.

What is unique about Holtara is that it includes a best-in-class ESG reporting solution, as well as a large team of ESG and sustainability experts that can guide companies and investors with their strategies.

Our ESG and sustainability reporting solution launched in 2019 is a business-to-business Software as a Service platform that allows investors and the companies they invest in to assess their ESG performance, collect key ESG indicators, calculate their carbon footprint, and define action plans to improve their ESG performance over time. The platform is particularly suited for the private equity markets, helping investors, fund managers, and their portfolio companies comply with the sustainability reporting frameworks (such as the SFDR, EDCI, TCFD, and CSRD) that are driving the industry towards a more sustainable state.

The role

We are looking for a Power BI Engineer with experience in designing, developing, and optimizing PowerBI reports and dashboards embedded in a web application. The ideal candidate will have a proven track record of creating impactful, insightful, interesting, and visually compelling dashboards. They will be able to demonstrate a portfolio of their PowerBI work as part of the application process.

The successful candidate will have the opportunity to work with the wider Product team of Holtara, designing and delivering impactful data visualizations and analysis for our global client base of hundreds of investment managers and their thousands of portfolio companies. They will work regularly with product managers, UX designers, and development squads to create, prototype, and launch PowerBI models and reports that will be embedded in our software applications and client deliverables.

Responsibilities

• Develop and maintain PowerBI dashboards, reports, and visualizations that align with our core product offering to clients, including custom dashboards.
• Develop and maintain data models within PowerBI.
• Implement DAX queries and calculations for improved model performance and functionality.
• Work with the technology team to connect the PowerBI data model to the data warehouse, ensuring security requirements are maintained.
• Optimize PowerBI performance for faster load times and data refresh processes.
• Liaise with the data and technology teams to optimize the data sources and connections.
• Propose alternative ideas where there is an opportunity to improve usability or performance of the embedded dashboards.
• Troubleshoot issues with embedded dashboards and reports.
• Document the data models, dashboards, and reports for future reference and to ensure consistency in reporting across the organization.
• Work closely with the client-facing team members to understand custom client requests, and design and develop the PowerBI dashboards for the specific client.
• Provide ad hoc support to the consultancy team to design PowerBI reports and dashboards that will not be embedded in the tech platform.

Skills & Experience

Locations - Mumbai, Turbhe MiDC Road, India