Data Analyst

About the Role

We have an exciting opportunity available to join our Business Systems team.

In this position, the Data Analyst will be working closely with AS400 and BI Developers to assist with the identification and analysis of data from different sources (predominantly AS400) to fulfill the data requirements for the regions BI reporting.

Requirements

Responsibilities & Duties

• Identification and analysis of required data.
• Troubleshooting data integrity issues as they are identified.
• Assist with the development of SSIS packages for data ETL processes.
• Assist in the creation of clear and concise reports and dashboards using Power BI visualisation tool.
• Assist in the development of technical and end-user documentation.
• Provide quality customer service in the delivery of end-user support for BI analytical tools (PowerBI, PowerApps).
• Assist with the ongoing preparation and production of key legacy reports and extracts.
• Assist the Business Systems team members as required.

Skills & Experience

• Proven experience in a similar role.
• Strong knowledge and experience using SSMS and SSIS.
• Solid SQL and Excel skills essential.
• Strong experience developing reports and dashboards using PowerBI.
• AS400 (IBM i) database experience would be highly regarded (but not essential).
• Strong analytical and problem-solving skills.
• Exceptional computer skills.
• Excellent communication skills.

Benefits

What sets us apart?

Crown’s history began when two brothers founded the Company in New Bremen, Ohio (USA) in 1945. Today, the fourth generation of the very same family continues to lead Crown in all of its operations across the globe. Being a family-owned and run business is evidenced by more than 200 employees reaching service milestones in our 20, 25, 30, 35, 40, 45 and 50 year categories in Australia alone, with more than 2,000 employees reaching a 25 year service milestone globally. 

As a Company we want to continue to support our employees to be the best versions of themselves and that’s why, as a Crown employee you get to enjoy:

• A benefits program which gives you access to discounts and cashback from over 400+ retailers nation wide.
• Access to a health and wellbeing platform which supports your Mental, Physical and Financial goals.
• Corporate Rates for Private Health Insurance.
• An inclusive working environment.
• An Employee Assistance Program for confidential counselling with chat, phone and face to face counselling options.

The Company

Crown Equipment is a well-respected global Materials Handling Equipment company which has enjoyed 50 years of success in the Australian market. The Company has operations in all Australian States and territories as well as many regional locations. The Company Brand is well known and respected in the marketplace and is supported by a customer value proposition based on highly skilled staff, quality products, strong service and parts back-up and leading-edge technology.