Data Analyst

TESTQ TECHNOLOGIES LTD

United States

Hybrid

USD 46,000 - 53,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

TESTQ Technologies LTD in the UK seeks a Data Analyst to join its Leicester team with hybrid/on-site responsibilities. You will gather, clean, validate and analyse data from multiple sources and create dashboards and reports to provide clear business insights.

You should have 2+ years in data analysis, strong SQL, experience with Power BI or Tableau (DAX), advanced Excel, and Python or R basics. Knowledge of GDPR and data security is required.

Qualifications

  • Min 2+yrs of experience as a data analyst or in a related field.
  • Strong SQL skills and experience with relational databases (SQL Server, PostgreSQL, Oracle).
  • Experience with data visualization tools such as Power BI or Tableau, including DAX or calculated fields.
  • Advanced MS Excel skills, including pivot tables, Power Query and complex formulas.
  • Working knowledge of Python (pandas, NumPy) or R for data manipulation and analysis.
  • Knowledge of statistical concepts and analytical techniques.
  • Experience in data cleansing, profiling, validation and reconciliation.
  • Understanding of data modelling concepts, data warehouses and ETL processes.
  • Ability to translate business requirements into analytical solutions and clear reports.
  • Exposure to cloud data platforms such as Azure, AWS or Snowflake is desirable.
  • Experience in agile teams using Jira and Confluence.
  • Awareness of UK GDPR, data protection and information security principles.
  • Proven ability to manage stakeholders and SMEs to deliver results within demanding timelines.
  • Strong communication skills, able to tailor complex data to various audiences.

Responsibilities

  • Gather, clean, validate and analyse data from internal and external sources.
  • Write and optimise SQL queries to extract, join and transform data for analysis and reporting.
  • Design, build and maintain dashboards, reports and visualisations for clear business insight.
  • Identify trends, patterns, anomalies and root causes and translate into actionable recommendations.
  • Work with stakeholders to understand business questions and analytical requirements.
  • Carry out data profiling and data quality checks and resolve issues with data owners.
  • Automate recurring reports and data preparation tasks to improve accuracy and efficiency.
  • Support data migration, reconciliation and testing activities on client and internal projects.
  • Document data sources, definitions and logic so analysis is repeatable and auditable.
  • Present findings to technical and non-technical audiences in a clear and concise manner.
  • Ensure data handling complies with UK GDPR and company data policies.
  • Continually identify opportunities to create additional value through better use of data.

Skills

SQL
Power BI
Tableau
Excel
Python
R
Data analysis concepts
Stakeholder management
Analytical thinking
Communication

Education

Bachelor's degree

Tools

SQL Server
PostgreSQL
Oracle
Power BI
Tableau
Power Query
Jira
Confluence
Azure
AWS
Snowflake

Job description

Location: West Midlands (Hybrid/On-site)

Job Purpose

TESTQ Technologies is an IT services and solutions company whose offerings spans over variety of industry sectors with strong technical, domain and process expertise helping clients grow their businesses and decrease operational costs on continuous basis in an ever-changing business environment.

This opportunity is in the solution design and development arena for Data Analyst who will play a major role in the technical design and development of the company’s technical offerings. The position is based at our Leicester office with occasional assignments at client locations.

Job Description (Main Duties and Responsibilities)
  • Gather, clean, validate and analyse data from a range of internal and external sources.
  • Write and optimise SQL queries to extract, join and transform data for analysis and reporting.
  • Design, build and maintain dashboards, reports and visualisations that give clear insight to business users.
  • Identify trends, patterns, anomalies and root causes in data and translate them into actionable recommendations.
  • Work with stakeholders to understand business questions and define analytical requirements.
  • Carry out data profiling and data quality checks and work with data owners to resolve issues.
  • Automate recurring reports and data preparation tasks to improve accuracy and efficiency.
  • Support data migration, reconciliation and testing activities on client and internal projects.
  • Document data sources, definitions, logic and methodologies so that analysis is repeatable and auditable.
  • Present findings to technical and non-technical audiences in a clear and concise manner.
  • Ensure data is handled securely and in line with UK GDPR and company data policies.
  • Continually identify opportunities to create additional value through better use of data.
Key Skills, Qualifications and Experience Needed [The candidate must demonstrate these in all stages of assessment]
  • Min 2+yrs of experience as a data analyst or in a related field.
  • Strong SQL skills and experience working with relational databases such as SQL Server, PostgreSQL or Oracle.
  • Experience with data visualisation tools such as Power BI or Tableau, including DAX or calculated fields.
  • Advanced MS Excel skills, including pivot tables, Power Query and complex formulas.
  • Working knowledge of Python (pandas, NumPy) or R for data manipulation and analysis.
  • Good understanding of statistical concepts and analytical techniques.
  • Experience in data cleansing, profiling, validation and reconciliation.
  • Understanding of data modelling concepts, data warehouses and ETL processes.
  • Ability to translate business requirements into analytical solutions and clear reports.
  • Exposure to cloud data platforms such as Azure, AWS or Snowflake is desirable.
  • Experience of working in agile teams using tools such as Jira and Confluence.
  • Good awareness of UK GDPR, data protection and information security principles.
  • Proven ability to manage stakeholders and SMEs to deliver results within demanding timelines.
  • Strong communication skills, being able to understand technical detail and tailor summary to the audience in a simple and clear manner - both verbally and written.
  • High attention to detail and a methodical approach to checking the accuracy of data and outputs.
Other Key skills
  • Good analytical and Problem-solving skills
  • A thorough approach and Self starter
  • Focus on quality and delivery
  • Working together in teams.
  • Leadership and effective decision making.
  • Excellent customer service
Qualifications

Bachelor's degree or above in the UK or Equivalent.

Salary

GBP 35000 to GBP 40000 per annum

Evaluation

CV Review, Technical Test, Personal and Technical Interview and References

Job Type

Full-time, Permanent [Part time and Fixed Term option is available]

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business Analyst
Business Analyst

TESTQ TECHNOLOGIES LTD • United States

Hybrid
USD 73,000 - 79,000
Data Scientist
Data Scientist

TESTQ TECHNOLOGIES LTD • United States

Hybrid
USD 73,000 - 80,000
Data Engineer
Data Engineer

TESTQ TECHNOLOGIES LTD • United States

Hybrid
USD 73,000 - 79,000
Data Analyst — SQL, Dashboards & Insight (Hybrid)
Data Analyst — SQL, Dashboards & Insight (Hybrid)

TESTQ TECHNOLOGIES LTD • United States

Hybrid
USD 46,000 - 53,000
Performance Analyst
Performance Analyst

TESTQ TECHNOLOGIES LTD • United States

Remote
USD 46,000 - 53,000
Software Developer
Software Developer

TESTQ TECHNOLOGIES LTD • United States

Hybrid
USD 73,000 - 79,000
Data Governance Manager
Data Governance Manager

TESTQ TECHNOLOGIES LTD • United States

Hybrid
USD 64,000 - 71,000
Leicester office
Delivery Manager
Delivery Manager

TESTQ TECHNOLOGIES LTD • United States

Hybrid
USD 77,000 - 84,000
Data Scientist – ML, Forecasting & Insights (Hybrid)
Data Scientist – ML, Forecasting & Insights (Hybrid)

TESTQ TECHNOLOGIES LTD • United States

Hybrid
USD 73,000 - 80,000
Junior Data Analyst
Junior Data Analyst

CONVENTUS SOLUTIONS LIMITED • Location (WV)

Hybrid
USD 55,000 - 75,000