Senior VBA & Automation Specialist
Kraków
Nr ref.: 2021-42710
With over 300 employees, the EMEA Finance Centre in Krakow provides financial services for Aon entities in multiple countries. This role will work closely with the Manager and the Data Management team to support Corporate and Regional Finance teams through data analysis, process improvement and decision support solutions. The analyst will be responsible for accurately compiling and analysing financial information to identify trends and recommend potential solutions to management. The analyst will assist in maintaining daily, weekly, monthly, quarterly, and annual reports using a variety of reporting and BI tools.
Responsibilities:
- Develop tools to report from Oracle based database sales system
- Process re-engineering and optimisation (VBA & SQL)
- Work closely with the management and teams to gather new processes requirements
- Prepare solutions for end users to help them avoid manual and repetitive work
- Prepare tolls for Finance Team required by business needs
- Maintain a catalogue of automated processes and ensure that all reporting is provided
Key skills:
- Excellent command of VBA for applications
- Good understanding of relational database concepts
- Basic Structured Query Language (SQL)
- Capable of working on projects with aggressive schedules
- Able to quickly learn new concepts or technical tasks
- Ability to gather and translate business needs to validate and support reporting requirements
- Good communication skills to present reports, data or processes in order to influence or persuade counterparts of the validity of opinions or to defend positions taken
- Finance knowledge would be an asset
- Tools (DOMO, Tableau, QlikView, Power BI) would be an advantage
- Fluent English (C1)
- Spotless recors and strong ethos
We offer:
- A promising career path and individual development plan
- A large number of career opportunities in different business areas
- Cooperation with young, energetic and craving for knowledge colleagues
- The opportunity to build strong and meaningful relationships with clients and influence their business
- The best medical cover on the market with free dental care
- Generous and competitive benefits package (multisport cards, insurance, vouchers – find out what else is waiting for you!)
- Offices in close proximity to Krakow’s city centre
- The chance to participate in social events and charity actions