SQL Developer (Mid-level)

Open Box Software; Wes-Kaap; On-site; ZAR 500,000 - 700,000; Full time

Job summary

A leading consulting company is seeking a SQL Developer to join their dynamic team. This position involves supporting ERP systems, developing customized reporting solutions, and engaging directly with clients globally. The ideal candidate will have strong SQL skills, experience in data manipulation, and a solid understanding of finance or software principles.

Qualifications

• Minimum 4 years' experience working with and manipulating data.
• Finance/Software/Commerce orientated degree advantageous.
• Experience with support desk and client interaction is a plus.

Responsibilities

• Become a Subject Matter Expert on ERP Systems (e.g., MRI & Yardi).
• Interact with clients across the globe for query resolution.
• Create and manage reports using MS SQL.

Skills

SQL

Data Manipulation

Problem Solving

Communication

Education

3/4 year degree in Finance/Software/Commerce

Tools

MS SQL

SSRS

Crystal Reports

Power BI

Job description

Open Box Software is an internationally focused consulting company that specialises in business and software consulting services. We have a young team of highly talented individuals who are driven to make an impact and have fun.

We are looking for a SQL Developer to join our team on a permanent basis. The right person will be wanting to work within an intelligent, motivated, self-driven team with low egos, good communication skills and an effective problem-solving approach. You would also be very conscious of the importance of sharing knowledge and building other team members in the process. Our team must be able to tune into the needs of clients and their higher objectives to solve problems where not all the information is readily available.

Reporting directly to the Director of Enterprise Solutions, you will be involved in supporting our client's ERP systems and getting to grips with their internal business processes in order to implement customised reporting solutions. With a client base predominantly in the US, the ability to occasionally work flexible hours is key.

Key Responsibilities of Role

• Becoming a Subject Matter Expert on turnkey ERP Systems (such asMRI & Yardi) that our clients utilise and overseeing the support element of those systems.

• Understand the business processes of clients while collecting requirements and identifying possible solutions.

• Report design, maintenance and enhancement development.

Use MS SQL and application toolkits to:

• Create, change and manage reports.

• Access, investigate and extract data as needed.

• Manipulate data (correct, remove and add data).

• Test data for completeness and correctness.

• Format reports and data.

• Run reports.

Manage applications and provide support to users:

• Interact with clients across globe (telephone, email and teleconferences).

• Query investigation and resolution.

• Managing system customisations (Investigate systems and determine changes required + Document system and process changes).

• System configuration and administration.

• Problem escalation as needed.

• Deliver system training to users.

• Identify potential incidents to investigate.

Minimum Requirements

• Finance/Software/Commerce orientated 3/4 year degree or equivalent (e.g. B.Com Information Systems or B.Sc Comp Sci or Elec Eng) is advantageous.

• Minimum 4 years' experience of working with and manipulating data.

• Experience with support desk and client interaction would be advantageous.

• Strong SQL skills are essential.

• Knowledge of data extraction and modelling is advantageous.

• Exposure to MS Office, Access, Excel and/or other data mining and report writing tools (like SSRS, Crystal Reports and Power BI) is advantageous.

• Knowledge of basic Finance or Accounting Principles is desirable.

• Strong written and verbal communication skills.

• Comfortable with updating and communicating directly, with the client.

Personal Traits

• Friendly and easy going.

• Willing and wanting to work flexible times.

• Goal oriented.

• Passionate about problem solving.

• Team-oriented.

• Professional communicator.

• Self-motivated.