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 & DevelopmentGood knowledge of SQL, relational databases, and Dimensional ModelingWorking with large data sets & Experience with complex data models involving more than 10 tablesIntegrating 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 solutionOptimization 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 makingResponsible 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 requirementsCollaborate with business leads to create prototypes and conduct Proof of ConceptsDevelop and conduct analysis on key business metrics and answer on-going ad-hoc questionsResponsible 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 organizationWork with the Business Intelligence Architect, IT Operations, and Information Security on designing and implementing the appropriate security modelMentor 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 reportsImplement procedures around migration, scheduling and distribution of applicationsHelp design support procedures and train IT support on best practices; provide Level 3 end-user support for all QlikView related issueFollows the SDLC methodology Job requirements, skills, education and experience: Bachelor’s degree in Computer ScienceExtensive 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 securityDistributed QlikView applications and reports using Publisher and NPrintingKnowledge of QlikView distributed architecture and experience with administering and governing QlikView environmentsKnowledge of SDLC and familiarity with Agile software development conceptsPrior experience with process improvement a plusAbility to own initiatives and work in a matrix-based organizationExcellent interpersonal, oral, and written communication skillsSuperior analytical and problem-solving skillsAbout 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 assetsServicing nearly every significant investor in the asset classInstitutional grade infrastructure and SSAE 18 (SOC-1, Type 2) certification, ensuring confidence in our processes and operating modelThe most experienced and best performing team in the industry