Matrix designs, manufactures, and sells innovative technological products that help keep people safe. Originally focused on the underground coal mining industry, Matrix has expanded into new industrial markets in the United States and globally.

Matrix Analytics is a growing analytics group founded in South Africa which now operates out of Lexington, KY as a subsidiary company of Matrix Design Group with employees based out of both South Africa and the US. The group’s analytics experience is oriented towards the mining space, where we integrate hardware, software, and analytics solutions to meet the needs of our clients. The position of Junior Data Analyst is primarily responsible for assisting the analytics team in the United States as well as in South Africa.

The Junior Data Analyst assist the analytics team in collecting and interpreting data to help a company take actionable steps to improve their performance and meet goals. Their duties include gathering company information and statistics, building reports to be presented to executives and finding ways to improve a company’s efficiencies using gathered data. As an entry-level employee, the junior data analyst is expected to participate and collaborate in a small team.

This position reports to the Head of Analytics: Operations.

Duties & Responsibilities

  • Create Dashboards and Reports
  • Design, build and deploy SQL BI solutions, predominantly using multiple Excel and SQL data sources
  • Maintain and support data analytics platforms
  • Prepare and analyze Data using R, Python, SQL, SAS, and Excel.
  • Performing quality control procedural checks including cleaning data to ensure accuracy and consistency
  • Visualization of outputs including developing graphs, reports, and presentations of project results
  • Finding patterns and trend in data and communicating them to team members

Competencies & Qualifications

  • Minimum a Bachelor’s degree in computer science, mathematics, economics, statistics, finance, or related fields
  • Excellent verbal and written communication skills
  • Experience with ETL process
  • Data analysis
  • Regression analysis
  • Dashboard creation
  • Data quality assessment
  • Data Mining
  • Research on broad range topics
  • Motivated and highly driven
  • Passionate for developing new skills
  • Ability to work well in a pressured/high pace environment
  • Experience in transforming and manipulating large datasets
  • Team player with the ability to support the team
  • A tertiary qualification demonstrating proficiency in programming/ economics and/or mathematics
  • Programming, mathematical, and statistical skills
  • Prior knowledge on R, Python, SQL, or other programming languages
  • 1+ years’ experience with Power BI/Tableau/QlikView or similar Business Intelligence platform
  • Strong understanding of Microsoft Excel including VLOOKUP and Pivot table experience
  • The general working conditions for this position is an office environment.

Working Conditions

The general working conditions for this position is an office environment.

Physical Requirements

The physical requirements can include long hours on a computer keyboard and prolonged periods of sitting. There may also be periods of standing and/or walking. The ability to lift 10 pounds may also be necessary.

Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.