Chicago, United States; Boston, United States; Darien, United States; New York, United States
Hybrid
Job ID:
10989
Date posted:
May 19 2023
Category:
Technology
Job Level:
Senior Officer
Application Support Analyst
We are Alter Domus. Our name means “The Other House” and we’re a world leading provider of integrated solutions for the alternative investment industry. We believe in being different. Here, you progress on merit, not who you know. You speak openly, whoever you’re speaking to. And it’s your freedom to decide which cutting-edge kind of finance professional you want to be. Join more than 4,500 fund administration, accounting, tax, loan administration and legal experts worldwide and take pride in being alternative.
Alter Domus clients include the world’s leading asset managers, lenders and asset owners. We’re specialists who use the most innovative technologies to create unparalleled solutions for the private equity, real assets and debt capital markets sectors. This is where standout talent advances what’s possible in fund administration, corporate services, depositary services, transfer pricing, domiciliation, management company services, loan administration, agency services, trade settlement and CLO manager services.
At Alter Domus we attract, grow, and develop Alternative Thinkers. The Alter Domus Academy helps our people to be their professional best, to become Alternative Thinkers. The Academy team is expanding, and we are looking for an L&D Partner who shares our passion for developing people.
Alter Domus is looking for a Technical Business Analyst to drive the continued expansion of its financial technology solutions to the Alternative Investment industry. The business unit is a FinTech setup where you will be leading and building best-in-class software. Our tech-enabled platform is the market’s only capital administration solution purpose-built to meet the unique demands of alternative investment managers. This proprietary software solution helps General Partners simplify complex capital administration issues, while ensuring they deliver a seamless reporting experience to Limited Partners and General Partner members.
Leveraging your expert business analyst and SQL skills in an accounting/financial context, you will work within an agile team structure to define and deliver new software features, support new client implementations and support our production users. We offer a highly collaborative setting in a fast-paced environment where data is at the center of our software and client experience.
Responsibilities:
- Design business functionality to automate scalable, performant, and secure software solutions.
- Collaborate with our development teams to design, implement data-driven applications and services.
- Perform high level and detailed data analysis of financial data from private equity clients from a variety of sources, including General Ledger systems, Excel spreadsheets, and proprietary or legacy systems and aligning to our proprietary data formats and database structures.
- Execute, maintain, and enhance existing SQL queries for every-day system configuration requirements across various client deliverables within the product pipeline.
- Define relevant test scenarios and assist with mapping and testing new data integration platforms.
- Demonstrate that you can learn the business logic and actively contribute to new features on our roadmap.
- Create test cases to enable end-to-end verification of accounting and financial artifacts and workflows.
- Applying your data and SQL skills, assist the business users with ad hoc requests, unique dataset extraction needs, and perform complex data analyses specific to business requirements and support for ongoing configuration maintenance.
Skills/Qualifications:
- A successful candidate is an ambitious career-minded professional having 3+years of proven success in a related role and possessing a bachelor’s degree in Management Information Systems, Information Technology, Computer Science, or a closely related degree.
- Strong working knowledge of MS Excel.
- Expertise with SQL coding and data normalization in RDBMS platforms. Strong working knowledge of Microsoft SQL Server, SSRS, SSMS, SSIS and T-SQL.
- Experience in data processing concepts / principals and validation techniques to ensure data integrity and data quality.
- Experience with handling large data sets using reports/queries, uploads using data imports and integration tools.
- Experience with creating testing plans for processes that ensure processes are functioning within acceptable ranges.
- Experience with data integration, data warehousing and visualization tools a plus.
- Knowledge of accounting a plus.
- Knowledge of web technologies, HTML, CSS, JavaScript a plus.
- Excellent verbal, written and presentation skills to support effective communication with a wide variety of constituents.
- Ability to interact with clients, always maintaining the integrity of the Alter Domus brand.
#LI-LS1
Our stories
Amanda Donohue, Senior Manager, Cork
Think ahead to five years’ time and where you would like to see yourself. That’s what I did and Alter Domus offered me the right path.
Aristidis Halikias, Managing Director, Chicago
Many might think that the financial services industry is primarily numbers and math, but I believe we are a people business. The people at Alter Domus make it what it is, and we have some of the best in the entire industry.
Carla Walmsley, Senior Manager, Jersey
Alter Domus were fully supportive through my studying path, providing study support in the way of study fees and study leave, as well as some flexible working towards nearer each exam to help me manage with work/life (and exam!) balance.
Shania Galea, Corporate Services Officer, Malta
As a junior, I learn a lot from all colleagues around me. In addition, the AD Academy keeps on providing us with all the training we need.
