IT
SQL/Analyst Developer
Hire Resolve
Johannesburg, Gauteng
Permanent
Apply
Posted 13 December 2024

Job Details

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 [email protected]

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.