ESG -Data Analyst/PowerBI Engineer

The Apex Group was established in Bermuda in 2003 and is now one of the world’s 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.

That’s 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 we’ll 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 of 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.
• Optimise 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 useability 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.
• Ad hoc support to consultancy team to design PowerBI reports and dashboards that will not be embedded in the tech platform.

Skills & Experience

• Bachelor’s or master's degree in a relevant field, such as Data Science or Computer Science, or equivalent work experience.
• 2-5 years of PowerBI experience preferably with research, consultancy or software development companies. Experience with PowerBI embedded in a web application is preferred but not essential.
• Strong analytical and problem-solving skills, with the ability to gather and interpret both qualitative and quantitative data to develop PowerBI models and visualizations.
• Understanding of databases, SQL and data structures.
• Ability to work with large datasets and transform unstructured data into well-organized databases and useful reporting outputs.
• Knowledge of, or interest in, sustainability, ESG, and carbon accounting preferable but not essential.
• Excellent English communication skills, both verbal and written, with the ability to articulate technical details in a clear and concise manner to internal and external stakeholders.
• Self-motivated and proactive, with the ability to work independently and adapt to changing priorities.
• Strong organizational and time management skills, with the ability to manage multiple tasks and projects simultaneously.
• Proactive and inclusive attitude to working with others across multiple teams, seniorities and geographies.