7 Excel Functions Jobs

The successful candidate will join the Fund Services team as a Hedge Fund Accountant and will closely work with Client Service Managers based in Asia, Europe, and US regions in connection with the administration of Alternative Funds. You should have around 1-10 years of relevant experience in the Administration of Hedge Funds and NAV calculations. Reporting to AVP Hedge Fund Accounting, you will be responsible for reviewing and preparing the NAVs of hedge fund clients on a daily/monthly basis. Additionally, you will prepare Cash/Position/Market Value Reconciliations, resolve breaks, review pricing of the portfolio, analyze pricing exceptions, review corporate actions, and ensure correct reflection in the books. As a Hedge Fund Accountant, you will accrue/amortize daily or monthly non-security related fee accruals, process non-automated transactions including OTC derivatives, communicate effectively with clients on daily reporting, check the correct booking of OTC products traded by clients, book Capital Activities of the fund, finalize month-end NAV of the client, provide Investor Level Allocation reports at month-end, and support audits for funds in the preparation of financial statements. You will also support operations on various projects related to Automations, Work migrations, and Conversions, and coordinate with Internal/External Stakeholders such as Securities/Trades and Pricing Team, Reporting Team, Investor Services team, Auditors, Client Service Managers, and Clients. The ideal candidate should have experience working with an investment management or finance-related firm, possess good knowledge of the investment industry with 1-10 years in Hedge Fund administration NAV, Reconciliation, Geneva, or related industry experience, hold an M.com/CA/MBA/CMA Finance/CFA degree, and be familiar with Paxus. Critical thinking, objective analysis, attention to detail, accuracy, analytical and technical skills, organizational capabilities, problem-solving skills, proficiency in advanced Excel functions, excellent communication, and inter-personal skills are essential for this role. You should also be willing to work additional hours as needed.,

As a Financial Analyst at NTT DATA, you will play a crucial role in gathering and analyzing financial data to support decision-making processes and provide valuable guidance to business stakeholders. Reporting to the Senior Director-Global Investment Financial Analysis, you will work closely with various departments to develop business case modeling for new locations, analyzing profitability, making financial recommendations, and monitoring financial performance. Your key responsibilities will include collaborating with different departments to compile assumptions for new site business cases, analyzing business case inputs for reasonableness, updating business cases with actuals and revised forecast assumptions, evaluating asset performance, understanding and calculating financial business plan measurements such as IRR, NPV, and terminal value, and forecasting debt requirements. Moreover, you will work in tandem with the Sales department to comprehend large deal commercial terms, prepare profitability analysis for board approval, update business cases with large deal opportunities, provide support to third-party investors through profitability analysis, prepare cost comparison analysis, and create PowerPoint presentations for executive audiences communicating financial metrics. In this role, you are expected to possess a solid understanding of basic financial concepts, have the ability to work independently in a fast-paced environment, demonstrate strong analytical skills, make informed decisions, conduct detailed data analysis, and manipulate large data sets using advanced Excel functions. Proficiency in Microsoft programs such as Word, Excel, and Outlook is essential, and the ability to create context in PowerPoint presentations is required. Revenue Recognition knowledge is preferred, and experience with construction is considered a plus. To qualify for this position, you should hold a Bachelor's degree in accounting or finance, with an MBA/CPA being preferred. A minimum of 7-8 years of progressive experience in finance is required. The role involves primarily sitting with some walking, standing, and bending, as well as using a computer terminal extensively. You must also be able to effectively manage stress, communicate efficiently, and work well in a team environment. This position offers a hybrid working environment, requiring flexibility to work from both the office and home as per HR policy. Additionally, occasional travel of 5-10% may be necessary, with potential meetings held across different time zones. NTT DATA is an Equal Opportunity Employer, committed to diversity and inclusion in the workplace. If you are looking to grow your career in finance and make a significant impact within a global team, we encourage you to apply for this exciting opportunity at NTT DATA.,

You will be joining the Fund Services team as a Hedge Fund Accountant at Apex, a global financial services provider with a presence in Bangalore/Pune/India. Your primary responsibility will involve closely collaborating with Client Service Managers across different regions like Asia, Europe, and the US to administer Alternative Funds. The ideal candidate should possess 1-10 years of relevant experience in Hedge Fund Administration and NAV calculations. Your reporting line will be to the AVP Hedge Fund Accounting within the organization. As a Hedge Fund Accountant, your key tasks will include reviewing and preparing NAVs for hedge fund clients on a daily/monthly basis, conducting Cash/Position/Market Value reconciliations, resolving breaks, and notifying clients about valid breaks. Additionally, you will be responsible for reviewing pricing of the portfolio, analyzing pricing exceptions, reviewing corporate actions, and ensuring accurate reflection in the books. Other responsibilities include accruing/amortizing daily or monthly non-security-related fee accruals, processing non-automated transactions like OTC derivatives and related cash movements, ensuring effective communication with clients on reporting and query resolutions, finalizing month-end NAV of clients, providing support in audits, and coordinating with internal/external stakeholders. To excel in this role, you should have experience in investment management or finance-related firms, possess good knowledge of the investment industry, and have expertise in Hedge Fund administration NAV, reconciliation, Geneva, or related industry experience. A degree in M.com/CA/MBA/CMA Finance/CFA is preferred, and familiarity with Paxus is considered a major plus. Critical thinking, attention to detail, analytical skills, proficiency in advanced Excel functions, strong communication skills, and the ability to work additional hours when needed are essential for this role.,

As a Financial Analyst at NTT DATA, you will be a seasoned subject matter expert responsible for gathering and analyzing financial data to facilitate decision-making and providing guidance to business stakeholders. Reporting to the Senior Director-Global Investment Financial Analysis, you will play a crucial role in analyzing and summarizing financial recommendations for new capital investments and sales opportunities. Your responsibilities will involve collaborating closely with various departments, including Sales & Construction, to develop business case modeling for new locations, analyze profitability, make financial recommendations, and monitor financial performance. Additionally, you will work with the Sales department to evaluate complex and large opportunities and compare them against the original site business case. Key Responsibilities: - Collaborate with other departments to build business cases for new sites by gathering assumptions - Analyze business case inputs and compare them to other investments - Update new site business cases with actuals, revised forecast assumptions, and compare against the original case - Evaluate asset performance and financial results - Understand and calculate financial business plan measurements such as IRR, NPV, and terminal value - Forecast debt requirements and submit draw requests - Work with the Sales department to prepare profitability analysis for board approval based on large deal commercial terms - Update business cases with large deal opportunities to evaluate sales impact on project profitability and against budget - Provide support to third-party investors through profitability analysis and data support - Prepare cost comparison analysis as required - Create PowerPoint presentations for Executive audience to communicate financial metrics - Undertake other projects as assigned to support the Finance department - Perform additional duties as required Knowledge, Skills & Abilities: - Knowledge of basic financial concepts like capital budgeting - Ability to work independently in a fast-paced environment - Strong analytical skills for comparing sales trends and determining market data - Excellent decision-making and problem-solving skills - Proficiency in conducting comprehensive data analysis and preparing detailed reports for stakeholders - Advanced Excel skills for manipulating large data sets and extracting strategic insights - Ability to maintain confidentiality - Proficient in Microsoft programs such as Word, Excel, and Outlook - Strong PowerPoint skills to create impactful presentations - Revenue Recognition knowledge preferred - Team player with effective stress management abilities - Excellent communication and stakeholder management skills Education & Experience: - Bachelor's degree in accounting or finance required - MBA/CPA preferred - Minimum of 7-8 years of progressive finance experience - Experience with construction is a plus Physical Requirements: - Primarily sitting with some walking, standing, and bending - Ability to hear and speak into a telephone - Close visual work on a computer terminal - Dexterity of hands and fingers for operating computer equipment - Can lift and carry up to 20 lbs Work Conditions: - Extensive daily usage of workstation or computer Special Requirements: - Expected to work in a hybrid environment following HR policies - Flexibility to support regions across different time zones - Travel required approximately 5-10% of the time Join NTT DATA and be part of a diverse, inclusive workplace where you can continue to grow, belong, and thrive. #GlobalDataCentersCareers,

The successful candidate will join the Middle Office team as a VP Middle Office and will closely work with Client Service Managers based in Europe, Singapore, and US regions in connection with the performance of duties related to the Middle Office Reconciliation process. You should have around 12 plus years of relevant experience in Hedge/Mutual Funds reconciliation and Break resolution, along with good knowledge of Financial products. The position reports to SVP Middle Office. Key Duties And Responsibilities - Planning, scheduling, and managing the daily workflows of all client deliverables within the team. - Reviewing and preparing Middle Office Reconciliations on a daily/monthly basis. - Preparing Cash/Position/Market Value Reconciliations and resolving breaks, notifying Clients/CSMs of valid breaks. - Reviewing corporate actions booked in the system and ensuring correct reflection in the books. Dividends/Interest Reconciliation with Broker reports. - Independently pricing Investment positions on a daily & monthly basis. - Accruing/amortizing daily or monthly non-security related Fee accruals. - Reviewing the PNL before delivering the report to the client. - Processing non-automated transactions including OTC derivatives and their related cash movements. - Effectively communicating with clients on daily reporting of Reconciliation/Query resolutions. - Checking that all OTC products traded by the client have been booked correctly. - Supporting operations on projects related to Automations/Work migrations/Conversions, etc. - Supporting global changes in Key operating procedures and implementation. - Coordinating with Internal/External Stakeholders such as Securities/Trades and Pricing Team, Reporting Team, Investor Services team, Auditors, Client Service Managers, and Clients. - Monitoring deliverables to ensure high SLA compliance within set accuracy standards. Skills Required - Experience working with an investment management or finance-related firm. - Experience in Fund Accounting area, especially on FX or PNL. - Good knowledge of the investment industry with a minimum of 12 years of experience. - M.com/CA/MBA Finance/CFA qualification. - Familiarity with Calypso/Paxus is a major plus. - Ability to think critically and objectively. - Experience with reconciliation and break resolution with demonstrated attention to detail, accuracy, analytical, technical, organizational, and problem-solving skills. - Proficiency in advanced Excel functions. - Excellent communication and interpersonal skills. - Willingness to work additional hours as needed. - Team management skills. - Performance appraisal experience. - People growth and development skills. Qualification And Experience - Postgraduate in Commerce, MBA Finance, CA/CMA/CFA. - 13-16 years of experience in Middle Office & Hedge/Mutual Fund reconciliation and break resolution experience. What You Will Get In Return - A unique opportunity to be part of an expanding large global business. - Exposure to all aspects of the business, cross-jurisdiction, and working directly with senior management. Additional Information We measure our success as a business not only by delivering great products and services and continually increasing our assets under administration and market share but also by how we positively impact people, society, and the planet. For more information on our commitment to Corporate Social Responsibility (CSR), please visit our CSR policy page. Website address: https://theapexgroup.com,

We are looking for a skilled VBA Automation Specialist with a strong background in market research to streamline and enhance reporting processes in Excel and PowerPoint. The ideal candidate will be responsible for developing, optimizing, and maintaining VBA macros to automate data processing, charting, and presentation generation, ensuring efficiency and accuracy in reporting. Key Responsibilities: Develop and maintain VBA macros for automating tasks in Excel and PowerPoint. Automate the creation of charts, tables, and reports for market research presentations. Work with large datasets to clean, manipulate, and structure data efficiently. Develop dynamic dashboards and templates to improve reporting efficiency. Troubleshoot and debug VBA scripts to ensure smooth execution. Collaborate with research teams to understand requirements and implement automation solutions. Ensure data accuracy, consistency, and adherence to client formatting guidelines. Optimize existing VBA scripts to improve processing speed and functionality. Required Skills & Qualifications: 2 to 3 years of experience in VBA automation for Excel and PowerPoint. Market research experience is mandatory familiarity with survey data, reporting, and analysis. Proficiency in Excel functions, Pivot Tables, and Power Query. Strong understanding of charting and data visualization in PowerPoint. Ability to handle and process large datasets efficiently. Experience in integrating VBA with external data sources (e.g., databases, APIs) is a plus. Strong analytical and problem-solving skills. Attention to detail and ability to meet tight deadlines. Excellent communication and teamwork skills. Preferred Qualifications: Experience with VBA , Python, SQL, or Power BI for data automation (optional but a plus). Familiarity with market research tools like SPSS, Decipher, or Q Research Software.,

OPENTEXT: OpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that shape the future of digital transformation. Your Impact: OpenText enables the digital world as the global leader in Enterprise Information Management, both on premises or in the cloud. We embrace all things digital and are committed to being the Best Place to Work for our Employees in over 140 locations around the world. We obsess over our customers to ensure they are wildly successful in embracing the Digital World. Our customers entrust us with their most important information, we need to be their most trusted partner. What we do, we do well. What we create, we do purposefully to impact the world. If you believe in this and are passionate about enabling the Digital World, then let OpenText turn your career vision into reality. OpenText has one of the best & advanced products to help legal and compliance industry discover what matters across massive volumes of enterprise data. Using unstructured data analytics, machine learning, and interactive visualizations, our platforms provide fast access to key documents, contract terms, personnel with expertise, and critical early insightsfor litigation, investigations, due diligence, compliance, and more. What The Role Offers: The Cloud Application Consultant Cloud Application Consultant will play a key role in eDiscovery operations, providing expertise in such as staging, media management, processing, data loading and troubleshooting. This position will work with project managers, technical project managers, other data analysts and consultants and provide the expertise required to deliver litigation support, consulting and troubleshooting directly to high value accounts. Will be working within a group of members to monitor and process documents for project managers and clients to completion. Will need to be capable to detail outputs and communicate issues and successes within a varied software system utilizing eDiscovery software. What You Need to Succeed 3+ years of experience in Processing and Production operations with a strong understanding of the EDRM workflow and hands-on experience with eDiscovery tools such as Axcelerate, Insight, and similar platforms. Expertise in handling various types of data, including EnCase, FTK image, PST, OST, and NSF files, with the ability to process large datasets efficiently while ensuring thorough quality checks and compliance with standard operating procedures. Proficient in text editors like Notepad++, UltraEdit, and TextPad for efficient data manipulation, along with strong expertise in Excel functions such as VLOOKUP, text functions, logical formulas, Pivot Tables, and graphical data representation for effective data analysis and visualization. Strong technical skills in SQL and programming, including experience in writing stored procedures and functions, and familiarity with Python scripting or other automation tools is an added advantage. Ability to work in a 24x7 rotational shift and assist Project Managers with case- or project-specific requests. Utilize an internal ticketing system to track and manage client requests. Work effectively in cross-functional teams, taking proactive actions to meet business requirements under tight deadlines while ensuring all SLAs are met. Excellent written and oral communication skills with strong analytical abilities to interpret and troubleshoot data processing challenges. Maintains high professional standards, demonstrating competence, confidence, and ethical integrity while ensuring proper poise and etiquette in client and internal interactions.,