Business Intelligence Developer

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:

• QlikView Dashboard Design & Development


• 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 plus


• Ability 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