Home South Africa SQL Developer

Home South Africa SQL Developer

SQL Developer

at Digital Outsource Services in South Africa
Posted on January 9, 2024

Job details

Kick-start your career in the online gaming world and experience the very latest in technology and innovation. The Department: Enterprise Risk Support owns a diverse set of products with multiple capabilities. To effectively support these products, our teams require a diverse set of software development skills and strong product knowledge geared for delivery. We build market leading platforms and software to support out the box configuration of our brands and markets. Be part of building a robust, and bespoke platform that supports loosely coupled off the shelf components that can be easily added, configured, or removed as required. As part of the Data Team, we deliver information to the company that is timely, accurate, reliable, and relevant. Our information is utilised across the entire business from front facing customer hosts through to executives. Data originates from a multitude of external sources and is then warehoused and processed into meaningful information. Ongoing analysis and evaluation of results is a daily function. All information systems are designed to provide ease of access, to be extracted on a self-service basis by all users. This candidate will report to the Team Lead in the Data Team. Purpose of the Role: A role exists for an Intermediate BI Developer in an online organization with a good history and strong Data Team. This role requires a motivated, energetic, inquisitive, and highly numerate person who has a solid technical base but also possesses an appreciation for numbers and understands the value that can be derived from interrogating them. This candidate will report to the Team Lead in the Data Team. Duties include, but not limited to: Integration of new sources of data into company databases so that it can also be analysed and included in relevant processes and pushed to the ERP. Integration of data into relevant workflow processes, with the specific aim of continuously improvement and data optimization. Work with all levels of development from analysis through implementation and support. Designing new database structures or enhancing existing ones to cater for optimal process flow and optimal user querying. Develop and test issues aligned to specifications. Work with the project team across functional areas. Analysis of data from various sources to ensure that the business acts proactively on the information at its disposal. Continually searching for new and useful ways to obtain, integrate and analyze data that is relevant to the company’s business model. Identify ways to improve data reliability, efficiency, and quality. Performing root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement. Experience performing root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement. Identify ways to improve and automate data delivery and quality in the ETL processes. Guide and mentor junior resources when needed. Education of report end-users so as to ensure a maximum spread of expertise around the company. This job description is not intended to be an exhaustive list of responsibilities. The job holder may be required to complete any other reasonable duties in order to achieve business objectives. Undergraduate degree (or substantial progress towards one) with majors in IS / math / stats / engineering or similar. Alternatively, at least 2 years work experience in a business intelligence role will be considered. A relevant post-graduate degree will be a strong plus. 2+ years strong SQL experience (creation of stored procedures, functions, automation of jobs, performance tuning and optimization, RDBMS, error handling and logging, incremental data loading, change tracking/cdc. etc.). Minimum 2 years SSIS experience (creation of complex ETL (Extract, Transform, Load) processes, error handling, loading data from various data sources (flat files, xml), integration of new data into data warehouse, precedence constraints, parameterized connections, etc.). Ability to build reports in Excel and reporting tools such as Power BI. Minimum of 2 years’ experience in front end visualization tools such as Power BI/ Qlikview /Tableau/ Grafana (creation, implementation and maintenance of analytical dashboards and visualisations). Advanced skills in MS Excel. Be able to give accurate technical estimates. Driving new solutions based on business requirements. Strong communication skills, ability to mentor others. Demonstrates consistent behavior aligned to the Combiined F and Organizational Culture. Experience integrating with API Solutions. Experience in data analysis and reconciliation will be advantageous. DBA experience. Knowledge of event-driven programming. Minimum of 2 years’ experience with OLAP reporting tools and cube technologies, such as SSAS (creation, implementation and maintenance of multi-dimensional cubes, MDX, DAX). Person Specifications: Stress Tolerance Numbers Problem Solving Organisation & Planning Interpersonal Skills Communication Adaptability / Flexibility *Please note we will apply relevance to our Talent Management and Talent Development Programme as part of our recruitment process. *Shortlisted candidates may need to complete an assessment.   This position requires trust and honesty it has access to customers financial details - therefore a credit and criminal record check will be conducted. The qualifications identified herein are an inherent job requirement; therefore, a qualification verification check will be done. By applying for this role, and supplying the necessary details, you hereby grant us permission to apply for these checks. This will be done in a confidential manner, and solely for the purposes of verification. Should you not hear from us within 2 weeks, please deem your application as unsuccessful. The perfect place to work, play and grow! We believe in hiring talented, hardworking and ambitious people from all over the world. In return, we ensure a supportive working environment, access to leading edge technologies and a commitment to social awareness and equity. Working in this unique and highly competitive industry means that we have to take risks and be innovative. The way we do this is by allowing for mistakes, but also making sure we learn from them. And with a multi-cultural workforce that’s unparalleled in its diversity and dynamism, we also offer plenty of scope to grow on a personal level too. Best of all, we do this while enjoying ourselves as much as possible!#J-18808-Ljbffr

Apply safely

To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.

Share this job
Improve your chance to get this job. Do an online course on SQL Server starting now. Claim $10 promo towards online courses. See all courses
See All SQL Jobs
Feedback Feedback