Johannesburg: SQL/Analyst Developer posted by Hire Resolve

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 .za

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.