Data Analyst

ASTREYA ASIA PACIFIC PTE. LIMITED; Penarth; On-site; GBP 30,000 - 45,000; Full time

Job summary

A growing analytics firm in Penarth seeks a skilled Data Analyst to enhance data accuracy and efficiency. Responsibilities include creating data visualizations and troubleshooting database issues. Ideal candidates will have a Bachelor's degree and 2 to 5 years of experience, alongside strong SQL and advanced Excel skills. Attention to detail and communication proficiency are essential for success in this role. This position offers opportunities for professional development in a collaborative environment.

Qualifications

• 2 to 5 years related experience and/or training.
• Ability to create and modify macros.
• Experience in building productive working relationships.

Responsibilities

• Create data visualizations.
• Troubleshoot database technical issues.
• Analyze data sets for accuracy and efficiency.
• Perform quality assurance on data.

Skills

SQL skills

Advanced Excel skills

Data analysis

Attention to detail

Communication skills

Education

Diploma or Bachelor’s degree

Tools

Google Sheets

Google PLX Dashboards

Job description

What this Job Entails:

We are looking for a Data Analyst to join our growing team of analytics experts. The hire will be responsible for statistical modeling, and analysis of structured and unstructured datasets to develop metrics, reports, and visualizations of trends and patterns. The Data Analyst identifies and captures data from internal and external sources. The Data Analyst will ensure consistency throughout ongoing projects.

Your Roles and Responsibilities:

• Create data visualizations
• Troubleshoot and test database technical issues with development team
• Create monthly Excel and Google Sheets files from database
• Independently analyze data sets to identify opportunities for increased accuracy and efficiency
• Perform quality assurance on data to determine potential data gaps
• Handle data-related technical issues and support data infrastructure needs
• Assemble large, complex data sets that meet functional / non-functional business
• Work with data and analytics experts to strive for greater functionality in our data systems

Required Qualifications/Skills:

• Diploma or Bachelor’s degree (B.S/B.A) and 2 to 5 years’ related experience and/or training; or equivalent combination of education and experience
• Builds productive internal and external working relationships
• Exercises judgment within defined procedures and practices to determine appropriate action
• SQL skills; including creating and modifying macros, as well as creating dashboards using SQL coding
• Excellent written communication skills
• High level of attention to detail
• Advanced Excel skills to include; formulas, functions, pivot tables, lookup and reference formulas (i.e. vlookups), statistical formulas (countifs, sumifs), macros (ability to create new and edit existing), conditional formatting, importing data, creating graphs/charts, etc.
• Ability to independently analyze large amounts of data; including the ability to identify, analyze, and interpret trends, gaps, patterns in complex data sets

Preferred Qualifications:

• Experience using Google PLX Dashboards