Data Analyst, ANSA McAL Limited

Job Summary:

The Data Analyst analyzes business requirements to determine and document associated data sourcing, data modelling, and data transformation requirements.

Job Description: 

• Access data warehouse to extract data relevant to analysis.
• Collect data from different systems to centralize operational data.
• Perform data cleansing, data filling, and benchmarking against independent data sources.
• Participate in data migration by mapping a path from the old data system to the new system through the process of data extraction and data loading.
• Conduct basic data reconciliations to ensure accuracy and data integrity.
• Build logical and physical data models to meet data requirements.
• Analyze business requirement to determine and document associated data sourcing, data model and data transformation requirements.
• Validate data flow through implemented data models from source to target.
• Document data quality issues and prioritize the correction in source systems or in the data warehouse.
• Provide input to enterprise architects specializing in information and data on data management decisions, including development and maintenance of the enterprise data model.

Education and Experience Requirements: 

• Bachelors’ degree in Information Technology, Data Analytics, Business Administration or equivalent.
• Minimum of three (3) years’ experience in similar role.
• Proficient in Microsoft Suite (Excel and Word).
• Experience in Power BI or data analytics software will be an asset.