Job Description:
We are looking for an experienced SQL Developer to become a valued member of our dynamic team. In the role of SQL Developer, 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 organization'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.
Duties and Responsibilities:
● A minimum of 3 years of hands-on experience in SQL development and administration, showcasing a strong proficiency in database management.
● A solid grasp of SQL database design, development, and optimization techniques.
● A Bachelor's degree in Computer Science, Information Technology, or a related field.
● An excellent understanding of DBT (Data Build Tool) and its practical application in data transformation and modelling.
● Proficiency in either Python or JavaScript, as these are commonly utilized for data-related tasks.
● Familiarity with NoSQL databases and their practical application in specific scenarios.
● 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.