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.