Gen II Fund Services
Database Developer
Gen II Fund Services, New York, New York, us, 10261
We have an exciting opportunity for a Database Developer who will be responsible for all aspects of data flow and data structure for the application, including the data transfer from the core general ledger platform all the way through to the end product. In addition, this individual will be responsible for data input through an ETL tool to intake data from sources other than the core general ledger.
Primary Responsibilities Will Include:
Develop and maintain various ETL and data quality processes.Own the multiple staging and transfer databases in the Data flow path.Build Database programming and stored procedures code and validate the code written by developers.Define/manage the data structure and security.Monitor for outages or system issues.Manage and monitor ETL Jobs and work closely with the support teams in resolving any Job failures.Work closely with the operational teams in resolving any data quality discrepancies.Job Requirements, Skills, Education and Experience:
Bachelor’s degree in computer science or IT5-7 years hands-on experience with MS SQL Server (2012 and above) relational database development. Must be fluent with manipulation of data, ETL concepts and query optimization.5+ years’ hands-on experience with Microsoft SSIS ETL tool (2012 and above) with clear understanding on newer methods of deployments.Azure SQL Server, Azure Data Factory, (ADF) and relevant cloud experience is a plus.Knowledge of other PERE administration platform/accounting software/BI is an asset.Highly skilled on data extraction, manipulation, and report formatting (ETL).Knowledge of Qlik and Snowflake an advantage.FinTech experience a plus.Fluent in written and spoken English.Excellent interpersonal and communication skills, including contributing to and being part of a strong team spirit.Ability to work autonomously, taking full ownership of assigned responsibilities with a commitment to delivering quality work.Excellent organizational skills complemented by a “can do” attitude.Ability to meet tight deadlines and to work under pressure in a new and fast-paced environment.Strong attention to detail with ability to understand and create technical documentation.The salary range for this position is $130,000 - $155,000, in addition to a discretionary bonus and comprehensive benefits package. Please note that the actual salary offer within that range will depend on the candidate’s experience level.
Work Arrangement
All applicants applying to Gen II Fund Services, LLC must be legally authorized to work in the United States. Please note that all US employees are required to work a hybrid schedule. This position will work a hybrid work schedule comprised of a minimum of three (3) days a week in our office and two (2) days remote.
About the Company
Gen II Fund Services, LLC is one of the largest global independent private equity fund administrators, administering over $1T of private capital on behalf of its clients with offices in New York, San Francisco, Boston, Stamford, Dallas, Denver, Florida, 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 $1T 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.
https://gen2fund.com/candidate-privacy-statement/
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
Primary Responsibilities Will Include:
Develop and maintain various ETL and data quality processes.Own the multiple staging and transfer databases in the Data flow path.Build Database programming and stored procedures code and validate the code written by developers.Define/manage the data structure and security.Monitor for outages or system issues.Manage and monitor ETL Jobs and work closely with the support teams in resolving any Job failures.Work closely with the operational teams in resolving any data quality discrepancies.Job Requirements, Skills, Education and Experience:
Bachelor’s degree in computer science or IT5-7 years hands-on experience with MS SQL Server (2012 and above) relational database development. Must be fluent with manipulation of data, ETL concepts and query optimization.5+ years’ hands-on experience with Microsoft SSIS ETL tool (2012 and above) with clear understanding on newer methods of deployments.Azure SQL Server, Azure Data Factory, (ADF) and relevant cloud experience is a plus.Knowledge of other PERE administration platform/accounting software/BI is an asset.Highly skilled on data extraction, manipulation, and report formatting (ETL).Knowledge of Qlik and Snowflake an advantage.FinTech experience a plus.Fluent in written and spoken English.Excellent interpersonal and communication skills, including contributing to and being part of a strong team spirit.Ability to work autonomously, taking full ownership of assigned responsibilities with a commitment to delivering quality work.Excellent organizational skills complemented by a “can do” attitude.Ability to meet tight deadlines and to work under pressure in a new and fast-paced environment.Strong attention to detail with ability to understand and create technical documentation.The salary range for this position is $130,000 - $155,000, in addition to a discretionary bonus and comprehensive benefits package. Please note that the actual salary offer within that range will depend on the candidate’s experience level.
Work Arrangement
All applicants applying to Gen II Fund Services, LLC must be legally authorized to work in the United States. Please note that all US employees are required to work a hybrid schedule. This position will work a hybrid work schedule comprised of a minimum of three (3) days a week in our office and two (2) days remote.
About the Company
Gen II Fund Services, LLC is one of the largest global independent private equity fund administrators, administering over $1T of private capital on behalf of its clients with offices in New York, San Francisco, Boston, Stamford, Dallas, Denver, Florida, 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 $1T 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.
https://gen2fund.com/candidate-privacy-statement/
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)