Overview

We are seeking a highly skilled Data Analyst/Data Modeler to join our dynamic team. This role involves designing, developing, and maintaining robust data models and analytical solutions to support strategic decision-making processes. The ideal candidate will possess strong expertise in database systems, big data technologies, and cloud platforms, with a keen eye for detail and a passion for data-driven insights. This is a paid position suitable for experienced professionals or talented interns eager to develop their careers in data analytics and modelling.

Responsibilities

• Develop and implement comprehensive data models to optimise data storage, retrieval, and analysis.
• Design and maintain data warehouses and data lakes using tools such as Hadoop, Spark, and related big data frameworks.
• Utilise SQL, NoSQL (including MongoDB or similar), and other query languages to extract, manipulate, and analyse large datasets.
• Collaborate with cross-functional teams to understand business requirements and translate them into effective data solutions.
• Build scalable ETL pipelines using tools such as Informatica, Azure Data Factory, or equivalent.
• Manage cloud-based data environments on platforms like AWS and Azure, ensuring security and efficiency.
• Write complex scripts using Python, Bash (Unix shell), Java, or similar languages for automation and data processing tasks.
• Conduct database design activities ensuring optimal performance with systems such as Oracle, Microsoft SQL Server, or equivalent.
• Apply best practices in data modelling and architecture to support analytics initiatives.
• Monitor system performance and troubleshoot issues proactively to minimise downtime.

Skills

• Extensive experience with SQL databases including Oracle, Microsoft SQL Server.
• Proficiency in NoSQL databases such as MongoDB or DynamoDB.
• Strong knowledge of cloud platforms like AWS and Azure for data storage and processing.
• Hands-on experience with big data tools including Hadoop, Spark, and related ecosystems.
• Expertise in programming languages such as Python, Java, Bash (Unix shell).
• Solid understanding of data modelling principles and database design techniques.
• Familiarity with ETL processes using Informatica or similar tools.
• Knowledge of Data Warehouse architecture concepts.
• Experience working with cloud-based data solutions on AWS or Azure environments.
• Excellent analytical skills with the ability to interpret complex datasets. This role offers an exciting opportunity to work at the forefront of data technology within a collaborative environment. Candidates should demonstrate a proactive approach towards problem-solving and continuous learning to thrive in this position.

Pay: £36,449.97-£95,024.64 per year

Work Location: Remote