Overview

Hire Resolve’s client is seeking a highly skilled and experienced SQL/Analyst Developer to join their team. The ideal candidate will have a solid background in SQL development, data analysis, and business intelligence. They will be responsible for designing, developing, and maintaining SQL-based solutions, as well as interpreting business requirements to deliver actionable insights. The role requires someone who is comfortable working with large datasets, optimizing database queries, and collaborating with cross-functional teams.

Key Responsibilities: SQL Development: Design, develop, and maintain complex SQL queries, stored procedures, and scripts to support business requirements and reporting needs. Data Analysis: Analyze and interpret large datasets to provide actionable insights and support business decision-making. Data Integration: Integrate data from multiple sources into databases, ensuring accuracy and consistency of data. Business Intelligence: Work with business stakeholders to understand reporting and analytical needs, developing and optimizing reports and dashboards. Database Optimization: Optimize and tune SQL queries for performance improvements, ensuring efficient data retrieval and storage. ETL Processes: Design and implement ETL (Extract, Transform, Load) processes to integrate data across systems and ensure data quality. Reporting: Develop and deliver regular reports and ad-hoc data analysis to meet business requirements. Collaboration: Collaborate with other developers, data scientists, business analysts, and stakeholders to define data requirements and deliver solutions that meet business goals. Documentation: Write clear technical documentation for queries, processes, and workflows to ensure knowledge sharing and maintainability. Troubleshooting: Identify and resolve data discrepancies, performance issues, and other technical challenges related to SQL and data processes. Required Skills & Qualifications: SQL Expertise: At least 3-5 years of hands-on experience with SQL (T-SQL, PL/SQL) and relational databases like SQL Server, MySQL, or Oracle. Data Analysis: Strong analytical skills with the ability to interpret complex data and translate business needs into technical solutions. Business Intelligence Tools: Experience with reporting and BI tools such as Power BI, Tableau, or SSRS (SQL Server Reporting Services) is preferred. ETL Development: Experience in developing and optimizing ETL processes using tools like SSIS, Informatica, or custom SQL-based solutions. Database Management: Proficient in database design, management, and optimization, with a solid understanding of indexing, query optimization, and normalization. Data Warehousing: Familiarity with data warehousing concepts and techniques is advantageous. Experience in Analytics: Experience in generating analytical reports, dashboards, and visualizations based on SQL queries and business data. Version Control: Familiarity with version control systems such as Git. Problem-Solving: Strong troubleshooting and problem-solving skills, especially with complex data queries and performance issues. Communication: Excellent verbal and written communication skills to collaborate with stakeholders and present data insights clearly. Desirable Skills: Programming Knowledge: Knowledge of programming languages like Python, R, or JavaScript for data manipulation or integration is a plus. Cloud Technologies: Familiarity with cloud platforms such as AWS, Azure, or Google Cloud for database and data pipeline management. Agile Methodologies: Experience working in Agile environments using Scrum or Kanban. Big Data Technologies: Exposure to big data technologies like Hadoop, Spark, or NoSQL databases is beneficial. Education & Qualifications: Degree/Diploma: A relevant degree or diploma in Computer Science, Information Systems, Engineering, or a related field is preferred. Certifications: Relevant certifications such as Microsoft Certified SQL Server Developer, Oracle Database Administrator, or other data/SQL-related certifications would be a plus.

Benefits:

Competitive salary based on experience.

IF you meet the above requirements and want to make a career-changing move, apply today by emailing your CV to itcareers@hireresolve.za.com

You can also connect with Daniel, Carmen and Gaby on LinkedIn or contact Hire Resolve
If you meet the above requirements we will contact you within 3 working days.

Apply for job