Data Analyst (Microsoft Excel)

Do you have an excellent understanding of Microsoft Excel, and want to progress into a career in data?  

TVH has a new Data Analyst opportunity available within its Preventative Maintenance Data Team. You will use your advanced Microsoft Excel skills to manipulate raw schedule data for upload into our system. Your ability to identify inaccuracies and cleanse data efficiently will be valued in our team. Your daily role will also require you to work within multiple internal and external computer systems.

Our ideal candidate is comfortable picking up the phone to iron out data issues with our clients and internal staff. The role might suit you if you have a background in contact centres or other roles that demonstrate you are able to navigate many different computer systems to investigate issues.

You will have opportunities to make improvements to our work. Our other Data Analysts have contributed reporting templates for other business areas, learned to use Power Query or macros to automate data processing, and created procedures and lists to help our team run more smoothly. This role has opportunities for improvement, and we will support you to grow your career!

Our team can offer a hybrid working from home and office model. The role requires a minimum of 6 weeks working/training from the Scoresby office before transitioning to working from home, time/days to be agreed upon at commencement.

About the Preventative Maintenance Data Team:

We handle massive volumes of data involved in delivering maintenance services across Australia. The data tracks our work starting with the client’s purchase order, to monitoring and reporting on completion targets, to ensuring data is ready for invoicing. We also maintain the asset data that sits behind each maintenance request from tens of thousands of ever-changing assets across over 10,000 sites.

Responsibilities:

• Use Microsoft Excel to manipulate data provided by the client to successfully upload into our Microsoft Dynamics CRM system
• Use contract information to automate schedule uploads by ensuring all system fields are accurate; maintaining the information as the contract changes
• Review, cleanse and upload asset data recorded by operational field staff or provided by clients
• Compile accurate and useful progress reports
• Creating orders/jobs to dispatch the planned maintenance into the field
• Updating managers with overviews of customer maintenance programs or asset data analytics 

Key Skills and experience:

• Advanced MS Excel/CSV skills (specifically lookup formulas, text manipulation formulas, etc)
• Ability to manipulate data and develop detailed spreadsheets to upload into a separate system
• Great communication skills and strong attention to detail
• Experience with formulating methods and assumptions; ability to troubleshoot to obtain an outcome
• Ability to research and provide timely data insights and meaningful recommendations to support business objectives
• (Desired) 2+ years of experience in a role utilising Microsoft Excel
• (Desired) Exposure to an asset or service management environment is valued but not required 

To apply, please use Seek’s “Apply” button, and ensure your resume and cover letter address the Key Skills and Experience above.