Data Analyst (SQL)

We are looking for an experienced Data Analyst to become a valued member of our dynamic team. As a Data Analyst (SQL), you will be tasked with creating top-notch database solutions, fine-tuning SQL databases, and providing support for our applications and systems. Your proficiency in SQL database design, development, and optimization will be instrumental in delivering efficient and dependable solutions to fulfil our business requirements.

Responsibilities:

• Create high-quality database solutions that align with the organisation's requirements and standards.
• Design, manage, and fine-tune SQL databases, queries, and procedures to achieve optimal performance and scalability.
• Collaborate on the development of DBT pipelines to facilitate data transformation and modelling within our data warehouse.
• Evaluate and interpret ongoing business report requirements, gaining a clear understanding of the data necessary for insightful reporting.
• Conduct research to gather the essential data for constructing relevant and valuable reporting materials for stakeholders.
• Analyse existing SQL queries to identify areas for performance enhancements, implementing optimizations for greater efficiency.
• Propose new queries to extract meaningful insights from the data and enhance reporting capabilities.
• Develop procedures and scripts to ensure smooth data migration between systems, safeguarding data integrity.
• Deliver timely management reports on a scheduled basis to support decision-making processes.
• Investigate exceptions related to asset movements to maintain accurate and dependable data records.

Qualifications:

• Minimum of 3 years of hands-on experience in SQL development and administration, showcasing a strong proficiency in database management.
• Solid grasp of SQL database design, development, and optimization techniques.
• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Excellent understanding of DBT (Data Build Tool) and its practical application in data transformation and modelling.
• Experience with Airflow and real-time data pipelines.
• Proficiency in either JavaScript or Python, as these are commonly utilized for data-related tasks.
• Familiarity with NoSQL databases and their practical application in specific scenarios.
• Understanding of APIs and their integration in data workflows.
• Demonstrated commitment and pride in your work, with a focus on contributing to the company's overall success.
• Strong problem-solving skills and the ability to collaborate effectively within a team environment.
• Excellent interpersonal and communication skills that facilitate productive collaboration with colleagues and stakeholders.
• Familiarity with Agile development methodologies and tools that promote efficient project management and teamwork.