Data Analyst/Data Modeler
Role details
Job location
Tech stack
Job description
- 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.
Requirements
Do you have experience in Spark?, 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., * 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.