Data & Analytics BI Developer

Responsibilities:

• Engage with external clients, vendors, project reps, internal stakeholders from operations as well as client services teams to understand their analytics and dashboard requirements
• Maintain and enhance existing database architecture of the BI solution
• Conduct in-depth exploratory data analysis and define business critical features
• Work with key teams within Group Technology to get appropriate access and infrastructure setup to develop advanced visualisations (BI dashboards)
• Optimize SQL server queries, stored procedures, views to efficiently and effectively retrieve data from databases, employing the fundamentals of dimensional data modelling
• Ensure updates to tickets and work in progress are well communicated and escalations regarding the delivery being provided is kept to a minimum
• Maintain and enhance existing data solutions. Maintain best-practice data warehouse solutions that support business analytics needs. This is achieved using on-prem or cloud databases and different ETL / ELT programs and software, such as Azure Data Factory, SSIS, Python, PowerShell, Alteryx or other open source technology
• Create, maintain and document the different analytics solution processes created per project worked on
• Resolve IT and data issues. When database issues arise or development requests come in through the help desk, BI Developers work to resolve these problems. This requires an understanding of legacy solutions and issues.

Skills:

• Analytical Reasoning – Ability to identify patterns within a group of facts or rules and use those patterns to determine outcomes about what could / must be true and come to logical conclusions
• Critical Thinking – Ability to conceptualise, analyse, synthesise, evaluate and apply information to reach an answer or conclusion
• Conceptual Thinking and Creative Problem Solving - Original thinker that has the ability to go beyond traditional approaches with the resourcefulness to adapt to new / difficult situations and devise ways to overcome obstacles in a persistent manner that does not give up easily
• Interpersonal Savvy – Relating comfortably with people across all levels, functions, cultures & geographies, building rapport in an open, friendly & accepting way
• Effective Communication – Adjusting communication style to fit the audience & message, whilst providing timely information to help others across the organisation. Encourages the open expression of diverse ideas and opinions
• Results / Action Orientated and Determination – Readily taking action on challenges without unnecessary planning and identifies new opportunities, taking ownership of them with a focus on getting the problem solved

Benefits:

• 💼 Facilitate open and frank debate to drive forward improvement
• 💡 Willingness to learn, develop, and keep abreast of technological developments
• 🔍 An analytical mind, excellent problem-solving & diagnostic skills, attention to detail

Qualifications:

• Degree level education is preferred but equivalent professional experience in IT is acceptable.

Company Description:

ABOUT IQ-EQ

We’re a leading Investor Services group offering end-to-end services in administration, accounting, reporting, regulatory and compliance needs of the investment sector worldwide. 

We employ a global workforce of 5,500+ people across 25 jurisdictions and have assets under administration (AUA) exceeding US$750 billion. We work with 13 of the world’s top 15 private equity firms.

Our services are underpinned by a Group-wide commitment to ESG and best-in-class technology including a global data platform and innovative proprietary tools supported by in-house experts.

Above all, what makes us different is our people. Operating as trusted partners to our clients, we deliver intelligent solutions through a combination of technical expertise and strong relationships based on deep client understanding. 

We’re driven by our Group purpose, to power people and possibilities.

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 (including PowerU and MyCampus) 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,500+ employees - from 94 nationalities, speaking 41 languages across 25 countries - to each achieve their potential. Through IQ-EQ Launchpad we support women 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.