Data Analyst

Orsett Terrace Properties
Charing Cross, United Kingdom
5 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Compensation
£ 72K

Job location

Charing Cross, United Kingdom

Tech stack

Business Analytics Applications
Data analysis
Bash
Big Data
Databases
Data Systems
Data Visualization
Relational Databases
Database Design
Database Storage Structures
R
Python
Shell
Microsoft Visio
Microsoft SQL Server
Oracle Applications
Systems Development Life Cycle
Power BI
Software Engineering
SQL Databases
Systems Architecture
Tableau
Scripting (Bash/Python/Go/Ruby)
Data Storage Management
Vba Programming Language
Programming Languages

Job description

We are seeking a dynamic and detail-oriented Data Analyst to join our innovative team. In this role, you will harness your expertise in data analysis, database management, and visualization tools to transform complex data into actionable insights. Your contributions will drive strategic decision-making, optimize business processes, and support project initiatives across various departments. This paid position offers an exciting opportunity to work with cutting-edge technologies and develop your skills in a collaborative environment dedicated to excellence and continuous improvement., * Collect, clean, and analyze large datasets using SQL, R, Python, and other analytical tools to identify trends, patterns, and opportunities.

  • Develop and maintain interactive dashboards and reports utilizing Tableau, Power BI, and other visualization platforms to communicate insights clearly and effectively.
  • Collaborate with business stakeholders to understand their needs, translate requirements into technical specifications, and deliver tailored data solutions.
  • Design and optimize database structures in Oracle, Microsoft SQL Server, and other relational databases to ensure efficient data storage and retrieval.
  • Manage project workflows by applying project management principles within the Software Development Life Cycle (SDLC), ensuring timely delivery of analytics projects.
  • Create detailed documentation of data processes, workflows, and system designs using Visio or similar tools for clarity and future reference.
  • Support database design efforts by implementing best practices in data modeling and VBA automation for process efficiency.
  • Utilize Bash (Unix shell) scripting to automate routine data tasks and streamline operations across different platforms.
  • Conduct business analysis to evaluate current systems, recommend improvements, and assist in the implementation of new analytical solutions.

Requirements

  • Proven experience with data analysis skills including proficiency in SQL for querying databases effectively.
  • Strong knowledge of visualization tools such as Tableau and Power BI for creating compelling dashboards.
  • Familiarity with programming languages like R and Python for statistical analysis and automation tasks.
  • Experience working with relational databases such as Oracle, Microsoft SQL Server, or similar systems.
  • Understanding of SDLC methodologies to manage analytics projects from conception through deployment.
  • Ability to perform business analysis by translating complex requirements into technical solutions.
  • Skills in database design principles along with experience in VBA scripting for automation purposes.
  • Competence in project management practices to coordinate multiple initiatives efficiently.
  • Excellent analysis skills combined with attention to detail; capable of interpreting large datasets accurately.
  • Proficiency with Visio or similar diagramming tools for documenting system architecture or workflows.

Benefits & conditions

Pulled from the full job description

  • Free parking
  • Casual dress

Apply for this position