Intermediate Data Analyst to support Finance group with efficient and accurate data transformation, data validation and report creation in Power Query and Power BI (00001725)(Remote)
Job Type: Contract
Positions to fill: 1
Start Date: Jun 01, 2023
Job End Date: Dec 31, 2023
Pay Rate: Hourly: Negotiable
Job ID: 130003
Location: Calgary, Edmonton, Halifax, London, Montreal, Ottawa, Regina, Toronto, Vancouver, Victoria, Winnipeg
Our Agriculture client is looking for an Intermediate Data Analyst to support Finance group with efficient and accurate data transformation, data validation and report creation in Power Query and Power BI (00001725)(Remote)
Must Have:
• Experience automating processes with RPA tools would be an asset
• Experience working with Oracle eBS, SAP ECC, Peoplesoft and/or SAP S/4 would be an asset
• Experience with Python and/or R programming language would be an asset
Responsibilities:
• Build an understanding of multiple areas within Finance to support efficient and accurate data transformation, data validation and report creation
• Build scalability in reporting to support global growth
• Manage the creation of accurate reporting that enables “analysis, insight and action”
• Parse, cleanse and manipulate large amounts of structured and unstructured data for analysis
• Coordinate the creation and enhancement of data cubes, including cubes which harmonize data from multiple sources, through collaboration with Finance subject matter experts and the IT data services team
Must Have:
- 5+ years experience as a Data Analyst supporting data transformation, data validation and report creation with-in Finance
- Experience with Microsoft Power Query and Power BI including writing expressions in DAX and M language (preference will be given to those with expert-level skills)
- Experience writing database queries using SQL
- Experience extracting, manipulating, validating and analyzing large data sets to draw conclusions
• Experience automating processes with RPA tools would be an asset
• Experience working with Oracle eBS, SAP ECC, Peoplesoft and/or SAP S/4 would be an asset
• Experience with Python and/or R programming language would be an asset
Responsibilities:
• Build an understanding of multiple areas within Finance to support efficient and accurate data transformation, data validation and report creation
• Build scalability in reporting to support global growth
• Manage the creation of accurate reporting that enables “analysis, insight and action”
• Parse, cleanse and manipulate large amounts of structured and unstructured data for analysis
• Coordinate the creation and enhancement of data cubes, including cubes which harmonize data from multiple sources, through collaboration with Finance subject matter experts and the IT data services team