Business Intelligence Developer

Gen II Fund Services, LLC.; Southampton; Hybrid; GBP 45,000 - 65,000; Full time

Job summary

Gen II Southampton is seeking a PEX Report Developer to partner with fund accounting professionals and technology groups to build, maintain, and enhance customized reporting statements.

The role requires at least 2 years of hands-on QlikView experience (v11+), strong SQL and dimensional modeling skills, and the ability to integrate data from multiple sources into robust data models. You will collaborate with stakeholders to deliver powerful dashboards and reporting solutions.

Qualifications

• Bachelor’s degree in Computer Science with relevant BI tooling experience.
• Experience across the QlikView lifecycle including data sourcing and dashboard design.
• Experience with complex QlikView functions and data security concepts.

Responsibilities

• Build, maintain and complete customized reporting statements using QlikView and NPrinting.
• Collaborate with stakeholders to translate business requirements into system specs.
• Develop prototypes and conduct Proof of Concepts with business leads.
• Analyze key metrics and answer ad-hoc questions.
• Install, configure and maintain QlikView-based environments (QlikView, QlikSense, Publisher, NPrinting).
• Define data sources and architect data structures for standardized access.

Skills

SQL queries

Dimensional Modeling

Data analysis

Stakeholder communication

Education

Bachelor’s degree in Computer Science

Tools

QlikView

QlikSense

NPrinting

SQL Server

Job description

Gen II (UK) Southampton
Southampton, WHIT PO157AD, GBR

The PEX Report Developer will be responsible for working with fund accounting professionals and technology organizations to build, maintain and complete customized reporting statements.

The position requires at least 2 years of experience using QlikView version 11 or higher with proven experience in the following areas:

• Good knowledge of SQL, relational databases, and Dimensional Modeling
• Working with large data sets & Experience with complex data models involving more than 10 tables
• Integrating data from multiple data sources into a QlikView Data Model, Social Media content, API extensions, etc.
• Use of complex QlikView functions and developing most optimal scripts for a given solution
• Optimization of Dimensional data model for performance

Primary responsibilities will include:

• The successful candidate will be using technologies such as QlikView and NPrinting to create and provide the business areas with new reporting and dashboard applications, to enable better decision making
• Responsible for working with stakeholders, business users and technical teams to identify use cases; organize requirement gathering sessions with stakeholders, capture and translate business requirements into system & functional requirements
• Collaborate with business leads to create prototypes and conduct Proof of Concepts
• Develop and conduct analysis on key business metrics and answer on-going ad-hoc questions
• Responsible for installing, configuring & maintaining the QlikView environment (QlikView, QlikSense, Publisher, NPrinting)
• Create and maintain complex QlikView applications. Use advanced functions as needed (I.e. - set analysis, section access, alternate states, loop and reduce, etc.)
• Define and extract data from a variety of data sources (SQL Server, Oracle, Excel Files, Hive, etc.). Architect data structures and processes to standardize, distribute and provide access to information to all users in the organization
• Work with the Business Intelligence Architect, IT Operations, and Information Security on designing and implementing the appropriate security model
• Mentor and train other Data Services team members and power users on best practices on - QVD generation, Publishing, developing QlikView applications. Additionally define best practices for data visualization and NPrinting reports
• Implement procedures around migration, scheduling and distribution of applications
• Help design support procedures and train IT support on best practices; provide Level 3 end-user support for all QlikView related issue
• Follows the SDLC methodology

Job requirements, skills, education and experience:

• Bachelor’s degree in Computer Science
• Extensive experience across all stages of the QlikView lifecycle (sourcing data, QVD generation, dashboard design)
• Experience with complex QlikView functions set analysis, alternate states, advanced scripting, etc.
• Experience with section access and implementing data level security
• Distributed QlikView applications and reports using Publisher and NPrinting
• Knowledge of QlikView distributed architecture and experience with administering and governing QlikView environments
• Knowledge of SDLC and familiarity with Agile software development concepts
• Prior experience with process improvement a plusAbility to own initiatives and work in a matrix-based organization
• Excellent interpersonal, oral, and written communication skills
• Superior analytical and problem-solving skills

About the Company:

Gen II Fund Services, LLC is one of the largest global independent private equity fund administrators, administering over $900 billion of private capital on behalf of its clients with offices in New York, San Francisco, Boston, Stamford, Dallas, Denver, Vancouver, and Luxembourg. Gen II offers private fund sponsors a best-in-class combination of people, process, and technology, enabling fund sponsors to most effectively manage their operational infrastructure, financial reporting, and investor communications. The Gen II team is the most experienced and longest tenured team in the private equity fund administration industry, with broad expertise across buyout, funds of funds, real estate, energy, infrastructure, credit, co-investment, hybrid funds, feeder funds, venture capital, retail, and managed accounts.

Key Facts:

• Administering over $900B in assets
• Servicing nearly every significant investor in the asset class
• Institutional grade infrastructure and SSAE 18 (SOC-1, Type 2) certification, ensuring confidence in our processes and operating model
• The most experienced and best performing team in the industry