PowerBI Data 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 Data 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 130 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 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 performance, collect key indicators, calculate their carbon footprint, and define action plans to improve 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 PowerBI Data 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 insightful, interesting and visually compelling dashboards, while also building and maintaining robust data pipelines and architectures. 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 and Development teams 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

• Design, develop and maintain interactive PowerBI dashboards, reports and visualisations 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 optimise 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 organisation.

• Work closely with the client facing team members to understand custom client requests, and design and develop the PowerBI dashboards for clients.

Skills & Experience

• Bachelor or Master’s degree in a relevant field, such as Data Science, Data Engineering, Information Systems or Computer Science, or equivalent work experience.

• At least 3-5 years of PowerBI experience preferably with research, consultancy or software development companies.

• Proven experience with DAX, Power Query, data modelling and visualization.

• Understanding of databases, SQL and data structures, with experience with relational databases (e.g., SQL Server, PostgreSQL).

• Experience with data warehousing and pipeline tools, knowledge of Snowflake a plus.

• Strong analytical and problem-solving skills, with the ability to gather and interpret both qualitative and quantitative data to develop PowerBI models and visualizations.

• Ability to work with large datasets and transform unstructured data into well-organized databases and useful reporting outputs.

• 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 organisational 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.

Disclaimer: Unsolicited CVs sent to Apex (Talent Acquisition Team or Hiring Managers) by recruitment agencies will not be accepted for this position. Apex operates a direct sourcing model and where agency assistance is required, the Talent Acquisition team will engage directly with our exclusive recruitment partners.