Excel Analyst at Dynamiss Digital Learning

Job Description

• We are looking for a passionate Data Analyst with excellent Excel skillsets. The successful candidate will turn data into information, and be able to use Excel formulas to investigate, troubleshoot and solve problems
• The Excel analyst’s responsibilities will include collating and coordinating data files required for uploading and Provisioning on to our Microsoft Azure based platform, as well as making sure the data is clean and free from errors that may corrupt the Learning Management Platform or disrupt the efficiency of the use of the system
• They will also monitor performance and quality control plans to identify improvements.

Responsibilities

• Able to USE EXCEL FORMULAS including VLOOKUP/Deduplication checks/ Concatenations and general problem-solving using Excel tools and formulas
• Filter and Clean Data using Excel Commands to locate and correct data and avoid code problems
• Acquire data from Primary and secondary data sources
• Locate and define new process opportunities wherever possible
• Develop and implement data analytics that optimises efficiency and quality
• Interpret data, analyse results using statistical techniques and provide ongoing reports
• Identify, analyse, and interpret trends or patterns in complex data sets
• Knowledge of being able to use Access for data analysis and simple queries would be advantageous
• Work with management to prioritize business and information needs

Requirements

• Bachelor's Degree from an accredited institution in Mathematics, Economics, Finance, Business, Computer Science, Information Management, Statistics, or other discipline required.
• Advanced Microsoft Excel skills required.
• Demonstrated ability to manage small projects or work streams of larger projects.
• Strong analytical and problem-solving skills with a high degree of initiative and creativity required. In addition, the ability to collect, organize, analyse, and disseminate significant amounts of information without compromising attention to detail and accuracy
• Adept at queries, report writing and presenting findings
• Proficiency with data visualization preferred.
• Excellent verbal and written communication skills.
• Attention to detail.
• Ability to work independently and prioritize in a deadline-driven environment and seek direction when needed.
• Understanding of and appreciation for basic data privacy concepts and principles (e.g., importance of securing data at rest and in transit, ensuring data is used in a way that is consistent with the intended purpose).