Data Analyst

Jmr Software Pty Ltd; Johannesburg; On-site; ZAR 30 000 - 60 000; Full time

Job summary

An innovative company is seeking a Data Analyst / SQL Specialist to design and implement data solutions that drive business insights. In this role, you will leverage big data technologies on AWS to develop efficient ETL processes and optimize SQL queries for data analysis across various relational databases. Your expertise will contribute to enhancing database performance, managing data integrity, and generating insightful reports. Join a dynamic team where your skills in data management and analysis will be pivotal in supporting critical business functions and ensuring compliance with industry standards.

Qualifications

• Proven experience in SQL development and optimization for data extraction.
• Strong knowledge of big data technologies and data management best practices.

Responsibilities

• Write and optimize complex SQL queries for data extraction and analysis.
• Manage data import/export processes to ensure data integrity and accuracy.

Skills

SQL Development

Data Analysis

ETL Processes

Database Performance Tuning

Data Management

Education

Bachelor's degree in Computer Science

Bachelor's degree in Mathematics

Bachelor's degree in Life Sciences

Bachelor's degree in IT

Tools

AWS (Athena, Redshift, Lambda)

PostgreSQL

Oracle

Job description

Job Description: Data Analyst / SQL Specialist

Direct message the job poster from JMR Software PTY LTD. The ideal candidate will design data solutions across a range of tasks, from fast and clean ETL streams to automation.

Key Technologies: Experience with big data technologies on AWS cloud services such as Athena, Redshift, Lambda, CloudFormation Stack, and EMR.

Core Responsibilities:

1. SQL Development and Optimization: Write and optimize complex SQL queries for data extraction, manipulation, and analysis across relational databases like Oracle, Redshift, and PostgreSQL.
2. Data Management: Manage data import/export processes, ensure data consistency, accuracy, and integrity.
3. Database Performance Tuning: Improve database performance through indexing, query optimization, and resource management.
4. Data Analysis and Reporting: Generate reports, analyze data for insights, create stored procedures, triggers, views, and wrangle financial data for reconciliation.
5. Testing and Validation: Write test cases for data transformations.
6. Collaboration: Work with developers, system administrators, and stakeholders to align data systems with business goals, provide SQL support for application development.
7. Support and Troubleshooting: Resolve data issues, support production databases, and address user queries.
8. Documentation: Document SQL scripts, database schemas, and processes.
9. Compliance and Best Practices: Ensure adherence to industry standards and stay updated on new SQL technologies.

Qualifications: Bachelor's degree in Computer Science, Mathematics, Life Sciences, or IT.

Seniority Level: Mid-Senior level

Employment Type: Contract

Job Functions: Analyst, Consulting, Information Technology

Industries: Insurance, Banking, IT Services, and Consulting