SQL/Analyst Developer

Job Description

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 SQL/Analyst Developer

Submit your application for this position at Hire Resolve

Add a few notes about your experience first for a more personal draft. You can edit the draft before submitting.

PDF, DOC, or DOCX (max 5MB)

Ready to Apply?

Submit your application for this position