Data Analyst - Irene at ESKORT

Qualifications: 

• Undergraduate degree in Computer Science, Statistics, Mathematics, or related fields.
• SQL querying, BI software (preferably Qlik) and advanced Microsoft Office skills.

Experience & Knowledge: 

• 1-3 Year Experience in a BI environment
• Knowledge of Meat Matrix system will be an added advantage.
• Understanding of SQL data base concepts and ODBC Data connections

Skills: 

• Ability to work under pressure and meet tight deadlines.
• Ability to work as part of a team.
• Excellent report-writing, communication, and IT skills
• Excellent analytical and reasoning skills,
• Knowledge of ERP and accounting systems.
• Proficient in MS SQL.
• Proficient With Microsoft 365 Suite.

Job Activities:

Master File Maintenance

• Managing users and user roles.
• Managing master data, including creation, updates, and deletion.
• Commissioning and decommissioning of data sets.

Building and Maintaining Dashboards & Reports

• Designing the reporting environment, including data sources, security, and metadata.
• Supporting initiatives for data integrity and normalization.
• Troubleshooting the reporting database environment and reports.
• Compilation and distribution of reports to users and management.
• Assistance with pricing models, margin reports, cost trends to the Sales Department.
• Analyze the data collected and log a detailed record of the results.
• Training end-users on new reports and dashboards.

 Data and Financial Analysis

• Conduct ongoing process constraint analyses.
• Report on breakeven points by products, work centres, and factories.
• Report on margins by product and division.
• Perform cost accumulation tasks as a member of the target costing group.
• Developing and maintaining databases, data systems, and data pipelines.
• Analyze large amounts of information to discover trends and patterns.

Undertaking data collection, pre-processing, and analysis

• Acquiring data from primary or secondary data sources and maintaining databases.
• Provide quality assurance of imported data, working with quality assurance analysts if necessary.
• Provide management with reports that specify and compare factors that affect prices and profitability of products or services.
• Present information using data visualization techniques.
• Creating reports and presentations for business use.
• Provide rapid feedback and insight on ad-hoc requests.

Collaborate with development team

• Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.
• Assist in Audits
• Determine tasks that can be automated