goldhost.blogg.se - Data analysis with excel vba

#DATA ANALYSIS WITH EXCEL VBA PROFESSIONAL#

Accommodations are available upon request for candidates taking part in all aspects of the selection. We have made it a priority to reflect our nation’s evolving diversity in the people we hire, and the culture we create in our organization.Ĭitco welcomes and encourages applications from people with disabilities. We recognize diversity as a source of organizational pride and strength.

Ask us about specific benefits in your location. We provide a range of benefits, training and education support, and flexible working arrangements to help you achieve success in your career while balancing personal needs. Your well being is of paramount importance to us, and central to our success. You are fluent in English (both written and spoken).You have good analytical and problem solving skills.You have ambitions to learn more about Real Assets investment industry and participate in multinational projects.

#DATA ANALYSIS WITH EXCEL VBA PROFESSIONAL#

You have professional experience in data, financial or business analytics.

You have an experience in working with operational efficiency frameworks (LEAN) or process development.

You have RPA experience (optional, an advantage).

You have 2-3 years of Excel VBA programming experience.

You have a degree in Accounting, Finance, Economics, Computer science or related discipline.

You will actively participate in internal initiatives focusing on efficiency, harmonization, process leaning and improving communication.

You will be collaborating with accounting teams and identifying processes for optimization. .Analysis with VBA will jumpstart your success at creating custom engineering tools and automating your repetitive calculations in Excel.

You will perform various financial data and ad-hoc analysis.

You will help to define KPIs and monitor them in automated reports, dashboards.

You will be building various reports, visualizations and dashboards using Microsoft Excel, PowerPoint and other available systems.

You will be responsible for writing VBA codes and macros to automate functions within existing Microsoft Excel models / templates/ reports.

Our continuous investment in learning and technology solutions means our people are equipped to deliver a seamless client experience.Īs a core member of our Real Assets Fund Accounting team, you will be working with some of the industry’s most accomplished professionals to deliver award-winning services for complex fund structures that our clients can depend upon. With more than $1 trillion in assets under administration, we deliver end-to-end solutions and exceptional service to meet our clients’ needs.įor more information about Citco, please visit About The Team & Business Lineįund Administration is Citco’s core business, and our alternative asset and accounting service is one of the industry’s most respected. Your role here will be to monitor day to day operations and ensure a smooth flow.Business Data Analyst, Real Assets (Excel – VBA)Ĭitco is a global leader in fund services, corporate governance and related asset services with staff across 80 offices worldwide.

You will also extensively use graphs to professionally present your analysis. You will use advanced excel functions including VBA to automate data analysis and formatting tasks. Data Analysts typically look for patterns in data and make forecasts and simulations. You role here will be to crunch large volumes of data and provide business intelligence to your teams. You will extensively use MS Excel to make Gantt Charts, Assign tasks, Monitor deadlines and track dependencies and metrics. Your role here will be to coordinate large projects across client and in-house teams. Apply coding skills such as syntax recollection, pattern recognition, problem decomposition, and debugging. Use for loops and conditionals to direct logic flow. This will include capturing and analyzing sales figures, operations forecasts, cost-centre categorization, building dashboards, tracking tickets etc. Create a VBA macro that can trigger pop-ups and inputs, read and change cell values, and format cells. You will use MS Excel to capture and analyze details of the clients business. Your role will be to interface between client and internal domain teams. You will use MS Excel across various functions including Sales, Marketing, Project Management, HR, Operations, Supply Chain etc.